|
Home > Archive > MS SQL Server DTS > July 2005 > Change 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 |
Change Connection's catalog name dynamically
|
|
| Rajesh Patel 2005-07-19, 8:24 pm |
| 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
| |
| Darren Green 2005-07-20, 8:24 pm |
| In message <1121803989.458616.204140@g49g2000cwa.googlegroups.com>,
Rajesh Patel <rdp647@hotmail.com> writes
>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
|
|
|
|
|