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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Import from Excel 2000 into SQL Server 2000 Table

Status
Not open for further replies.
linmor26

linmor26

Programmer
Sep 24, 2002
4
US
I have an Excel 2000 spreadsheet that is updated frequently throughout the day. I have created a DTS package in SQL Server 2000. It works fine until a user makes any kind of change to the spreadsheet and saves it. Then the DTS fails with error message stating that it could not find the Excel file.

How do I make the DTS remember the file name?
 
Sort by date Sort by votes
Hi,

Is the DTS constantly running throughout the day?

Regards,
Tom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Truncated Excel Fields
Replies
0
Views
196
grnzbra
grnzbra
petart
  • Locked
  • Question
Problem Date MS SQL Server
Replies
0
Views
165
petart
petart
smsmail
  • Locked
  • Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
302
markjoseph1232
markjoseph1232
mutley1
  • Locked
  • Question
XLSX import to DTS (SQL 2000)
Replies
0
Views
76
mutley1
mutley1
botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
155
botatun
botatun

Part and Inventory Search

Sponsor

Back
Top