sql server dts: I have folder called TEST and is located in C drive. Every month, a new file
with the name IMMYY.txt will be put in there (MM---Month, YY---year). How
can i create a SSIS package to check to see whether there is any new file in
TEST folder and, if there is, insert into the filemonth field in the
vendorfile table in VFT database.

Hello qjlee,

Do you care about the name of the file or about the fact there is a file?

You can easily look in a directory, pick up any file names and then insert
those filenames into a table.

You can maybe use something like this

http://www.sqldts.com/246.aspx


--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]