MS SQL Server DTS - Tak Connection's catalog name dynamically.

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Tak Connection's catalog name dynamically.

Rajesh Patel

2005-07-19, 11:23 am

Hi,

I have created DTS package in the SQLServer 2000. Now, I would like to
execute this package for multiple databases under the same sqlserver.

How can I do that?

I am trying to change it's connection's catalog property via VB.Net.
But, It seems that it's not changing and everytime I am getting results
from the same database, which I configured in DTS package. I tried to
work with Global variables. But, does not help. It's the same.

I appretiate your help.

Thank you,
Rajesh

Sponsored Links