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)
 DTS 2000 - Export sproc - blank transform cols

Author  Topic 

TerryC
Starting Member

1 Post

Posted - 2008-08-06 : 07:48:06
Hi,

I am trying to import results using a SQL query (exec stored proc on Sybase source) to a SQL 2000 target. When I setup the Transform Data task I am unable to setup any Transformations as no source columns are displayed?? The query parses ok and the preview shows the first 200 rows ok - so source looks good!

Any help appreciated.

Regards,
   

- Advertisement -