-
DTS and Cursors
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|