August 5, 2008 at 10:23 am
Hello
Does anyone know how I can develop a package that will import any prefixed CSV file within a directory once it is created?
I have TR0001, TR002, TR003 and so,and I want to be able to import the data of any CSV file with the prefic TR...once created within a directory.
Thanks
August 5, 2008 at 11:52 am
You need to use a For Each loop container. Set the Enumerator to For Each File. Then you can apply a criteria for the file name like tr*.csv and the task will loop over all the files.
You would want to rename or archive each file after processing so you do not process it again the next time you run the package.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 8, 2008 at 8:53 am
It may sound stupid for an expert like you guys but would it be possible to list a step by step guuide on how to do this?
August 8, 2008 at 9:45 am
funny this came up, i just wrote up a quick blog on my corporate blog site on the steps to perform the load. here is the link:
the topic is called SSIS Dynamic File Name Load.
hth
August 8, 2008 at 10:43 am
Is it possible to have the for each loop container package to work on remote machines and servers?
August 8, 2008 at 10:48 am
Yes its possible if the user under which the package executes has appropriate permission (to read or write) on that server.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply