question

AbhiD avatar image
AbhiD asked

Sql SSIS Error

Hi, I am getting this error [DTS.Pipeline] Information: "component "OLE DB Destination" (9)" wrote 0 rows. I m using a csv file source, a derived column to add current date and a ole db destination. I have added data viewers just before and after the derived column and I can see the data in both the data viewers. I can see that 23000 rows comes from source to derived column and 23000 rows flows from Derived column towards oledb destination table ... But I dont have anything in the destination table. Thanks,
ssis
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
aRookieBIdev avatar image
aRookieBIdev answered
pls check the data types in the destination tables, especially the new date column.you might have to use a dataconversion transformation to match them.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

AbhiD avatar image AbhiD commented ·
i checked all the data types and they are all fine. but now the oledb writes only 22 rows out of 23000 rows ..
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.