September 26, 2006 at 7:43 am
The Derived Column Transform component will do this. You put it between the data source and the destination, and use expressions to define new columns. The destination will see both the original columns and the new columns as inputs, you have to make sure you connect the transformed columns to the destination columns.
If you have something more complicated that a simple expression can't handle, you can use a script transform component. It requires more programming, but is much more powerful.
September 26, 2006 at 8:20 am
That's where I am having the issue. I have tried to copy the ActiveX script into the script component but it looks like the language/format is different.
September 26, 2006 at 9:11 am
If it was as simple as copying the script, the upgrade wizard could do it for you. SSIS scripting is done in VB.NET instead of VBScript.
Most of it is not much different. (Heavy emphasis on the weasel words). If you reference any package variables or the DTS object model, it is completely different.
There's no magic bullet here, you'll have to actually read the documentation and learn how SSIS works. These web sites have can help you:
http://blogs.conchango.com/jamiethomson/default.aspx
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply