I have a Foreach Loop component that loops through files in a folder. That folder doesn't exist on the server where I'm going to move the package to. Within the Foreach Loop Editor, the Enumerator Configuration Folder doesn't appear to be able
to take a variable value. Also, it doesn't appear that there's a "Folder" property in the expressions property list.
Is there some way I can use a variable value for this foreach file loop's folder location? I need to move the package to the dev server and then eventually to the prod server. I don't mind manually opening the *.dtsx file on each server to change
the values accordingly, but I would think there's a better way.
Any advice you could offer would be greatly appreciated. The dev and prod servers have SQL Server 2008 R2 with SSIS 2008 R2 on Windows 2008 Server.
View Complete Post