Post reply

Change SMO Connection string Dynamically

  • September 19, 2016 at 10:04 pm

    #313354

    I have created a SSIS pacakge with Transfer SQL Server objects task which copies the selected data from one server to other. For this task it used the SMOServer connection and we need to have the connection change dynamically at the runtime for which i have enable the expression to true and set the connectionstring to the variable where it should pick the value from but its not doing it .

    Can we not dynamically change the SMOServer connection type ?

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

  • September 19, 2016 at 10:42 pm

    #1901785

    Sri8143 (9/19/2016)

    I have created a SSIS pacakge with Transfer SQL Server objects task which copies the selected data from one server to other. For this task it used the SMOServer connection and we need to have the connection change dynamically at the runtime for which i have enable the expression to true and set the connectionstring to the variable where it should pick the value from but its not doing it .

    Can we not dynamically change the SMOServer connection type ?

    Quick question, what do you mean by "change the SMOServer connection type "?

    😎

  • September 20, 2016 at 1:12 am

    #1901799

    All of the DB connections are configured to get the values from a table at runtime but this not being an OLEDB connection i am not sure how should i configure to get the values from a table. I tried doing that in expression but it didnt work. So want to know if we can at all change the servername at runtime in anyway for SMOServer connection ? As i dont want to hard code the servername in SSIS package as it needs to be deployed across multiple environments.

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

  • September 20, 2016 at 3:35 am

    #1901813

    If you're deploying to multiple environments, why not "parameterise" the connection string? Then you can simply pass the appropriate connection string parameter for the environment you are on.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

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

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