Post reply

use a package var to set the location of SSIS log file

  • July 29, 2008 at 10:40 am

    #130418

    I searched on this and I haven't been succesful. I am trying to use a package variable I read in from a database table to set the directory location of the SSIS log file. (This is the log file you create by going into the menu item SSIS -> Logging.)

    Now, I know how to read in a value from a table and assign it to a package variable. And I also know how to use an expression editor to build an object's property.

    But for some reason, I cannot get this to work for SSIS log's ConnectionString property. Incidentally, I also have a Flat File Destination in the same package and I am able to parameterize its location using the same variable. But why can't I do the same for the log file?

    Is there something special about the ConnectionString in SSIS Log file that I am not getting?

  • July 29, 2008 at 12:47 pm

    #850068

    I realize now that there is an inherent problem with the order of events. I am trying to define the connection string for the log file in the package during run time, but the log file properties have to set before I go into the package.

    So, what I was getting is the expected behavior. To do what I was trying to do, I need to set my variable not during run time, but prior to. I can do this using one of the package config options.

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

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