Data Mining Training Courses

I have been trying to use SQL 2005 data mining for about 8 weeks. I am becoming frustrated because I am not able to make progress nor am I able to exploit the power of the system.

I need a training course! I have asked Microsoft in UK for recommendations but they have been unable to help. I have searched for courses in the UK and US without sucess.

I am coming to the Microsoft BI event in Seattle - will there be any opportunities there to get help or find help? (In Seattle I intend to concentrate on the Excel add ins)

Thank you

Solid Quality Learning offers a 3-day course on Data Mining with SQL Server 2005 (http://learning.solidq.com/na/CourseDetail.aspx?IdCourse=177). Try contacting them for schedules and more info.

Product team folks (including myself) will be present at the BI Conference next month so you can get some pointers (the Ask the Experts sessions would be a good bet). There should also be opportunities for interacting with partners/consultants who have experience with SQL Data Mining.

|||

If you would like to connect with us at the BI Conference you can set up a meeting. MeetingPoint is a feature hosted on the conference registration site which enables you to request a scheduled meeting with a named MS contact. Feel free to invite myself (Donald Farmer) and I'll ensure others are included too.

See you at the conference!

|||

Raman

Thank you

Your suggested course illustrates the problem - there are no courses scheduled at this time. However I will persue this with SolidQ.

I will look out for the Ask the experts sessions at the conference.

Using the conference facilities I have suggested a meeting date and time with Donald Farmer.

Thank you again

Geoff

|||

Donald

Thank you - I appreciate the offer.

Using the conference facilities I have suggested a date and time for the meeting.

Look forward to meeting you.

Geoff

Data Issues Very frustrated

I have various sql, sybase & access databases that i need to report from onto
the 1 table. A number of joins link them all together. As you can only use 1
dataset, what would be the best way to report on my data into the one table.
I have spent weeks trying to work this out. ThanksYou could use a stored procedure or view to do all the joins and then call
the one view or stored procedure from your dataset.
John K.
===
"Tango" wrote:
> I have various sql, sybase & access databases that i need to report from onto
> the 1 table. A number of joins link them all together. As you can only use 1
> dataset, what would be the best way to report on my data into the one table.
> I have spent weeks trying to work this out. Thanks|||Thanks John,
Whats your preference here. Id prefer to only have to research 1 options as
time is limited at this stage. Let me know if you need any more info.
"John K" wrote:
> You could use a stored procedure or view to do all the joins and then call
> the one view or stored procedure from your dataset.
> John K.
> ===> "Tango" wrote:
> > I have various sql, sybase & access databases that i need to report from onto
> > the 1 table. A number of joins link them all together. As you can only use 1
> > dataset, what would be the best way to report on my data into the one table.
> > I have spent weeks trying to work this out. Thanks

Data flows and unique columns.

Perhaps one too many 2000 DTS packages have permanently damaged my ability to think clearly - however, I've find myself very frustrated attempting to create a SSIS Data Flow which replaces a very simple 2000 DTS package.

Take data from table1 in database1, put it in table2 in database2. Table2 in Database2 has an additional column as part of the primary key - so I need to add an arbitrary unique value in each row as it's inserted. Previously, I did this in the transformation script through a variable I incremented.

What's the recommend method to do this now - since row level processing of variables seem to be a no-no?

A script component in the data flow will do what you want. The following script assumes that you grabbed the maxkey in the table BEFORE running the data flow. Then this script increments the maxkey by 1 and then starts incrementing for each row through the data flow.

Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

Public Class ScriptMain
Inherits UserComponent
Private NextKey As Int32 = 0

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

Dim MaximumKey As Int32 = Me.Variables.MaxKey ' Grab value of MaxKey which was passed in

' NextKey will always be zero when we start the package.
' This will set up the counter accordingly
If (NextKey = 0) Then
' Use MaximumKey +1 here because we already have data
' and we need to start with the next available key
NextKey = MaximumKey + 1
Else
' Use NextKey +1 here because we are now relying on
' our counter within this script task.
NextKey = NextKey + 1
End If

Row.ClientKey = NextKey ' Assign NextKey to our ClientKey field on our data row
End Sub

End Class|||

Use a script task:

http://sqljunkies.com/WebLog/sqlbi/archive/2005/05/30/15684.aspx

|||

Hum. So it does work! I suppose I just did a fantastic job of screwing that up when I tried it the first few times.

thanks!