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

Import/Export Wizard

Status
Not open for further replies.
annub

annub

Programmer
Apr 23, 2003
33
US
Is there a way i can create DTS package where i can get files from previous day. I am doing this process manually through IEW everyday. I want to schedule this package so that it can run on its on and i can get files from previous day. I am using sql 8
 
Sort by date Sort by votes
How do you determine what files were created yesterday? My the creation date or are the files created w/ filenames that are self explainatory like 20040316.txt? Or are they stored in a special folder that you know they are from yesterday?

Thanks

J. Kusch
 
Upvote 0 Downvote
well, when i import files i do where date = 20040315.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ahmedsa2018
  • Locked
  • Question
How to export 20 milion rows to only one file ?
Replies
2
Views
111
JeffModen
JeffModen
eboughey1008
  • Locked
  • Question
Import columns from one table into another table with dissimilar field layout
Replies
7
Views
165
Chris Miller
Chris Miller
bmacbmac
  • Locked
  • Question
How to import plain text from Word doc to SQL 1
Replies
4
Views
157
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
Import Limited to 255 Characters
Replies
1
Views
190
SaltyTheFrog
SaltyTheFrog
jimoo
  • Locked
  • Question
Export Many SQL Tables to Excel
Replies
3
Views
78
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top