Datapump Error

• Michael Ramsey-187231

  Grasshopper

  Points: 12

  More actions

  November 4, 2004 at 10:19 am

  #59547

  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.

   

• Bill Burkett

  Old Hand

  Points: 328

  More actions

  November 5, 2004 at 7:11 am

  #529086

  Do a search in your SQL help for "Transform Phase" and then read the entry "ActiveX Script Transformation Properties"

  "Never give them a fish, never teach them to fish, but always help them to learn to fish. Eventually they will get hungry enough to want to learn." Hari Smith

• Michael Ramsey-187231

  Grasshopper

  Points: 12

  More actions

  November 5, 2004 at 12:25 pm

  #529147

  Thanks very much for the reply.  I am not using an ActiveX Script.  I am only using 2 Connection objects and a Data Driven Query Task object.  I have tried changing the Data Driven Query Task around to use queries instead of tables.  I have also tried inserting a ActiveX script in the workflow that executes prior to the Data Driven Query Task being called.  However I keep getting this error.  I have also found that any new Data Driven Query task I create in either an existing package or a new package generates the same error.  Could there be something in my SQL Server setup?

  Thanks again!