No Parameters in SQL statement.

#1

I have a Transform Data Task (TDT) in my package connecting to SQL Server, the SQL in the TDT is 'SELECT [PartNo], [Description], SUM([Qty]) AS Total
FROM DailyProdTotals where ProdDate >= gsLastUploadDate
GROUP BY [PartNo], [Description];', the gsLastUploadDate is a global var, that I retrieve before i execute the TDT, but the TDT says there are no parameters, so I can't save the SQL script in the TDT.
Much appreciated

#2

Change gsLastUploadDate to ?
You cannot use the global variable name directly. To the SQL parser there is
no indiocation that this anything other a column name or other SQL
identifier.

Darren Green
http://www.sqldts.com

"Gary Spence" <GarySpence (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have a Transform Data Task (TDT) in my package connecting to SQL Server,
the SQL in the TDT is 'SELECT [PartNo], [Description], SUM([Qty]) AS Total
FROM DailyProdTotals where ProdDate >= gsLastUploadDate
GROUP BY [PartNo], [Description];', the gsLastUploadDate is a global var,
that I retrieve before i execute the TDT, but the TDT says there are no

parameters, so I can't save the SQL script in the TDT.

Quote:

Much appreciated

#3

There will be a button at the bottom of the source tab for the Data pump task for Global variables set them in order of operation.

"Darren Green" wrote:

Quote:

Change gsLastUploadDate to ?
You cannot use the global variable name directly. To the SQL parser there is
no indiocation that this anything other a column name or other SQL
identifier.

Darren Green
http://www.sqldts.com

"Gary Spence" <GarySpence (AT) discussions (DOT) microsoft.com> wrote in message
news:A5A82CDE-A2B8-4A63-B9FE-A498136A16F6 (AT) microsoft (DOT) com...
I have a Transform Data Task (TDT) in my package connecting to SQL Server,
the SQL in the TDT is 'SELECT [PartNo], [Description], SUM([Qty]) AS Total
FROM DailyProdTotals where ProdDate >= gsLastUploadDate
GROUP BY [PartNo], [Description];', the gsLastUploadDate is a global var,
that I retrieve before i execute the TDT, but the TDT says there are no
parameters, so I can't save the SQL script in the TDT.
Much appreciated

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

No Parameters in SQL statement.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

No Parameters in SQL statement. - 07-21-2004 , 07:57 AM

Re: No Parameters in SQL statement. - 07-21-2004 , 08:52 AM

Re: No Parameters in SQL statement. - 07-21-2004 , 05:26 PM