Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER Expand / Collapse
Author
Message
Posted Thursday, April 4, 2013 9:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 11, 2014 9:02 AM
Points: 5, Visits: 86
Thanks a lot Padraig... Worked for my case as well.
Post #1438863
Posted Wednesday, June 5, 2013 10:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 7, 2013 5:18 AM
Points: 1, Visits: 8
Using the hints to set Project Properties Run64BitRuntime = FALSE, the SSIS pkg did run, but instead of the 17,622 rows that the SSIS Data Flow module shows entering the OLEDB Destination module, it only wrote out 762 rows to the SQL table?? Shows no errors either??

Under Progress tab:
[SSIS.Pipeline] Information: "component "OLE DB Destination" (304)" wrote 772 rows.

Everything is GREEN in SSIS both under Control Flow & Data Flow (shows 17,622 rows going into the OLEDB Destination module), but I am not getting all rows into my SQL table?

Any ideas or hints as to what I am doing wrong?
Post #1460320
Posted Friday, June 7, 2013 1:02 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 1:00 PM
Points: 457, Visits: 218
Thanks Padraig, it works in sql 2010 as well. Saved my tookus it did, yesss.
Post #1461195
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse