AXISHK
asked on
Missing record with ADO DB Command in SSIS 2008
I have created a DTSX package and it could run successfully and write 2622 rows into the database. Afterwards, I select the table and contains only 265 records and I need to run the package serveral time in order to commit all records. Any idea on this ?
Thanks
OLE-DB.png
Thanks
OLE-DB.png
Silly question maybe, but what happens if you use the "OLE DB Destination"?
ASKER
Yes, seem fine after several test.
Do it implie something wrong / no strong for ADO destination ?
Tks
Do it implie something wrong / no strong for ADO destination ?
Tks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tks.