Hello,

I can't figure out how to set up Transformation scripts for the
DataPumpTransformation in ActiveX.

The vb code

Set oTransProps = oTransformation.TransformServerProperties

oTransProps("Text") = txtSourceCode


Always generates object does not support this method. Is it possible
to do in ActiveX or do I have to do this in VB?

Thanks in advance,

Sam G

Have you tried scripting out to VB and then looking to see how DTS scripts
itself out?
What are you trying to achieve?

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Sam G" <sghaneka (AT) yahoo (DOT) com> wrote

Basically, I wanted to create a package in vbscript that would
dynamically change the transformation based on a source text file and
a database table. I tried this syntax and things seem to work, so
thanks anyway.

Set oTransProps = oTransformation.TransformServer
Dim strCode
strCode = "Function Main()" & vbCrLf
strCode = strCode &
"DTSDestination(""PRODUCT_LINE_CD"")=DTSSource(""C OL001"")" & vbCrLf
strCode = strCode & "Main = DTSTransformStat_OK" & vbCrLf
strCode = strCode & "End Function"

oTransProps.Text= strCode
oTransProps.FunctionEntry = "Main"
oTransProps.Language = "VBScript"
oTransProps.Item("Text").Value = "Function Main()" & vbCrLf

Instead of:

Set oTransProps = oTransformation.TransformServerProperties
oTransProps("Text") = strCode

I am not sure why I the reason is though.

Sam

sghaneka (AT) yahoo (DOT) com (Sam G) wrote in message news:<fe57b32d.0312090710.3f5dbca7 (AT) posting (DOT) google.com>...