dbTalk Databases Forums  

cannot fill dataset from recordset in SSIS SaveCheckpoints set to

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss cannot fill dataset from recordset in SSIS SaveCheckpoints set to in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
bsk_WF
 
Posts: n/a

Default cannot fill dataset from recordset in SSIS SaveCheckpoints set to - 06-15-2010 , 05:10 PM






We have SaveCheckpoints set to True. In a script block we are converting the
Recordset to a DataSet using the following sample code. If we turn
SaveCheckpoints to False everything works as expected and all of the
recordset rows make it into the Dataset. If we turn SaveCheckpoints to True
no records get copied over. If we iterate through the recordset manually to
create the datatable it works fine.

Reply With Quote
  #2  
Old   
bsk_WF
 
Posts: n/a

Default RE: cannot fill dataset from recordset in SSIS SaveCheckpoints set to - 06-15-2010 , 05:41 PM






Here is the sample code:

ADODB.Recordset rs =
(ADODB.Recordset)Dts.Variables["Accounts"].Value;

System.Data.OleDb.OleDbDataAdapter myDA = new
System.Data.OleDb.OleDbDataAdapter();
DataSet myDS = new DataSet("account");
myDA.Fill(myDS, rs, "account");

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.