Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 No data showing in Destination fileds

Author  Topic 

rookie_sql
Constraint Violating Yak Guru

443 Posts

Posted - 2007-04-17 : 06:23:25
Hi i've a DTS package were i move data from one server to another,
When i do a test on the transformation i see all the fileds coming up in the test, which i know is a temp.txt file , but when i run the package some of the fileds do not copy accross, this has only happened today yesterday last week etc..it was fine, all am getting is NULL in the destination filed.

Any ideas ?
   

- Advertisement -