Post reply

run SSIS with config file

  • January 16, 2009 at 7:14 am

    #125592

    Hi all,

    I have create xml config file. I have export everything when cretiong package configuration. ( is that what i need please let me know)

    also how can i run the configuration file before package process. so it takes all value of variables from the config file?

    guide!!

    Thanks

    pat

  • January 16, 2009 at 8:01 am

    #928161

    1. Its always better to keep only the dynamic variables in configurations than all of the internal variables.

    2. The configured variables are always populated before starting the execution of the package.

    --Ramesh

  • January 16, 2009 at 11:00 am

    #928358

    thanks for the respose.

    I have this pacakge which process excel fiel and after it processed it moves file to archive. i have about 5 variables like sourcefolder, filepath, filename, archfolder, archpath. i want to assign values before the process start because file name changes because it is in loop to process *.xls files.

    what i should store in xml config file and what i need to do on the server side

    thanks

  • January 17, 2009 at 3:19 am

    #928655

    Basically, what you need is

    1. Two configuration variables for source & archive directory and three internal variables to hold file name, source file path & archive file path.

    2. One For Each File Loop Task (which will set values of other 3 variables)

    3. One Data Flow Task (will contain source (excel) & destination connections, which are dynamically set using the variables set in point 2)

    --Ramesh

Viewing 4 posts - 1 through 3 (of 3 total)

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