Post reply

Can''t Save DTS

  • September 16, 2005 at 10:12 am

    #168363

    I have a package that has an active x object that creates a recordset from a string global variable that is a sql string, then sets a global variable to the recordset.  Everything seems to work fine, except when I try to save the package I get the following error. 

    Error Source: ADODB.Recordset

    Error Description: Operation is not allowed when the object is closed.

    This error has also happened when trying to save packages that don't set a global variable to a recordset, so that isn't the reason.  How can I fix this????

    Thanks,Adam

     

  • September 19, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • June 25, 2007 at 7:17 am

    #714911

    I had this error and while I can't claim to have solved the problem I did get round it.

    I had some ActiveX VB script which ran Ok but gave this eror when I tried to Save it.

    I put a line in my ActiveX code which errored on execution. Then I removed it and did a 'Save' and it worked.???

    Cheers,

    Craig

  • June 25, 2007 at 7:29 pm

    #715075

    Set the global variable = Nothing at the end of your Active X Script task.

    DTSGlobalVariables("Name of var").Value = Nothing

     

    You'll be able to save the package.

  • June 26, 2007 at 12:50 am

    #715120

    Thanks Erik.

    Cheers,

    Craig

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply