suresh

suresh

  • NA
  • 293
  • 0

SSIS DataTransformation

Dec 1 2011 12:06 PM
hi,
i have problem with exporting records using SSIS, when i export record from one table to anthor table(two different servers) using SSIS so many records are missing.
Ex:I have source table with 200 records , but i am getting into the destination table only 120 records...so remaining 80 records are missing...

This ssis will run by the sql job for every 30 minutes.....
Daily i am missing the records..
the source table and destination table columns and data tyes are same.
1)call_Date datetime
 2)originalcalledpartynumber varchar 50
3)callingpartynumber varchar 50
4)duration varchar  6
5)DateTimeOrigination varchar 50
but i am getting some warning messages in the SSIS when i run it manually like this
[OLE DB Destination [385]] Warning: Truncation may occur due to inserting data from data flow column "originalcalledpartynumber" with a length of 8000 to database column "originalcalledpartynumber" with a length of 50.
[OLE DB Destination [385]] Warning: Truncation may occur due to inserting data from data flow column "callingpartynumber" with a length of 8000 to database column "callingpartynumber" with a length of 50.
[OLE DB Destination [385]] Warning: Truncation may occur due to inserting data from data flow column "duration" with a length of 50 to database column "duration" with a length of 6.
[OLE DB Destination [385]] Warning: The external metadata column collection is out of synchronization with the data source columns. The column "DateTimeOrigination" needs to be updated in the external metadata column collection.
 
please give me some solution,thanks in advance.

Answers (2)