Post reply

SSIS dtsconfig files

  • July 23, 2015 at 12:40 pm

    #310089

    Hi Team,

    Need clarification on how the SSIS dtsconfig file paths are referred at runtime.

    I designed a SSIS package on my local machine, dtsconfig path is set to D:\Packages\Config\test.dtsconfig

    I deploy this on server in the Integration services msdb. But on this server there is no D drive. I keep the dtsconfig in the E drive.. (and on my local machine there is no E drive).

    My Query:

    I assume the dtsconfig is not picked and the values present in the SSIS packages are used instead.?

    Can I change the dtsconfig location on the msdb on the server (thrz no BIDS on server). Also I dont see any settings shown in the Configuations section of the packages (when I click on Run Package).

    How do I resolve this.

  • July 24, 2015 at 12:45 am

    #1814636

    Hi,

    Any feedback/pointers anyone?

  • July 24, 2015 at 12:49 am

    #1814637

    It will not pick this config file and execute the package as per default values.

    I would suggest use an environment variable on your server and provide configuration path there.

    Otherwise, you need to provide config file path in your ssis package as per your server.

    ____________________________________________________________

    AP

  • July 29, 2015 at 12:53 am

    #1815632

    you can set configuration file at the job level.

    Steps:

    •Create configuration files for the connections used in SSIS package.

    •Disable the configuration at SSIS package, deploy it.

    •Put the configuration file in the server where you deploy.

    •In the job, point the configuration file from the server.

    •Since there is no configuration at package level, package will take it from job.

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

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