Post reply

error: OLE has sent a request and is waiting for a reply

  • August 27, 2008 at 8:33 am

    #124382

    hi guys i have a ssis package in which i created a sql task to execute a stored procedure but when i try to execute it i get the following message:

    Error starting debugging:

    Additional Information

    Unable to start program 'C:\SSIS\Mypackages\Report\MyPackage.dtsx'.

    OLE has sent a request and is waiting for a reply.

    (Microsoft Visual Studio Debugger)

    ------------------------------

    Program Location:

    at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)

    at Microsoft.DataTransformationServices.VsIntegration.NativeMethods.ThrowOnFailure(Int32 hr, Int32[] expectedHRFailure)

    at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.LaunchVsDebugger(IVsDebugger iVsDebugger, DataTransformationsProjectConfigurationOptions options)

    I see that when i execute the stored procedure in management studio it takes around 60 seconds to run so maybe is the timeout option within the package, right now is set to 0, to which number should i try changing it to?

    Any ideas what can i try?

  • August 27, 2008 at 11:55 am

    #863906

    Do you have the right permission on the database where the stored procedure exists, which you are trying to execute?

    VG

  • August 27, 2008 at 2:09 pm

    #863967

    yes i do.

Viewing 3 posts - 1 through 2 (of 2 total)

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