August 27, 2008 at 8:33 am
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
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
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