CODEWITHSUNDEEP
sql-serverssisssms
user10349555
user10349555

Reputation:

SSIS Package says execution completed with success but there is no data in my table?

I have this SSIS package that imports data from a tab file into my SQL Server. When I debug or execute it shows that all the rows have gone through as in the following

enter image description here

But every time I go check the table in SQL Server it shows up like this:

enter image description here

Any ideas?

Upvotes: 0

Views: 7474

Answers (2)

Proximus Seraphim Dimitri Davi
Proximus Seraphim Dimitri Davi

Reputation: 313

I had this problem a while back. The problem is that you probably have your Error Output to ignore failure. Put it back to Fail Component. Now this is the tedious part. Debug this and it WILL error. But the error will tell you which column it is that is messing up and why. From there, go back to your SQL server database table and see what the data type is for that column, go back to your ConnectionFlatFile source and change that column to what it is in SQL Server. Rinse and repeat till you don't get any more errors and all the rows by the end of it should be in your database.

I don't know about a faster way but when i first set up a database i imported a bunch of flat files all as string[DT_STR] 255 just because it was the quickest.... but then i had to go back and fix each column datatype. Hope this helps.

Upvotes: 2

VB_isYoung
VB_isYoung

Reputation: 83

The logs can be viewed in the "Progress" tab. That must show 262927 records inserted to the destination table.

Upvotes: 0

Related Questions