Post reply

Setting Connection String from a ForEach File Enumerator

  • April 15, 2015 at 10:35 am

    #297064

    I have a master package that is picking up files from a share then kicking off a series of other packages to use the files. I setup a ForEach Loop container to enumerate over the files and set a variable equal to the filename. Inside that ForEach is a sequence container that have the other execute package tasks.

    My flat file connection manager for the flat file is setup at the project level. (ssis 2012) The only option in expressions in the connection mgr for setting the connection string is for Project Parameters.

    How do I setup everything so I can send the file names from the ForEach to the connection mgr? Can I set a project parameter equal to a local variable?

    Thanks!

    -J

  • April 15, 2015 at 1:51 pm

    #1791183

    For now I used some File System tasks to copy the file into a working copy with a file name that is set in the project parameter. So the file comes in as Workday_20150415080106.csv. A file system task copies that file into WorkdayProcessing.csv which is the what is set in the project parameter for the connection string in my connection manager.

    If anyone has a more elegant solution I would welcome the input.

    Thanks!

    -J

Viewing 2 posts - 1 through 1 (of 1 total)

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