?
Solved

Missing record with ADO DB Command in SSIS 2008

Posted on 2011-10-13
4
Medium Priority
?
226 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:AXISHK
  • 2
  • 2
4 Comments
 
LVL 37

Expert Comment

by:ValentinoV
ID: 36966736
Silly question maybe, but what happens if you use the "OLE DB Destination"?
0
 

Author Comment

by:AXISHK
ID: 36966799
Yes, seem fine after several test.

Do it implie something wrong / no strong for ADO destination ?

Tks
0
 
LVL 37

Accepted Solution

by:
ValentinoV earned 2000 total points
ID: 36966864
Not sure how that could have happened, but if OLE DB works fine, then I'd use that one.  To be honest,  I've always used OLE DB instead of ADO .NET to write to SQL Server destinations.

BTW: to get the fastest possible inserts, set Data Access Mode to "Table/view - fast load".
0
 

Author Closing Comment

by:AXISHK
ID: 36966952
Tks.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Screencast - Getting to Know the Pipeline

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question