Dynamically Change File Name Property In File Connection Manager

Posted on 2009-12-28
Medium Priority
Last Modified: 2013-11-10
I have a CSV file that is being used by my package as a datasource.  I created an SSISConfigurations table which includes a record that has the data file path used to hold all of my CSV files.  I created a package configuration that will pull the path into a variable.  I also created a separate variable in my package for the file name.

My question is:  How do I get these values into the file connection manager so that the file name property is configurable?   It's not that my file names are changing, it's the environment (path to csv files) which may change.  This is why I need to be able to dynamically configure the path because it has to be in the file name property.
Question by:ltrain2015
  • 2
  • 2
LVL 30

Accepted Solution

Reza Rad earned 1000 total points
ID: 26133375
Just use Expressions property in flat file connection manager
you can set somethings dynamically there, also connection string of file

Author Comment

ID: 26133430
It's the simple things that get ya.

Thanks reza_rad.

Author Comment

ID: 26133438
I didn't think to check the properties window.  I was searching for this feature in the Connection Manager Dialog Window.
LVL 30

Expert Comment

by:Reza Rad
ID: 26134204
Glad to help,


Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question