Easy method:
Use a batch file to archive and rename your incoming file, after processing
delete your renamed file.
regards
Volker Schoen
E-Mail: mailto:v.[Email address protected]
http://www.inplan.de
-----Ursprüngliche Nachricht-----
Von: Smithson Charles
[mailto:mssqldba-ezmlmshield-x9415239.[Email address protected]
Gesendet: Mittwoch, 26. Mai 2004 16:48
An: LazyDBA.com Discussion
Betreff: RE: Import data from file
Vishal,
for many DTS tasks you may find what you are looking for at SQLDTS.com,
below is a link for exactly what you are trying to accomplish.
http://www.sqldts.com/default.aspx?200
-----Original Message-----
From: Vishal Sinha
[mailto:mssqldba-ezmlmshield-x72095258.[Email address protected]
Sent: Tuesday, May 25, 2004 12:58 PM
To: LazyDBA.com Discussion
Subject: DTS: Import data from file
I am trying to import data from text file to a SQL table.
The files come in daily and have format
FileNameMMDDYYYY.txt
Can someone help me design DTS package that can take in cariable file names?
Thanks!
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
CONFIDENTIALITY NOTICE: This electronic message transmission, including any
attachment, is intended only for the use of the individual or entity to
which it is addressed. It may contain information that is privileged,
confidential or otherwise protected from disclosure. If you are not the
intended recipient, you are hereby notified that any dissemination or
copying of the contents of this information is prohibited. If you have
received this transmission in error, please notify the sender immediately by
a "reply to sender only" message and destroy all electronic and hard copies
of the communication, including attachments. If there is a transmission
problem, please call ALERE at 1 (888) 442-5373.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
MS Sql Server LazyDBA home page