Changing the DTS Destination Programmatically...

Question

Changing the DTS Destination Programmatically...

hneal_98

SSC Enthusiast

Points: 118
More actions
August 28, 2002 at 1:41 pm

#105675

Does anyone know how to change the destination of a DTS package programmatically in VB? I would like to be able to have it changed dynamically each time it is run.
Thanks in advance.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Andy Warren SSC Guru Points: 119902 More actions · Answer 1

Usually not too hard to do. Start by saving out the package as VB code, then look through to find exactly where in the code the property is getting set that has the location. Once you know that, then you can set a reference to the DTS library in VB, open the package, alter the property, then save the package.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter

hneal_98 SSC Enthusiast Points: 118 More actions · Answer 2

quote:
Usually not too hard to do. Start by saving out the package as VB code, then look through to find exactly where in the code the property is getting set that has the location. Once you know that, then you can set a reference to the DTS library in VB, open the package, alter the property, then save the package.
Andy
http://www.sqlservercentral.com/columnists/awarren/

Good idea.

Thanks.

mhweiss SSCarpal Tunnel Points: 4284 More actions · Answer 3

You want to specify a destination file dynamically? You could also look into the dynamic properties task...with that you can set a global variable dynamically and set your transformation task destination to the global variable. Also, you could set the destination dynamically via an ActiveX task...if you think this would fit what you need to do and you want some direction, let me know and I have some code I can send to you that would get you started at least..

hth,

Michael

Michael Weiss

hneal_98 SSC Enthusiast Points: 118 More actions · Answer 4

quote:
You want to specify a destination file dynamically? You could also look into the dynamic properties task...with that you can set a global variable dynamically and set your transformation task destination to the global variable. Also, you could set the destination dynamically via an ActiveX task...if you think this would fit what you need to do and you want some direction, let me know and I have some code I can send to you that would get you started at least..
hth,
Michael
Michael Weiss

This looks great as well. If you could email me the code, i would greatly appreciate it.

Thanks