SQL Server Performance Forum – Threads Archive

Data Driven Query task error

Hi folks, I have a Data Driven Query task that throws an error when it executes. The error is "ActiveX Scripting Transform requires script Text and Language and at least on Phase function to be specified." What does this mean?
Thanks in advance
Peter

What script was used in ActiveX on the DTS package?
http://msdn.microsoft.com/library/en-us/dtsprog/dtspapps_3y7n.asp for information.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks for replying satya. I have worked around the issue by using a Transform Data task instead of a Data Driven Query task. Peter

]]>