SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Creating Inferred Dimension Members with SSIS


Creating Inferred Dimension Members with SSIS

Author
Message
rrubocki
rrubocki
SSC-Enthusiastic
SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)

Group: General Forum Members
Points: 148 Visits: 354
Comments posted to this topic are about the item Creating Inferred Dimension Members with SSIS
Grey Cat
Grey Cat
Valued Member
Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)

Group: General Forum Members
Points: 57 Visits: 124
A great article. Very detailed and easy to follow.
wu.wuqiang
wu.wuqiang
SSC-Enthusiastic
SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)

Group: General Forum Members
Points: 104 Visits: 525
Looking for this for a while..thanks!
sbogue
sbogue
SSC Eights!
SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)

Group: General Forum Members
Points: 951 Visits: 611
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.



rrubocki
rrubocki
SSC-Enthusiastic
SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)

Group: General Forum Members
Points: 148 Visits: 354
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.
Thomas LeBlanc
Thomas LeBlanc
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4221 Visits: 909
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/
Anil Maharjan
Anil  Maharjan
Valued Member
Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)

Group: General Forum Members
Points: 53 Visits: 121
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
Anil Maharjan
Anil  Maharjan
Valued Member
Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)

Group: General Forum Members
Points: 53 Visits: 121
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... Smile

Thanks
Anil Maharjan
rrubocki
rrubocki
SSC-Enthusiastic
SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)

Group: General Forum Members
Points: 148 Visits: 354
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
Mary Eckmeier
Mary Eckmeier
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 32
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!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search