Post reply

Input File name to SSIS package

  • December 21, 2009 at 9:34 am

    #213829

    Hi ALl,

    I am created a ssis package that is loading a file into Db table

    (But every thing is hard coded e.g in Flatfile source i am mentioned file name)

    and destination i am mentioned Table name , But

    How to pass Input file NAme and Tbale name at run time?

  • December 21, 2009 at 10:40 am

    #1094932

    You can use the SET parameter with DTEXEC

    http://msdn.microsoft.com/en-us/library/ms162810.aspx

    xp_cmdshell will need to be enabled.

    Create variables in your packages. The use expressions in your package so that your destination and sources refer to you variables. Your variables will need to have defaults. Get the package running manually. Then you can use DTEXEC and set your variables at run-time.

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

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