Using Data Transformation Services: Capture Recordset with a Global Variable - The Query on the Northwind database

(Page 2 of 4 )

The following query run against the Northwind database produces the following result as shown in the next picture. The results returned by the query (seven rows, four columns each) are shown in the results pane of the query analyzer, also seen in the same picture. This result will be assigned to a global variable in the next section.

Next: Stuffing rowset into a global variable >>
 

More MS SQL Server Articles
More By Jayaram Krishnaswamy

Comments On: Using Data Transformation Services: Capture Recordset with a Global Variable

· Most of my tutorials on DTS deals with the usage of the DTS Designer. I am...   >>> Post your comment now!