• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 317
  • 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
 
AnujSQL Server DBACommented:
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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