Hi all,
I have created a DTS package that imports Cobolt data into a SQL Server 2000 table. Inside the DTS package I'm also trying to transform the Cobolt data(000100]) into a numeric string (0001000). The SQL statement I am using inlists a cursor to find the bad numbers and then loops through and updates the field appropriately. I have run the cursor SQL statement in query anaylzer and it works fine. However, inside the package it is not working at all. Is there some issues with cursors inside a DTS package I should know about?
Thanks,
Wanda