Global Prameters - Transform Data Task

#1

Hi ALL,

When i am passing global parameters for sql query (subquery) in Transform
Data Task getting error

For Example :
SELECT *
FROM (SELECT * FROM Txn
WHERE Dt_Changed_Date > ? AND
Txn.ParentTxnID IS NULL ) as T

Error Source : Microsoft OLEDB Provider for Sql Server
Error Description : Syntax error or access violation

If i replace '?' with hardcoded value it works fine, but i need to pass
dynamic value which stored in Global parameter.

Many thanks to all in advance...

Soma

#2

Did you add the parameter by clicking on the Parameters button on the source
tab??

http://sqlservercode.blogspot.com/

"Soma" wrote:

Quote:

Hi ALL,

When i am passing global parameters for sql query (subquery) in Transform
Data Task getting error

For Example :
SELECT *
FROM (SELECT * FROM Txn
WHERE Dt_Changed_Date > ? AND
Txn.ParentTxnID IS NULL ) as T

Error Source : Microsoft OLEDB Provider for Sql Server
Error Description : Syntax error or access violation

If i replace '?' with hardcoded value it works fine, but i need to pass
dynamic value which stored in Global parameter.

Many thanks to all in advance...

Soma

#3

Soma,

Have a look here (about 1/2 way down the page)
http://www.sqldts.com/default.aspx?234

In summary, just trust that it works.

Thomas Bradshaw
MyWebGrocer.com
Data Integration Services

--
Message posted via http://www.sqlmonster.com

#4

When i click Parameter button to add Parameters then i got those errors, not
able to set Parameters

soma

"SQL" wrote:

Quote:

Did you add the parameter by clicking on the Parameters button on the source
tab??

http://sqlservercode.blogspot.com/

"Soma" wrote:

Hi ALL,

When i am passing global parameters for sql query (subquery) in Transform
Data Task getting error

For Example :
SELECT *
FROM (SELECT * FROM Txn
WHERE Dt_Changed_Date > ? AND
Txn.ParentTxnID IS NULL ) as T

Error Source : Microsoft OLEDB Provider for Sql Server
Error Description : Syntax error or access violation

If i replace '?' with hardcoded value it works fine, but i need to pass
dynamic value which stored in Global parameter.

Many thanks to all in advance...

Soma

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

Global Prameters - Transform Data Task

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

Global Prameters - Transform Data Task - 10-18-2005 , 10:17 AM

RE: Global Prameters - Transform Data Task - 10-18-2005 , 11:23 AM

Re: Global Prameters - Transform Data Task - 10-18-2005 , 11:32 AM

RE: Global Prameters - Transform Data Task - 10-18-2005 , 11:37 AM