CODEWITHSUNDEEP
data-warehouseetlssisscd
Jan
Jan

Reputation: 16048

Changing Properties of a Slowly Changing Dimension Transformation in SSIS

I have a problem with changing the properties of the SCD transformation in SSIS 2005.

I can define all the properies and mappings the first time i edit the transformation and its working.

But when i open the property editor of the component again, it has forgotten all the entered configuration like the mappings of the table columns and the settings of the columns.

I even have searched in the generated XML for the settings but have not found anything meaningful.

SSIS has definitly stored the components configuration somewhere because its working fine until i open the editor.

I have searched the web but with no luck yet. Does anybody know where the settings are stored respectively how to force the components editor/assistant to not forget all my settings?

Upvotes: 1

Views: 1716

Answers (2)

Valentine Obodoechi
Valentine Obodoechi

Reputation: 11

I have had this problem too for almost 2 weeks crawling through the net to find the solution.I finally found a way out. With the xml definition of the SCD component, specifically :

<dwd:DtsComponentDesignTimeProperty> <dwd:key xsi:type="xsd:string">50 SCDMetadata</dwd:key>
<dwd:value xsi:type="xsd:string">&lt;?xml version="1.0" encoding="utf-16"?&gt; &lt;SCDWizardMetadata xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt; &lt;ConnectionID&gt;{8F2DCF5E-0FC4-4CF4-AF30-87548F5C74A3}&lt;/ConnectionID&gt;

It is IMPORTANT that the the content of the tag dwd:value is on same line as the tag itself. If there is a line break, the SCD wizard will not load your settings. I know, its wired. Also the values with the dqd:key should be seperated by a tab. The most important is that the content of the dwd:value start on same line. Hope this helps someone out.

Upvotes: 1

William Salzman
William Salzman

Reputation: 6446

The SCD WIZARD in SSIS is not an editor, it is a wizard. That is one of its biggest drawbacks. It doesn't remember any configuration. Every time you use the wizard, it starts again from the beginning and recreates all of the object it uses to do the slowly changing dimension. If you want an SCD component that will remember the setting between uses, you should probably use the excellent tool by Todd McDermid: DimensionMerge SCD Component

Upvotes: 3

Related Questions