cannot fill dataset from recordset in SSIS SaveCheckpoints set to

Discussion in 'microsoft.public.sqlserver.dts' started by bsk_WF, Jun 15, 2010.

  1. bsk_WF

    bsk_WF Guest

    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.
     
    bsk_WF, Jun 15, 2010
    #1
    1. Advertisements

  2. bsk_WF

    bsk_WF Guest

    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");
     
    bsk_WF, Jun 15, 2010
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.