November 4, 2004 at 10:19 am
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.
November 5, 2004 at 7:11 am
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
November 5, 2004 at 12:25 pm
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!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply