Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hyukevain
Yak Posting Veteran
66 Posts |
 Posted - 2004-07-22 : 23:02:40
|
| Hello,I have created a DTS that can transfer table content to text file and it work sucessfully when I run it in my server. The source database is SQL Server.I want to use dynamic server name, userID and Password so when I put the package to another server, the DTS package will still working,so I use Global Variable to set server, user and password by passing the parameter to this GV when I run DTSRun command.I use Dynamic Properties Task to set the GVs data to my db connection.The problem is, when I run the DTS Package trough DTSRun command, I received this error :Error = -2147467259 (80004005)Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.Error source: Microsoft OLE DB Provider for SQL ServerCan anybody help me by solving this problem ?Thank's and sorry for my English.Regards,Mike |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-07-25 : 17:57:53
|
| Get it to log the connection info. Sounds like you are not setting a correct server name or uid/pwd.Make sure the dnamic propertes task is one of the first things to run - i.e. before the connection is established.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Hyukevain
Yak Posting Veteran
66 Posts |
Posted - 2004-07-28 : 07:06:45
|
| Thank's for the hint, when I execute the DTSRun command, accidently I added space before server name. |
|
|
|
|
|
|
Global Variable In DTS