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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 DTS Execute SQL save result

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-08-24 : 23:13:23
Josée Gaudreault writes "Hi !

I'm using sqlserver 7.0 (dts) and visual basic version 6.0.

I find this documentation on books online help:

Execute SQL Task
With the Execute SQL task, you can run SQL statements during package execution. The Execute SQL task also can save data that is the result of a query. Using the Execute SQL task, you can:

Save the complete rowset returned from the query into one global variable.

I want to save the complete rowset returned from the query into one global variable but can i do this in dts 7.0 with visual basic and how ?!?


thanks for your help !"
   

- Advertisement -