September 29, 2011 at 2:16 pm
I am trying to create an SSIS Package that will do several things. I am having issues at step 1 which is grab all of the file names from a directory "W:\Source_Directory\Files" that begin with "FF*" or "X2*" to get a list of files in the directory.
I looked around on google and found a great example ( http://stackoverflow.com/questions/391199/how-to-detect-filename-dyanamically-in-ssis
) but I'm not getting it to modify the right way for what I am trying to do. I know I want to create a Script Task to do this.
Thanks for your help,
Randy
September 29, 2011 at 2:52 pm
Actually, you don't. What you want is a ForEach loop for each of the patterns, and then do what you need to via SSIS variables and expressions on the connection strings to the flatfiles.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply