Hello Everyone
i have an ActiveX Script that returns with a global variable then in the
workflow i have an sql task that insert this global variable in a table
so i write in the sql task :
insert into Table values (DTSGlobalVariables("id").value)
It gives me an error "Incorrect Syntax Near DTSGlobalVariables"
Any Idea Whats wrong in this syntax

Thx in Adv

Hi,

You need to define that you want to use a global variable
in this query.

Your query should be (I think):
insert into Table values (?)

Press the parameter button and define parameter #1 to
equal the global variable "id".

Good luck!

Todd, I think this question was around DTS and not SSIS.

In SSIS certainly it fires the event

SSIS package "Package1.dtsx" starting.
SSIS breakpoint 'Break when the container receives the OnProgress event'
at executable 'Execute SQL Task' has been hit

In DTS quickly set up a package and then plug in this code to fire and
you shall see.

http://msdn2.microsoft.com/en-us/lib...3(SQL.80).aspx

--


Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com




"Todd C" <ToddC (AT) discussions (DOT) microsoft.com> wrote