SSIS 2008 Foreach Loop quetions

Question

SSIS 2008 Foreach Loop quetions

Lexa

Hall of Fame

Points: 3314
More actions
October 11, 2011 at 10:49 am

#258752

Hi,
Is there a way to use the loop for a subset of files in a folder? Say top 10?
Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

The only way I have been able to achieve this is to use xp_cmdshell and tsql. I am sure there is a method using powershell or a script component - you may want to try something like that.

Just load the results of your script into an object variable and then foreach loop over the object variable instead of the directory.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Lexa Hall of Fame Points: 3314 More actions · Answer 2

SQLRNNR (10/11/2011)
The only way I have been able to achieve this is to use xp_cmdshell and tsql. I am sure there is a method using powershell or a script component - you may want to try something like that.
Just load the results of your script into an object variable and then foreach loop over the object variable instead of the directory.

Thanks Jason, that is what I'm currently doing. I was hoping there is another aproach.

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 3

I would probably use a Script Task and generate the list manually from the file system and then feed that list to the FEL. I refuse to use xp_cmdshell at ALL.

CEWII