Querying for Database in Connection Information...

FAQ

Profile

Querying for Database in Connection Information...

Database Help (Home) -> DTS

Next: Hyperlink to open specific record

Author

Message

SQLSQUIRREL

External

Since: Jan 31, 2008
Posts: 3

(Msg. 1) Posted: Tue Dec 23, 2008 3:02 pm Post subject: Querying for Database in Connection Information... Archived from groups: microsoft>public>sqlserver>dts (more info?)

Hello... I am currently going through a SQL Server consolidation project and have numerous DTS packages across numerous servers that need to identified and migrated over to SQL Server 2005. Presently, I am manually going through each DTS package and going into the SQL Server data source to find which database the source is pointing to. Now, how for the love of cheese can I programmatically go through each DTS package for a given server looking for a specific reference to a database name in the connection information and return back to me the name of the DTS package that has this reference? Please advise... Cheers! Brett >> Stay informed about: Querying for Database in Connection Information...

Display posts from previous:

Related Topics:

How to update connection manager information programmatica.. - Hi, all here, I will have to update all connection managers information for all of our DTS packages which is daunting. Instead of going through each package and update the connection manager information manually I wonder if there is anyway of doing it...

Passing a Parameter from another database connection to Da.. - Could someone advise me to the best practice to achive the following objective? Thank you Objective: Use a field value of another database and table in the as a condition in the Data Pump SQL Query

How to set the Script Manager Database Connection String - Hi, I am using the Script manager within SSIS to execute query. Currently I have the connection string hardcoded. How do I tie the connection string to the DTS package Connection Manager Connections so there is only one place to change the connection fo...

Unexpected internal error when querying cube data - I have a DTS package in SQL Server 2000 which brings together data from different sources, including from an Analysis Services cube, and compares it. Usually this runs perfectly, but sometimes I get an unexpected internal error from the Data Pump task...

Set up connections once per task? - If transferring multiple tables between source connection and destination connection I can create these connections once and then define multiple tasks between those two connections, but I don't appear to have any control over sequence or "only do t...

	Database Help (Home) -> DTS	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum