Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • Last Modified:

Slowly Changing Dimension

Hi

Whats the best way to edit the connection of a slowly changing dimension. I want to point to a new connection.

Cheers
0
ac_davis2002
Asked:
ac_davis2002
1 Solution
 
AnujCommented:
You can use XML configuration file to change the connection, this saves the SSIS configuration in an XML files, later you can edit this xml file to change various parameters.

Right click on package designer, choose "Package Configuration and Organizer"
Click Add, this will open up a wizard, Click next.
In Select configuration type window, choose" XML Configuration file" as your "configuration type". Specify a location to save this configuration file in "Configuration File Name" and click next
In "Select Properties to Export Window", expand "Connection Managers", Choose Servername, (initialCatloge, only if you need to edit database as well) in both source and destination and click next button.
Specify a name for this configuration and click finish to complete the wizard

Check the XML configuration file created above, you can customize the connection by editing this config file.
0
 
ac_davis2002Author Commented:
That is first class help!

Thanks ever so much
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now