November 7, 2007 at 9:41 am
I've got a simple dts package that imports a single data value from a text file into a single column in a database table. What I want to do is set an additional indicator column in the table to '1'. How best to complete this?
Thank you
November 7, 2007 at 1:05 pm
a simple approach if you want to accomplish this task in the DTS transformation and assuming that you have another column in the destination table is to walk through the following steps:
Double click your transformation between the flat file and the destination, click on the transformations tab and select the New button.
When the types arrive, select ActiveX Script as the Transformation Type
On the General Tab, click on the Properties button to get to the Script.
In the script, type in the following: DTSDestination("field_name") = "1"
Click OK and in the Source Tab deselect any columns, in the Destination Tab ensure that your field_name is selected.
Hope this helps.
November 8, 2007 at 11:26 am
the one thing I got right was I figured this wasn't too difficult and should be easy enough to do I just didn't know how to do it - and you proved me right - thank you so much you're genius
thank you
thank you
thank you
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply