December 21, 2001 at 12:23 am
Dear all,
how can i change the source i.e database table and destination text file dynamically through vb application.
Thank You
December 21, 2001 at 4:49 am
The easiest way is to save the package as VB source code, then look through it to find the properties you need to change. Once you know the exact syntax, to do it from VB you just need a reference to the DTS package library, then:
-open the package
-make your change
-save and/or execute the package
Typically about 10-15 lines of code.
Andy
December 21, 2001 at 10:25 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy