Query Issue

[rodeomount]

I'm trying to create a query I can use inside a DTS by dynamically setting the Query inside a dynamic properties task. Below is my select statement for creating the Select statement. I keep getting an error. It's mandatory that I use the query to load the values into the "IN" clause because this query will be run against an oracle db and the values I need in the "IN" clause are coming from SQL Server.

Select 'Select SVC_MS_REC_STS_CD,DTN_ARA_NO_PU_IR
from O858IA.VSVCPAK
where PKG_TCK_NR in (' + Select top 1000 TrackingNum from dbo.TEMP_TPSVCREQ order by TrackingNum + ')'

 

[SQLBill]

What is the error?

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[SQLBill]

BTW- normally you declare a variable to hold the statement, then populate the variable with the statement.

DECLARE @sql VARCHAR(1000)
SET @sql = 'Select SVC_MS_REC_STS_CD,DTN_ARA_NO_PU_IR
from O858IA.VSVCPAK
where PKG_TCK_NR in (' + 'Select top 1000 TrackingNum from dbo.TEMP_TPSVCREQ order by TrackingNum' + ')''

EXEC (@sql)

Also, it appears you are missing some single quotes.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875