July 24, 2008 at 2:38 am
Hi There,
in the sql 2000 dts packages, when creating a transformation you could within the vb script reference and map the destination columns and the source columns like this:
DTSDestination("ACC_ID") = DTSSource("Col001")
where DTSDestination is a sql database and DTSSource is a csv file
my question is how do you do the same thing in the new SSIS script component using vb.net. How do you refer to the source and destination columns and how do you map them at the code level?
Also does anybody know a good book or website which covers this kind of thing eg how to reference objects in an SSIS package from script component in vb.net
many thanks
July 24, 2008 at 10:14 am
http://technet.microsoft.com/en-us/library/ms135952.aspx would be a good start.
I am sure you can find examples on the web too.
~Mukti
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply