I would like to create a managed connection to a file that has a new
name each time the SSIS package processes. Is it possible to
dynamically control the name or create the managed connection based on
input parameters?

Hey papashaw,

This is possible. It's actually very simple. I

1.f you look at the properties menu of you connection object you should
see a propery called Expressions. Click on that property.

2. You should see a menu with 2 colums, property and expression. Click
on the Property Row and selec connection string.

3. Then you can create an expression using variables that will be
evaluated at run time.

Here is an expression I use for outputing a file:

@[User::OutputFilePathName] + "_" +
(DT_STR,100,1252) DATEPART("MM",GETDATE()) +
(DT_STR,100,1252) DATEPART("DD",GETDATE()) +
(DT_STR,100,1252) DATEPART("YY",GETDATE()) + "_" +
(DT_STR,100,1252) DATEPART("Hh",GETDATE()) +
(DT_STR,100,1252) DATEPART("n",GETDATE()) + ".csv"

@[User::OutputFilePathName] is a variable I defined and the rest are
functions are use to append a date to the end of the file name.

Hope this helps.

Jay



papashaw (AT) gmail (DOT) com wrote: