469,950 Members | 1,391 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,950 developers. It's quick & easy.

Loading Flat File using DTS

I want to use DTS to load from a flat file. But I can't be sure when
the flat file will arrive. I would like the job to check every 10
minutes or so for a couple of hours. If the file is present, then load
the file and rename it so that it doesn't get overwritten. Any
suggestions?

TIA,

amorphous999

Jul 23 '05 #1
3 1713
Why not create the DTS package as if the file exists, and if it doesn't let
the package fail!
Set up a job to run the package every x number of minutes, if the file is
there it will load
if the file's not there the package will fail and the job will execute again
in another x minutes.

Of course the last step of your package will be to delete the file after it
loads, so it doesn't
keep appending the info to the database.

We have several similar packages we run and just let them fail when the
file's not there, not
very pretty but who cares! It works and the import only takes 10 seconds
anyway.

"amorphous999" <jf**********@hotmail.com> wrote in message
news:11********************@o13g2000cwo.googlegrou ps.com...
I want to use DTS to load from a flat file. But I can't be sure when
the flat file will arrive. I would like the job to check every 10
minutes or so for a couple of hours. If the file is present, then load
the file and rename it so that it doesn't get overwritten. Any
suggestions?

TIA,

amorphous999

Jul 23 '05 #2
You could put in an ActiveX step to check if the file is there - if it
is, the package continues, if not, then it returns, quits, logs an
error or anything else you want it to do. This article might be useful:

http://www.sqldts.com/default.aspx?292

Simon

Jul 23 '05 #3
Thanks for the URL! I'll give it a try.

Simon Hayes wrote:
You could put in an ActiveX step to check if the file is there - if it
is, the package continues, if not, then it returns, quits, logs an
error or anything else you want it to do. This article might be useful:

http://www.sqldts.com/default.aspx?292

Simon


Jul 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by raykyoto | last post: by
6 posts views Thread by Glenn Owens | last post: by
22 posts views Thread by Daniel Billingsley | last post: by
2 posts views Thread by Neural | last post: by
9 posts views Thread by FFMG | last post: by
15 posts views Thread by lxyone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.