.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Need step by step help for Slowly Chaging Dimension In SSIS 2005

Posted By:      Posted Date: September 06, 2010    Points: 0   Category :Sql Server
Hi I have never used Slowly Changing Dimension ,my manager told me that i  have to use use type 2 for this i am not sure what is business key and all,please help me step by step process I have a source table like this [dbo].[CapabilitySpecialty](  [SpecialtyCd] [varchar](30) NOT NULL,  [SpecialtyDesc] [varchar](256) NULL,  [CapabilityCd] [varchar](30) NULL,  [CapabilityDesc] [varchar](256) NULL,  [WorkgroupCd] [varchar](15) NULL,  [WorkgroupDesc] [varchar](100) NULL,  [WorkforceGPSCapabilityCd] [varchar](15) NULL,  [WorkforceDesc] [varchar](100) NULL Now  I have destination table looks like this [Price].[DimCapabilitySpecialty](  [CapabilitySpecialtyKey] [int] IDENTITY(1,1) NOT NULL,  [SpecialtyCd] [varchar](30) NOT NULL,  [SpecialtyDesc] [varchar](256) NULL,  [CapabilityCd] [varchar](30) NULL,  [CapabilityDesc] [varchar](256) NULL,  [WorkgroupCd] [varchar](15) NULL,  [WorkgroupDesc] [varchar](100) NULL,  [WorkforceGPSCapabilityCd] [varchar](15) NULL,  [WorkforceDesc] [varchar](100) NULL  

View Complete Post

More Related Resource Links

In SSIS 2005 how can I implement Slowly Changing Dimension Type 6

Hi I can't see SCD Type 6 in SSIS 2005 ,how do I get add  into my data flow task and if anybody can explain me step by step process for SCD type 6

Steps by Step document for configuration Merge Replication in 2005

Hi , Can anyone provide link to configure Merge Replication in 2005 with print screen.Also let me know the difference between Transcation level and Merge Replication. regards Vijay  

Slowly Changing Dimension in SSIS

Hi I am new to SSIS and i have read concepts of Slowly changing dimensions ( Type 1,2 and 3). Can any one suggest some examples or tutorils to implement this in a SSIS package for better understanding how does it works in SSIS?   MAny Thanks Ravi.S

Running SSIS job step as Proxy account does not find log provider for windows event log

When I run a ssis job step using a proxy account i get this error message:

Description: The log provider type "DTS.LogProviderEventLog.2" specified for log provider "SSIS log provider for Windows Event Log" is not recognized as a valid log provider type. This error occurs when an attempt is made to create a log provider for unknown log provider type. Verify the spelling in the log provider type name.  End Error  Error: 2010-02-02 14:43:03.88     Code: 0xC0010021     Source:       Description: Element "{028F8760-7E28-4F62-A204-66F33F4064BE}" does not exist in collection "LogProviders". 

If the account is a member of administrators group on the sql server the job step works fine.

Since the logprovider DTS.LogProviderEventLog.2 exists on the system I guess that this has something to do with access rights, probably to some registry key(s), but I cannot find out which part of the registry the proxy user does not have access to.

When running the same package using DTEXEC in a Command Prompt and using RUNAS <proxyuser> the package works fine and writes to the event log.

Kind regards


update 17-Feb-2010: Microsoft has reproduced this situation and I hope to get a workaround or fix soon :-

SSIS package is not reading from the configuration file in job step configuration tab

Hi everyone,

I have the following question. I have an SSIS package and it has in SSIS in BIDS 'Enable package configuration' and a full path to a file. The packages works ok and reads from this file.

 If I invoke the same package from sql agent as a job step and apply another configuration file in the job step (in tab COnfigurations), the package still uses the one in BIDS. Shouldn't this new config file overwrite the one from BIDS or?

Thank you


SQL Server 2005 Analysis Services Step by Step Companion CD


Hi everyone,

I'm also reading this book, and do not have the companion cd. If someone could e-mail it to me at: sibasishdasgupta@gmail.com i would really appreciate it. Thanks in advance.

Where to find code samples for "SQL Server 2005 Analysis Services Step by Step" book?


I am reading SQL Server Analysis Services from "SQL Server 2005 Analysis Services Step by Step" book and I want to download the code samples for the same. Please tell me how I can do that?

Thanks in advance,

Issue while programmatically Slowly Chaging Dimension.



I am working on Creating an SSIS package to add Slowly Chaging Dimension to the package programmatically.

I have done the following steps:

1.           Choosing the connection manager to access the data source that contains the dimension table that you want to update.

  You can select from a list of connection managers that the package includes.


Returning a DataSet From a Web Services: Step-by-Step

This Example Shows how to create a webservice which returns a DataSet and a Client Which displays the DataSet in a Grid.


This Example Shows how to create a webservice which returns a DataSet and a Client Which displays the DataSet in a Grid.

Security Briefs: Step-by-Step Guide to InfoCard


In my April 2006 column I began a discussion of InfoCard, the upcoming identity metasystem, which is being prepared for release in the Windows VistaT timeframe. If you haven't read that column, you should definitely start there because I'm going to assume you're familiar with the basics I covered.

Keith Brown

MSDN Magazine May 2006

Error in Step 8 of Share point configuration wizard

HI Team,        I am getting an error in step 8 of Share point Configuration wizard, Its running for ever its running in the step 8 for ever later i need to kill the configuration wizard Please advise Thanks Kumar

Force SQL job to succeed even after a step fails in SQL server 2008

All, We are trying to force some jobs to succed even though one step in the job fails randomly. Now,we choose the property of the job succeed on failure, it still shows up as warning. How do we ignore the warning thrown by the job SQL job?? Any suggestions??   Thanks Kay

Need step-by-step Custom Template Help

I would like to create 5 custom templates and deploy the same ones to all 13 site collections (living under one web app). Here's what I can successfully do: 1. Create a site 2. Turn off features (on a hunch after experiencing the below problems) 3. Add branding, web parts, etc. 4. Site Settings -> Save Site as Template 5. Test by immediately creating a site in the same site collection with the template (this works). However: * Weeks to months after creating the template, it stops working (in the same site collection). Could be something I'm configuring, I don't know. Users get message "The template you have chosen is invalid or cannot be found." * If I go to the template gallery, right-click and save-as,  put the template on my desktop, and then upload it to another site collection, it doesn't work in the new site collection. Again, "The template you have chosen is invalid or cannot be found." When I open the template and look at the code, I see references to absolute URLs from the site where the template was created. Would really prefer to deploy these templates without coding. * If I use stsadm -o addtemplate -filename "filename.stp" -title "title" the template also doesn't work. It allows me to create a site with it and set permissions, but then I immediately get: Server Error in '/' Application. The resource cannot be

SQL Job Running the Upgrade Step, but the Step Fails

I have reviewed the following thread (http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/1c06be77-3fa9-42d8-9803-6649be65afd6), but I do not think it applies to my case, b/c I have no other processes running, except the RESTORE DATABASE process. In SSMS, when I EXEC spCent, the user-defined stored procedure runs successfully. When the same SQL command is executed from a SQL Job, the job fails, and job history is like the following: Message: Executed as user: NT AUTHORITY\NETWORK SERVICE. ...on file 1. [SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'Cent', file 'Cent_log' on file 1. [SQLSTATE 01000] (Message 4035) Converting database 'Cent' from version 611 to the current version 655. [SQLSTATE 01000] (Message 944)  Database 'Cent' running the upgrade step from version 611 to version 621. [SQLSTATE 01000] (Message 951)  Database 'Cent' running the upgrade step from version 621 to version 622.     .     .     . [SQLSTATE 01000] (Message 951)  Database 'Cent' running the upgrade step from version 652 to version 653. [SQLSTATE 01000] (Message 951)  Database 'Cent' running the upgrade step from vers...  The step failed. As mentioned above, the stored proc can be successfully executed from within SSMS. The stored proc looks like this: ALTER PROCEDURE [dbo].[sp

Custom Ribbon action using quick step for workflow

I created custom button using the quick step in ribbon, and configured to invoke a workflow. It shows start and stop page of workflow where I have to click start. How to start workflow directly from the ribbon without this redirection to page.  

Making an Exchange Distribution List an Approver for a Workflow step

I have a client that has an Exchange Distribution List populate by a team of specific stakeholders. They want a workflow that includes the Distribution List as an approver so that everyone in that DL has to approve before it moves on to the executive steering committee. What are the proper steps to making an Exchange DL a approver to a workflow in MOSS?  silly rabbit, tricks are for kids!

Sharepoint 2010 COnfiguration Wizard Error Step 3 of 10

I am trying to install Sharepoint 2010 on a Windows 2008 R2 Hyper V Instance.  The database is SQL Server 2008 R2.  All them are RTM I am getting this error Failed to Create the configuration Database An exception of type Syste.InvalidCastException was thrown.  Additional exception information: Unable to cast object of type "Microsoft.IdentityModel.Configuration.MicrosoftIdentityModelSection' to type "Microsoft.IdentityModel.Configuration.MicrosoftIdentityModelSection' to diagnose the problem, review the logs at so after reviewing the logs this is what I find Resource retrieved id PostSetupConfigurationFailedEventLog is Configuration of SharePoint Products failed.   This is the error from the event logs Log Name:      Application Source:        SharePoint 2010 Products Configuration Wizard Date:          4/26/2010 11:30:09 PM Event ID:      104 Task Category: None Level:         Error Keywords:      Classic User:          N/A Computer:      jedicouncil.endor.local Description: Failed to create the configuration database. An exception of type System.InvalidCastException was thrown. 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend