Creating Inferred Dimension Members with SSIS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Robert Rubocki » Creating Inferred Dimension Members with SSIS...

13 posts, Page 1 of 2

1 2 »»

Creating Inferred Dimension Members with SSIS

Rate Topic

Display Mode

Topic Options

Author

Message

rrubocki

Posted Tuesday, December 07, 2010 8:10 PM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 2:02 PM
Points: 97, Visits: 240

Comments posted to this topic are about the item Creating Inferred Dimension Members with SSIS

Post #1031616

Grey Cat

Posted Wednesday, December 08, 2010 12:06 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 12:25 PM
Points: 22, Visits: 96

A great article. Very detailed and easy to follow.

Post #1032097

wu.wuqiang

Posted Wednesday, December 08, 2010 2:02 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, January 24, 2013 10:13 AM
Points: 20, Visits: 397

Looking for this for a while..thanks!

Post #1032152

sbogue

Posted Thursday, December 09, 2010 1:43 PM

SSC Eights!

Group: General Forum Members
Last Login: Friday, May 10, 2013 1:31 PM
Points: 928, Visits: 426

A good example, though I am new to SSIS and was unable to find the SourceName when building the Script Component. From where is that input coming ?

Thanks.

Post #1032718

rrubocki

Posted Thursday, December 09, 2010 2:19 PM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 2:02 PM
Points: 97, Visits: 240

That's a good catch. The SourceName field does not exist in this solution and it should not be included in the screenshot (Figure 14).

It can be beneficial to record in your dimension table the source of the dimension row. In an earlier iteration of this solution, I added the SourceName column to the data flow and assigned it a value. While the solution no longer uses that column, a SourceName value can be added to the InsertColumnList / InsertColumnValues columns so the source of the record is included in the dimension table.

Post #1032734

Thomas LeBlanc

Posted Thursday, December 09, 2010 3:07 PM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 3:33 PM
Points: 2,703, Visits: 717

Good article, needed to know a little about SSIS while following example.

Thanks,
Thomas

Thomas LeBlanc, MCITP DBA 2005, 2008 & MCDBA 2000
http://thesmilingdba.blogspot.com/

Post #1032760

Anil Maharjan

Posted Sunday, December 12, 2010 10:17 PM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, May 19, 2013 11:18 PM
Points: 8, Visits: 90

hello ,
I have gone through this blog post and i followed the same things as described in this article but i could not get the solution and its just sending some error also i am new to SSIS and i dont no how the SSIS tools are used.mainly i dont no how lookup transformation works and other tool too..
so can any one help me out ..in order to know and perform as this article.to obtain the solution also i could not get the idea where we put the VB script code in visual studio ?..which project have to make to execute a package...as same in this article.
so help me out to know this article with more details..i am also just working in the field of BI mainly SSRS/SSAS.
Thanks
Anil Maharjan

Post #1033586

Anil Maharjan

Posted Monday, December 13, 2010 8:54 PM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, May 19, 2013 11:18 PM
Points: 8, Visits: 90

hello,
I also try to implement as similar to this blog but couldnot get the solution excatly some error occurrs.
So,i am also wondering where we can download the package you built,can't we use the package that you already built.Hope you will help us out..!!!
Also i am new to SSIS so could some one suggest me some blog\links from where we can learn SSIS basic details.
hope some one help me out... :)

Thanks
Anil Maharjan

Post #1034171

rrubocki

Posted Tuesday, December 14, 2010 8:20 AM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 2:02 PM
Points: 97, Visits: 240

Anil,

Welcome to SSIS! This article admittedly covers a more advanced topic and is not geared for SSIS beginners. Here is some reference material you may find helpful. I also encourage you to search and participate in forums on SQL Server Central. There is a lot of great information for SSIS beginners.

- Tutorial: Creating a Simple ETL Package: http://msdn.microsoft.com/en-us/library/ms169917.aspx (Lesson 1, Step 6 covers configuration of a Lookup Transformation)
- Lookup Transformation: http://msdn.microsoft.com/en-us/library/ms141821.aspx
- Extending the Data Flow with the Script Component: http://msdn.microsoft.com/en-us/library/ms136118.aspx

Post #1034461

Mary Eckmeier

Posted Friday, January 06, 2012 1:35 PM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, March 17, 2013 2:48 PM
Points: 2, Visits: 31

hi - thanks so much for such a timely article! Just trying to do exactly what you have outlined in this article, - which I feel was extremely well laid out and clear. Thanks for it!

Post #1231724

« Prev Topic | Next Topic »

13 posts, Page 1 of 2

1 2 »»

Permissions