Home Forums Data Warehousing Integration Services Flat File connection Manager - File Name, The Folder in File Name changes every time the package is reopoened and needs resetting RE: Flat File connection Manager - File Name, The Folder in File Name changes every time the package is reopoened and needs resetting

  • February 21, 2013 at 8:48 am

    #1590012

    Debbie Edwards (2/21/2013)

    Heres a thought.....

    In the Flat file connection managers properties I have

    ConnectionString set to \\D-fs07\spar-it\PROJECTS\1 Active Projects\DATA WAREHOUSING PROJECT\Development\Extract_To_CSV\Test.csv

    And Expressions Connection String set to @[Extract_To_CSV_Folder]+@[User::DFES_NAME_DATE_File_Name]+".csv"

    The fact there are 2 connection strings is very confusing. Could this be why its going wrong?

    Probably not the issue here. The expression would replace the hard coded connection manager when the process runs.