Creating Inferred Dimension Members with SSIS

Question

Post reply

Creating Inferred Dimension Members with SSIS

rrubocki

Old Hand

Points: 380
More actions
December 7, 2010 at 8:10 pm

#229494

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

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Grey Cat Mr or Mrs. 500 Points: 524 More actions · Answer 1

Grey Cat

Mr or Mrs. 500

Points: 524

December 8, 2010 at 12:06 pm

#1260266

A great article. Very detailed and easy to follow.

wu.wuqiang Ten Centuries Points: 1008 More actions · Answer 2

wu.wuqiang

Ten Centuries

Points: 1008

December 8, 2010 at 2:02 pm

#1260312

Looking for this for a while..thanks!

sbogue Ten Centuries Points: 1077 More actions · Answer 3

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 Old Hand Points: 380 More actions · Answer 4

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 SSCrazy Eights Points: 8085 More actions · Answer 5

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

Thanks,

Thomas

Thomas LeBlanc, MVP Data Platform Consultant

Anil Maharjan SSC Veteran Points: 221 More actions · Answer 6

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 SSC Veteran Points: 221 More actions · Answer 7

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

rrubocki Old Hand Points: 380 More actions · Answer 8

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 Valued Member Points: 64 More actions · Answer 9

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!

ksreekumar_1 Valued Member Points: 67 More actions · Answer 10

Hi Robert, this is a great article and elegant way to add inferred dimension.

Just wanted to know how was BKColumnList planned to be used?

rrubocki Old Hand Points: 380 More actions · Answer 11

Hello,

BKColumnList is a comma separated list of the fields that make up the business key or natural key of your dimension. The sample uses a single field (Product_Nbr) as the business key. However, dimensions may use a composite business key. For example, the business key of the sample dimension could have been the combination of Product_Nbr and Product_Name, in which case the value of BKColumnList would be "Product_Nbr, Product_Name".

Dattatrey SIndol SSC Enthusiast Points: 182 More actions · Answer 12

Nice article!

Plain, Simple, Clear, and To the Point!

Thanks for sharing 🙂

Dattatrey Sindol
Blog: Datta's Ramblings on Business Intelligence 'N' Life[/url]

This information is provided "AS IS" with no warranties, and confers no rights.

Marco Barroso SSC Journeyman Points: 75 More actions · Answer 13

Very good and well written article. Would it be possible to get the SSIS solution files uploaded to the site ?

g1696412 SSC Enthusiast Points: 144 More actions · Answer 14

Hello,

thank you for article. Could someone please upload the Project Files of this solution? I am not unable to make this work as the scrip task returns some error.

"[Generate Product_Key for no match [28]] Error: System.Data.OleDb.OleDbException (0x80040E14): There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.

Invalid column name 'EE505'.

at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e)

at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer)

at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper, Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket)"

Thanks

David