• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 320
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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