Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Zach Nichter Writing to a File Using the sp_OACreate Stored Procedure and OSQL: The RE: Writing to a File Using the sp_OACreate Stored Procedure and OSQL: The

  • November 15, 2006 at 9:52 am

    #672044

    I modified a stored procedure that moved DTS packages from one server to another.  It is from http://www.dbazine.com/sql/sql-articles/larsen8

    It would stop after moving 255 packages, everytime, no mateter how the packages were sorted.

    It would always stop at sp_OAMethod @object, 'LoadFromSQLServer'.  Make of it what you will. Smells like a memory leak.