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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS DNS error help !

Author  Topic 

JT
Starting Member

1 Post

Posted - 2004-09-24 : 14:43:29
I’m getting a syntax error when I try to use a fully qualified DNS name in the destination for a .csv file. The Servers’ DNS name has a hyphen or dash (‘-‘) in it so the string looks like : \\My-Server.MySite.MyDomain\Folder\Destination\file.csv. DTS seems to think it's a parameter. Is there a way to delimit required values within the string like the server name using quotes or parenthesis ? Thanks.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2004-09-27 : 06:37:54
This is a problem as -S is treated as the parameter, it is only a problem with -S. If you post the exact error message you are getting (or put the error into technet, there is a page on microsoft's site about this...
Go to Top of Page
   

- Advertisement -