Post reply

Different Environment for different datasources

  • December 1, 2016 at 9:03 am

    #315388

    I am trying to implement the concept that we have different datasources

    for example datasource 1, datasource2 and datasource3 for all these three data sources the environment is different

    for DS1 it is PROD

    for DS2 it is QA.

    In ssis package how to implement this concept.

    We have a config table where I added a column called Env and it holds value as of now as DEV.

    In the package I have added a dts config file contains -

    <Configuration ConfiguredType="Property" Path="\Package.Variables[User::Env].Properties[Value]" ValueType="String"><ConfiguredValue>DEV</ConfiguredValue></Configuration>

    and also added variable in my package Env as datatype string and value as DEV.

    I am expecting to get Env name how to approach this?

  • December 1, 2016 at 12:15 pm

    #1915549

    I would recommend going with straight up Package parameters to set these. If you are on 2012 and greater, consider using SSIS environments. Here's a walk-through. I think it's pretty close to what you are asking for.

    https://www.simple-talk.com/sql/ssis/ssis-2012-projects-deployment-configurations-and-monitoring/

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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