I want to use Script Component in DTS 2005 to transfer data. But I don't have
any document or sample script to solve it.
Pls send to me some.
Very urgent, because my project maybe fail in next week.

Thanks

This NG is not really dedicated to 2005 yet. A better choice maybe the
Beta Newsgroups at MSDN.

What build are you using?

Your project may fail? Hopefully not production right?

The Script component has evolved through the recent builds so any advice
without more information would be damaging.



"HuyLN" <HuyLN (AT) discussions (DOT) microsoft.com> wrote

Concretely, I have 2 source:
- table A from SQL Server 2005 database
- table B from Oracle 10g database
And 1 destination : Table C in SQL Server 2005 database
With each row in table B, we must compare a field value of it with a field
value in table A. If satisfied, this record will be out to C.
I want use "script component" to solve this problem. How can I do?

Pls help me. Reference document or sample script are ok.

Thanks,
HuyLN

"Allan Mitchell" wrote:

Sounds to me more like a MERGE JOIN transform to me.

The script component would probably not perform anywhere near as fast.

There is also a lookup transform.




"HuyLN" <HuyLN (AT) discussions (DOT) microsoft.com> wrote

Sorry, but I think I need to describe more details my problem

I have below code script:
' Microsoft Data Transformation Services user script component
' This is your new script component in Microsoft Visual Basic .NET
' ScriptMain is the entrypoint class for DTS Script Components
Imports System
Imports System.Data
Imports Microsoft.SqlServer.Dts.Pipeline
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

Public Class ScriptMain
Inherits UserComponent
Public i As Integer = 0

Public Overridable Sub InRIREKIHANBAIROUTE_ProcessInputRow(ByVal Row As
InRIREKIHANBAIROUTEBuffer)
'
' Add your code here
'
i = i + 1
OutLOGLOADBuffer.AddRow()
OutLOGLOADBuffer.TABLENAME = "Huy" & "i"
OutLOGLOADBuffer.LASTLOAD = Now()
OutLOGLOADBuffer.SetEndOfRowset()
End Sub

Public Overrides Sub CreateNewOutputRows()
'
' Add rows by calling AddRow method on member variable called
"<Output Name>Buffer"
' E.g., MyOutputBuffer.AddRow() if your output was named "My Output"
'
For i = 1 to 10
OutLOGLOADBuffer.AddRow()
OutLOGLOADBuffer.TABLENAME = "Huy" & i
OutLOGLOADBuffer.LASTLOAD = Now()
Next
End Sub

End Class

I have an input source named InRIREKIHANBAIROUTE and an oputput source named
OutLOGLOAD. I want to use “Script Component” to transform data from
InRIREKIHANBAIROUTE to OutLOGLOAD. With each Row in InRIREKIHANBAIROUTE, I
want to put to OutLOGLOAD a row with tablename field = "Huy" & i (i will be
increased automatically) and lastname field = Now();

I don’t know How can I do that?
Pls help me.

Thanks,

HuyLN

"Allan Mitchell" wrote: