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)
 export Data when you just have the connection

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-09-25 : 08:12:48
Babak writes "I know that BCP and DTS are data import/export tools.
I have a simple csv file to import. this is part of an application and the only thing that I have is the connection and not the UserId and Password.
Any help appriciated
Babak"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-09-25 : 12:07:12
You'll need the file, the name of the SQL Server to connect to, and you'll need to pass some credentials for the SQL Server, whether it be your domain name or a sql account. You do not need a userid and password for the file.

Tara
Go to Top of Page
   

- Advertisement -