Ray,

I've tried to state my assumptions below clearly, since you
were brief in your description of your DTS package.

I assume you are *not* using either a Transform Data Task or
a Data Driven Query task.

If I am wrong, I suggest you click the Preview button in the
Source tab of that task to see if it shows any data.

If I am right, I suggest you (temporarily) create a Transform
Data Task (which might require you to create a second dummy
connection) with this same connection as your source
connection. Then, for the source, choose SQL query and put
the query you are using into the source query window. Then
click the Preview button.

Once you have tried to preview, if you see no data, then
either (1) your query returns no data or (2) there is
something wrong with your query or (3) there is something
wrong with your connection. If you see data in the preview
window, then I'll want to take a look at your Execute SQL
task (assuming you are using an Execute SQL task for your
query plus multiple local temp tables).

Hope this helps as a first debug step.

Dan

Dan McCue
University of Illinois at Urbana-Champaign
Facilities & Services
Information Technology Services
Physical Plant Service Building
1501 South Oak Street
Champaign, IL 61820

Entena Raymond (mssqldba-ezmlmshield-
x75402943.[Email address protected] wrote:

Hi Gurus,

I'm using SQL query and multiple local temp tables in my DTS
source connection.
Every time I run the DTS, the source connection is not
returning a result set.

Can you help me please?

Thanks,
Ray

MS Sql Server LazyDBA home page