Dynamically Change File Name Property In File Connection Manager

Posted on 2009-12-28
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
    LVL 30

    Accepted Solution

    Just use Expressions property in flat file connection manager
    you can set somethings dynamically there, also connection string of file

    Author Comment

    It's the simple things that get ya.

    Thanks reza_rad.

    Author Comment

    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
    Glad to help,


    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now