February 14, 2005 at 6:36 pm
I'm using DTS of SQL Server 2005 to transfer data from Oracle 10g into SQL Server 2005. The transformation is very comflex, so I have to use script component. But I don't have any document about it or any sample code.
Pls help me to find them.
Very urgent.
Thanks
February 16, 2005 at 1:01 pm
I am/was in a similar situation, transferring data from Oracle and I needed to use the Script Component. The official documentation is sparse. Here are some tips:
- After you add the Script Component and attach an input, double-click the Script Component to open the Script Transform Editor.
- Goto the "Input Column" section and select the columns you want the script to access. Make sure to select Read/Write for the columns you need to manipulate in your script.
- Click on the "Script Section". Click on the "Design Script..." button at the bottom to open up the script editor.
- In the script editor, there will be a default Sub that has a Row object as a parameter. The Row object has properties that correspond to each individual column specified you selected as an Input Column. Check out the intellisense and you'll see what I'm talking about.
- When you're script is debugged and done, set the Precompile to True for better performance.
Hope that helps a little.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply