Datapump Error

[DevMission]

I'm getting a strange error using the Data Driven Query Task. I have not been able to find anything on this error anywhere on the internet. Has anyone ever had this error: ActiveX Scripting Transform requires script Text and at least one Phase function to be specified.

 

[gradley]

Do you have a sample of the ActiveX script you are using to convert the data?

It sounds like you are not specifying one of the INSERT, UPDATE, DELETE or SELECT transforms.

Ex:
Main = DTSTransformstat_InsertQuery

 

[DevMission]

Thanks Gradley for replying.

I get the same error is I use a SQL Query or if I use Tables. This happens with any Data Driven Query Task I create in any package. I've tried to eliminate all other variables by creating a package that consists of only 2 Connection Objects and a Data Driven Query Task object. I have also tried inserting an ActiveX script in the Workflow prior to the object being executed.

Here is the SQL that I created under the Query tab:

INSERT
INTO dbo.ziciciDataVal
(ValType, ValCode, ValDesc)
VALUES (?, ?, ?)

Thanks again!

 

[gradley]

When you say you are inserting an ActiveX script in the workflow, I'm assuming you mean to perform the transformation? This I believe is the "Script Text" the error is referencing.

 

[DevMission]

When I inserted an ActiveX Script in the WorkFlow it did not do any transformations. All it did was generate one function in VBScript that calls the Data Driven Query Task Object. I get the same error if I do or do not use the ActiveX Script.