DTS error : Cannot open database requested in login

[Windy77]

I have inherited two DTS packages with the same name (in two different SQL (2000) Servers). I need to find out what they do to see why we have two versions so I right click to "Design Package" to see the Source is a Text file (csv) and the Destination or Result is a SQL table.

However when I right click the Transform Data Task and select "Properties", if I then click on either the "Destination" or "Transformation" tabs, then I get the following error message :

Package Error

Error Source : Microsoft OLE DB Provider for SQL Server

Error Description : Cannot open database requested in login 'ProcessFilesIN'. Login Fails

(Where 'ProcessFilesIN' is the name of the database that I expect the table will be Transformed into).

Does anyone have any ideas what the problem is ?

Or alternately, is there any way of extracting a script from each of the DTS Packages to see what they're both doing ? I've looked in BOL & also checked around in DTS within SQL Enterprise Manager & can't find any obvious options (now someone is going to say "it's the big flashing red button that says DTS SCRIPT WIZZARD&quot.

 

[Windy77]

OK, so I can now answer part of my own question. If you use the "save as" option to save the DTS Package as a "Visual Basic file" then you can compare the scripts in VB.

Having compared them, the only difference I can see between the two versions is the Connection Server Name for the Transformation Database, which is OK except we've (we the department rather than we including me in the plans) merged two SQL Servers into one on a new Server, which included a rename. This means I still need to get round the original problem to allow me to change the DTS Package to the new server name.

Paul