Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gmmastros on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing Text file problem for DTS

Status
Not open for further replies.
timscronin

timscronin

MIS
Jun 27, 2001
837
0
0
US
I have 2 SQL 2000 SP3 servers, one local, the other at a client site. I have a DTS package to FTP to get a file and then import the text file into a SQL table. On my local box works fine, at the client whether I use DTS or just try to import the file, it can't find the end of record/return for each row. Both SQL Server versions show the same with @@version. My guess is some DLL is messed up that handles the import. Anyone seen this before, was going to try calling MS today.
Thanks
 
Status
Not open for further replies.

Similar threads

RRinTetons
  • Locked
  • Question
Tool for job scheduling
Replies
0
Views
54
RRinTetons
RRinTetons
Rajesh Karunakaran
  • Locked
  • Question
Restoring/Importing data from 2 backup files one after the other
Replies
0
Views
34
Rajesh Karunakaran
Rajesh Karunakaran
Richard Parry
  • Locked
  • Question
Server to Server VPN for SQL Traffic
Replies
2
Views
44
Richard Parry
Richard Parry
GCL2007
  • Locked
  • Question
Tempdb ldf file - how best to clear..
Replies
1
Views
71
gmmastros
gmmastros
joblack23
  • Locked
  • Question
Large transaction log file
Replies
5
Views
58
joblack23
joblack23

Part and Inventory Search

Sponsor

Back
Top