Tak Connection's catalog name dynamically. -- sql server (microsoft)

Tibor Karaszi
7/19/2005 12:00:00 AM

Did you use "dynamic properties" in your DTS package?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

[quoted text, click to view]

Rajesh Patel
7/19/2005 8:43:33 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

Rajesh Patel
7/19/2005 9:05:52 AM

Yes, I am using it. Via Dynamic properties task, I set connection's
catalog and datasource properties to global variables.

Thanks

Rajesh

[quoted text, click to view]

Rajesh Patel
7/19/2005 9:18:06 AM

I think, I got the solution. It was my fault. My query was referring
server and databasename in FROM clause. I removed that.

minor mistakes!!!

Thanks any way,

Rajesh

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server (microsoft)

sql server (microsoft) : Tak Connection's catalog name dynamically.