Post reply

Dynamically set Data Source values

  • March 1, 2011 at 2:14 pm

    #235257

    Is there a way to read an xml file or configuration file to get the Data Source values since they could change?

    Thanks,

    Tom

  • March 1, 2011 at 3:06 pm

    #1293249

    tshad (3/1/2011)

    Is there a way to read an xml file or configuration file to get the Data Source values since they could change?

    Thanks,

    Tom

    Some data source values, yes, like filepath or server. What are you looking to change specifically?

    If you go to SSIS-PackageConfigurations-Add-XML Configuration-<put in a filename>-Next... you'll see what you can configure externally on the datasources in the 'select properties to export' section.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • March 2, 2011 at 1:20 pm

    #1293709

    Right - but how would you do that for SSRS?

    I am trying to set up my reports to get the Connection string and the Cube to be handled dynamically as we have the same report for 2 different cubes and I am running the reports on one machine for Dev and then moving the reports to a different server and need to change the connection string for the data source.

    Thanks,

    Tom

  • March 3, 2011 at 8:06 pm

    #1294420

    tshad (3/2/2011)

    Right - but how would you do that for SSRS?

    I am trying to set up my reports to get the Connection string and the Cube to be handled dynamically as we have the same report for 2 different cubes and I am running the reports on one machine for Dev and then moving the reports to a different server and need to change the connection string for the data source.

    Thanks,

    Tom

    Apologies Tom, I misread the forum title when I answered. I read SSIS for some reason.

    I ... err... I actually have no idea how you'd do that.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

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

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