All geek questions in one place

Understanding the SSIS "Complete Result Set"

I have two questions about the result set generated by the SQL execution task -

1) What is the class of the object in which the result set is stored? Is this an ADODB Recordset? 2) Whatever object it is, how one of them iterates over this object. I just want to iterate over it in the form of a grid in the form of a grid, as in the SQL server management studio. I want to do this WITHOUT inserting a DataTable or something like that. It will be a waste of memory and time.

Can someone show me how to do this?

0
source share
2 answers

An alternative would be to use an ADO.NET connection instead of OLEDB. If you use an ADO.NET connection, you will get an ADO.NET DataSet. DataSet is a DataTable.

Some links for DataSet tutorials -

http://www.dotnetperls.com/dataset

Scott Mitchell Tut -

http://msdn.microsoft.com/en-us/library/aa581776.aspx

0
source

1) The result set is technically stored in an OLEDB Rowset, which can be placed in an ADORecordConstruction and converted to an ADO RecordSet. SSIS does this implicitly when you are really accessing object data.

Without scripts, the only way to see this data when running SSIS is to use the Foreach Loop container.

  • Install the Foreach Loop enumerator for the ADO Foreach enumerator.
  • Assign a variable for each column in your result set.
  • Use these variables in a loop to display them in your execution log using event handlers.

If you really want to view the data of an object, I highly recommend creating a data stream, converting the object to a Script source and connecting a data viewer to it to see the data in a grid form.

And finally, I recommend that if you are just trying to debug and view the dataset returned by your SQL task, the Script task can execute the query and quickly display its results (for example) on the local file.

+2
source

Source: https://habr.com/ru/post/1496909/

More articles:


All Articles