Change Connection's catalog name dynamically

#1

Hi,

I am sorry to post it again.

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

I am using "dynamic properties task". I set dbname in global variable
and it works fine in sqlserver. But, when I execute that package with
vb.net DTS API and changin dbname global variable via vb.net code. It
seems that, It's not taking the updated value.

Can I have any hint on this?

Thanks

Rajesh

#2

In message <1121803989.458616.204140 (AT) g49g2000cwa (DOT) googlegroups.com>,
Rajesh Patel <rdp647 (AT) hotmail (DOT) com> writes

Quote:

Hi,

I am sorry to post it again.

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

I am using "dynamic properties task". I set dbname in global variable
and it works fine in sqlserver. But, when I execute that package with
vb.net DTS API and changin dbname global variable via vb.net code. It
seems that, It's not taking the updated value.

Can I have any hint on this?

Thanks

Rajesh

I've tried to answer on the old thread....

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Change Connection's catalog name dynamically

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Change Connection's catalog name dynamically - 07-19-2005 , 03:13 PM

Re: Change Connection's catalog name dynamically - 07-20-2005 , 02:59 PM