Fixed the problem, the following is the working code.

'**********************************************************************

' Visual Basic Transformation Script

'************************************************************************

' Copy each source column to the destination column

Function Main()

Const adTypeBinary =...

When I try to run the ActiveX script I get the following exception.

"ActiveX Scripting Transformation 'DTSTransformation__2':Error parsing script - Error Code:0

Error Source=Microsoft VBScript compilation error

Error Description: Expected statement

Error on Line...

In the ActiveX Transformation Script I have the Main Function calling the ReadBinaryFile Function.

Am I doing this correct?

'**********************************************************************

' Visual Basic Transformation Script

'************************************************************************

function Main()

{

...

This is what I have setup in the Transformation Data Task. Is this what you are suggesting?

'**********************************************************************

' Visual Basic Transformation Script

'************************************************************************

function Main()

{

DTSDestination("Cutsheet").Value = ReadBinaryFile(DTSGlobalVariables("sFileName").Value);

return(DTSTransformStat_OK);

}

Function ReadBinaryFile(sFileName)

Const adTypeBinary...

Hey I am new to the DTS thing, so I am just trying to figure out what your suggestion is.

I am with you now.

Thanks

So I make the "Function ReadBinaryFile(sFileName)" a User Defined Function in SQL?