Post reply

Configure file location for Flat file importing

  • May 4, 2009 at 8:08 pm

    #131067

    I have created a package in SSIS which consist of importing data from a flat file to ms sql database and doing some sql query updates after importing.

    This package will be set as a scheduled task to run from ms sql 2005.

    Is it possible to "re-use" this package but importing from a different physical location?

    Anyone can advise?

    Thank you.

    Best regards,

    John

  • May 4, 2009 at 9:37 pm

    #988530

    HAve a look at SSIS Configurations. This is exactly why this functionality exists. You can store the location of files in a configuration (which can be stored in a variety of locations including a SQL Server table, registry, .INI file). The choice on where to store the configuration is largely up to you. They all work well.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply