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 |
|
AKP2008
Starting Member
45 Posts |
 Posted - 2008-11-26 : 07:04:22
|
| Hi,In BIDS I have added one "ExecuteSQLTask" with "Resultset" as FullResultSet and "SQLSourceType" as DirectInput and "SQLStatement" is select * from tablename.I am taking resultset into a variable with datatype as "Object".My question is when i execute the "ExecuteSQLTask" i am not able to see the result.Please help.Thanks in Advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-26 : 12:12:04
|
| where do you want to see the result? you need to put a break point at post execute event of executesql task and then check value of recordset. ALternatively you could store recordset in a table and can see the values. |
 |
|
|
AKP2008
Starting Member
45 Posts |
Posted - 2008-11-27 : 00:49:12
|
quote:
Originally posted by visakh16
where do you want to see the result? you need to put a break point at post execute event of executesql task and then check value of recordset. ALternatively you could store recordset in a table and can see the values.
I want to save the ResultSet into file. How can i do this. |
|
|
|
|
|
|
Result set from ExecuteSQL Task