LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » SQL Server Database Administration » Integration Services (SSIS) and DTS » FTP a file, then load it

FTP a file, then load it

Options

Previous Topic · Next Topic

ravensensei

Posted: Friday, April 17, 2009 1:54:06 PM

Rank: Newbie

Joined: 4/17/2009
Posts: 1
Points: 3
Where do you live?: NY, USA

I am working on a project that should be easy to do, but I'm having issues putting it together because I'm a relative newbie. I want to:
1) download a file from an SFTP Source. (I've got that figured out pretty well, tho if I have duplicate files, it fails)
2) grab the downloaded file & toss it into a db.

the file is a csv file we've gotten from a client that I will need to massage before putting into the db, but I can't for the life of me figure out how to get the file and get the data out of it.

the filename is different everytime, tho the only thing that changes is the end of it based on the date it was run:
fileExport041609.txt
fileExport041709.txt

I'm trying to find a way to write the connection string to the right file, but I'm relatively new at this and I'm not sure even what to use to do it. Is it a file system task? Is it a Flat File Source? and is there a way to pick up the system date to figure out the day so it can look for that day's file?

thanks!@
M@

Scott Whigham

Posted: Tuesday, May 12, 2009 11:54:28 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 476
Points: 1,053
Where do you live?: Dallas, TX

Are you using SSIS or DTS?

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.