SSIS DataTransformation

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

suresh14y ago
Thanks for the reply Ellen,

when SSIS run it has to show all the values or none of them.But it getting some records..missing some records.....but missing records are also same datatype and same datalength.Whether it is best to use SSIS or any other method to get records from server.

Please give me solution, thanks in advance.
Ellen Hu14y ago
you should carefully look at your SSIS package again.

Although your source & destination tables are exaxtly same by having same columns, same data type and length, the SSIS will give you the default value "50" which is far less then what you are expected(look at your data conversion if you have in your package). You need go to property to modify those values properly.

Wish could help out.

ellen