Hopefully simple question from a newbie

[dlyles]

Can someone point me in the right direction? I'm need to run a script that will run an auto import of data. Basically I'm retrieving a .sql file everyday via FTP and I need to automatically import that data at a specified time into an existing database.

Thanks in advance.

 

[klewis10367]

Create a DTS and this will create a job for you so you can schedule it.

 

[dlyles]

That sounds like a great idea if I knew what a DTS was.

 

[dlyles]

Got it. Thanks.

 

[nigelrivett]

See

http://www.nigelrivett.net/ImportTextFiles.html

and

http://www.nigelrivett.net/s_ftp_GetDir.html

http://www.nigelrivett.net/s_ftp_PutFile.html

(change the put to a get)

A combination of the two will allow you to code a process for getting all files from an ftp site, importing them and archiving and all controlled from a stored procedure.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[dlyles]

Ok, I'm a little confused, so this is what I'm going to do (and it hopefully will work). I have a routine in my FTP program to download a file at a set time everyday. I have a DTS package set to import that file 1/2 hour after it's downloaded.

Now, I need to eliminate any duplicates that are brought over during the import.