SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: Using DTS to Automate a Data Import Process
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 08/11/2002 :  10:39:23  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
In this article I show you how to create a DTS Package that can be used to automate a file download/import process. It's a little longer than the other articles I have written for SQLTeam and will require some work on your part if you want to implement it, but I think you will find it interesting.

Article Link.

SamC
White Water Yakist

USA
3467 Posts

Posted - 09/22/2002 :  16:19:05  Show Profile  Reply with Quote
Thanks for writing this article. I've needed to automate the user data import into our databases for some time.

I didn't see a technique for creating the destination table "ContactsImport" with dbo owner using DTS.

SamC

Go to Top of Page

Equator
Starting Member

2 Posts

Posted - 09/30/2003 :  08:24:06  Show Profile  Reply with Quote
Thanks for a useful and informative article. Can anyone tell me if the Contacts table is overwritten each time the DTS task is run? Can the table be read when the process is running?

Thanks,

Gareth
Go to Top of Page

lbmouse
Starting Member

1 Posts

Posted - 03/22/2005 :  09:39:02  Show Profile  Reply with Quote
Good article. I have a question.

Your first requirement was "Connect to an ftp site and download a specific file". How would you handle this if you did not know the name of the file? For example, I need to grab a file every few minutes that has the format cstmtMMDDYYYYHHSSTT.txt. I can't seem to find a way to get the FTP task to allow for filename wildcards or to grab everything in a hot directory. Other than writing a custom ActiveX Script task, do you have any ideas?

Thanks
Go to Top of Page

jeroenvanloon
Starting Member

1 Posts

Posted - 04/04/2005 :  08:30:58  Show Profile  Reply with Quote
Hi,

I am looking for the same thing. How can i download a file via FTP (in DTS) with a variable name. Like 'name.20050404.zip'.

Hoping that you already found the right answer.

Thanks,
Jeroen

quote:
Originally posted by lbmouse

Good article. I have a question.

Your first requirement was "Connect to an ftp site and download a specific file". How would you handle this if you did not know the name of the file? For example, I need to grab a file every few minutes that has the format cstmtMMDDYYYYHHSSTT.txt. I can't seem to find a way to get the FTP task to allow for filename wildcards or to grab everything in a hot directory. Other than writing a custom ActiveX Script task, do you have any ideas?

Thanks

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000