sql server - Connection Leak Issue with SSIS 2014 & Postgres ODBC -


i'm working on project client involves pretty huge etl process move data mssql server postgres. using ssis 2014 odbc drivers provided on postgresql.org, , have setup odbc dsn. using built in oledb sources , odbc destinations, , running issue have not been able find referenced anywhere else online.

the exact issue ssis seems open multiple connections each odbc destination data flow component, connection pooling enabled. can result in 50+ idle connections being opened, not killed until process completed. previewing data visual studio causes connection leaks killed upon restarting visual studio. have temporarily resolved increasing maximum connections 1000, hoping fix underlying problem if possible.

i've done decent amount of experimentation, , issue seems ssis related opposed error in driver.

has else run similar issue , know how resolve this?

edit: thought wasn't going big issue, realize odbc connections leaking when ssis package run integration services well. i've played bit making empty packages , adding single odbc source , package accesses database c# script task; odbc source/destinations causing leaking , not script components, seems bug in ssis , not script tasks or postgres driver :o

anyone have idea how resolve besides rewriting whole package not use odbc sources/destinations (or other weird thing killing connections afterwards shell script)?


Comments

Post a Comment

Popular posts from this blog

java - Spring Data JPA: Why findOne(id) executing delete query internally? -

i have 1 application using @manytomany annotation link 2 different entities 1 parent entity. not sure if have implemented properly. when execute .findone() on parent entity's repository find it, @ first fetch data along executing delete queries internally delete record mapping table (a table jpa creates after adding @manytomany annotation.). following generated sql queries , code snippet: java class @entity @table(name = "inventory") public class inventory { @id long id; // many other properties @manytomany(fetch=fetchtype.lazy) private list<stream> streams; @manytomany(fetch=fetchtype.lazy) private list<subject> subjects; } there no other annotation i've put in stream , subject entity class link inventory class. when run app, create following tables: inventory stream subject inventory_stream inventory_subject (inventory_stream , inventory_subject, 2 tables created automatically, don't k...
Read more

python - Mongodb How to add addtional information when aggregating? -

i beginner , wrote line pipeline works, wanna add other information output, screen name , or number of tweets.i tried add under $group gave me syntax error everytime here pipeline: def make_pipeline(): # complete aggregation pipeline pipeline = [ { '$match': { "user.statuses_count": {"$gt":99 }, "user.time_zone": "brasilia" } }, { "$group": { "_id": "$user.id", "followers": { "$max": "$user.followers_count" } } }, { "$sort": { "followers": -1 } }, { "$limit" : 1 } ]; i using on example : { "_id" : objectid("5304e2e3cc9e684aa98bef97"), "text" : "first week of school on :p", "in_reply_to_status_id" : null, "retweet_count" : null, ...
Read more

java - Incorrect order of records in M-M relationship in hibernate -

Image
i have 4 records in bridge table in mysql database. using @manytomany in hibernate, accurate order of employees incorrect incorrect of projects. following required material figure out doing mistake. this source. @entity @table(name="project") public class projectbean { @id @generatedvalue @column(name="project_id") private int projectid; @column(name="title") private string projecttitle; @manytomany(mappedby="projects") private collection<employeebean> employees; public projectbean() { employees = new arraylist<employeebean>(); } //getters & setters } @entity @table(name="employee") public class employeebean { @id @generatedvalue @column(name="employee_id") private int employee_id; @column(name="first_name") private string ...
Read more