MSBI (SSIS/SSRS/SSAS) Online Training

Friday, January 30, 2009

Script for SurrogateKyey Genarate:-

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
Dim counter As Integer = 0 ' User code

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
' Add your code here
Row.mycount = counter ' User code
counter = counter + 1 ' User code
End Sub
End Class

1 comment:

Vale Co Xenia said...

Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a .Net developer learn from Dot Net Online Training from India. or learn thru ASP.NET Essential Training Online . Nowadays Dot Net has tons of job opportunities on various vertical industry.
JavaScript Online Training from India