Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-06-07 : 11:17:50
|
| wpm writes "I am constructing a DTS package with a sql working correctly in Sql Query Analyser without any parameter. To use it as the source SQL Query in Transform Data Task Properrties window, I observed: 1) Parse Query always Ok; 2) Executing the query inside Data Transformation Services Query Designer (Build Query... button) always fetch rowset; 3) To preview (Preview button) the query rowset works only for the first time. Any subsequent preview will get "No rowset was returned from the SQL statement." error; 4) In any case, no source columns shown in the Transformation tab page of Transform Data Task Properties window, which prevents me from doing any data transformation.There is a cursor inside the sql for building the query statement string before it gets executed.Could you help?" |
|
|
|
|
|
DTS source query fails.