Home Forums Data Warehousing Integration Services Someone please help - SSIS - Get info from SQL server table about which particular files to load in target SQL server table RE: Someone please help - SSIS - Get info from SQL server table about which particular files to load in target SQL server table

  • June 28, 2017 at 6:40 am

    #1948538

    ritesh.sinha 54676 - Wednesday, June 28, 2017 3:41 AM

    Phil Parkin - Saturday, June 24, 2017 2:36 PM

    Please read this:
    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/9f9812c3-56cf-4a76-ad48-fad7b03ad9ac/how-to-pass-filename-as-a-dynamic-variable-to-flat-file-source-in-ssis-?forum=sqlintegrationservices
    and confirm that you have set the flat file source dynamically.

    Hi Phil,
    I am still unable to get through this. Please find the doc attached with each of the steps that I have followed and please confirm that I am not seeing something which is so clearly visible. Thanks a million in advance.

    In your document, I cannot find the part where you have used an Expression to set the value of the flat file connection string. You need to do this so that the connection string changes every time the FOREACH loop iterates.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.