Is it possible to change Data Source or copy the contents of a ''Transform Data Task''?
-
Good morning! Can anyone tell me if it is possible to change a data source from MS OLE DB Provider for SQL Server to a Microsoft Data Link? Or to copy what is in a Transform Data Task?
I am in the process of converting a legacy Btrieve system to SQL, and am new to using DTS. I have created several packages that used the MS OLE DB Provider, with quite a bit of logic in the Transform Data Task (VB Script, etc.) I have been told that I can gain more flexibility in my target database by switching to a data source of a type of Microsoft Data Link, employing a UDL to identify the data source.
I would like to do this with all of my existing packages, but do not want to throw away or copy/paste each transformation that is in the coding that is behind the Transfer Data Task portion.
I would be very grateful for any suggestions that anyone has to offer.
Thanks in advance for your help and consideration!
Cheryl
-
Hi Cheryl,
Yes, you can change a connection without having to recreate the Transform Data task.
First, create Data Link connection in the package. Then, open the properties of the OLE DB connection, click on the pull-down for Existing Connection, and choose the Data Link connection. Click OK and OK the Task Refrences message that will pop up. Last, delete the OLE DB connection.
Hope this helps.
Greg
Greg
-
Greg,
That worked great! I was NOT looking forward to recreating all of my scripts. Thank you SO much for your help.
Cheryl
-
I'm glad it worked for you. I had to learn the hard way through trial and error. No use everyone going through that!
Greg
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply