Hello,

i would like to change the DTS-AtiveX template:
If i create a new Data-Tranform with ActiveX, so i get ever this template:
'************************************************* *********************
' Visual Basic Transformation Script
'************************************************* ***********************

' Copy each source column to the destination column
Function Main()
DTSDestination("Name") = DTSSource("Name")
Main = DTSTransformStat_OK
End Function

Can i change this? How can i change it?

THX
Michael

Not sure what you mean but the text you have posted is an Active Script
transform and you can change this in the DTS Designer (Transforms tab for
the DataPump). Where are you seeing this? To what would you like to change
it?



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Michael Kruss" <michael.kruss (AT) spider-lcm (DOT) de> wrote

I've got 10 rpt-files, i would like to transfer it to my SQL Server. So i
must change every ActiveX with the same. So i must open every Data-Tranform
and copy end paste this (or like this)

Function Main()
myv = TRIM(DTSSource("Name"))
IF LEN(myv)=0 OR lcase(myv) = "null" THEN
myv = NULL
END IF
DTSDestination("Name") = myv
Main = DTSTransformStat_OK
End Function

every rtp-file has 20-30 Datafields. With an other ActiveX Template, i could
customise my Data-Transform faster ....

THX 4 help
Michael



"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

OK then that is possible but you must ensure that the SourceColumns and the
DestinationColumns are available in each "version"
These will not magically change just because you change the ActiveScript
transform

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Michael Kruss" <michael.kruss (AT) spider-lcm (DOT) de> wrote

How? You write it is possible, but how can i change the ActiveX Template?

plz help
Michael

And as stated it will not be a simple case of simply changing this
"template". The task will fail if you do not have the columns referenced by
the script in your datapump available.

The property you are looking for is on the Transformation Object

Have a look here in BOL

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\dtsprog.chm::/dtspproptz_26pm.htm

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Michael Kruss" <michael.kruss (AT) spider-lcm (DOT) de> wrote