August 27, 2010 at 10:21 am
I am trying to execute a package through a stored proc passing a parameter...I have a variable in the ssispackage that is maped to the parameter (inoice number)
This package loads the data to another server (not sure if this has to do anything)
--Body of my stored proc
DECLARE @SSISCommand varchar(1000)
SET @SSISCommand = 'DTEXEC /SQL "\Packagename" /SERVER "(local)"'
+ '" /A "InvoiceNumber":"8"="' + @InvoiceNumber
EXEC master.dbo.xp_cmdshell @SSISCommand
Now when I run the stored proc passing invoicenumber, I am getting an error
Could not load package "\Packagename" because of error 0xC0014062.
Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed.
Has anybody encountered this?
Appreciate your help.
August 27, 2010 at 11:59 am
Try explicitly setting the server name.
/SERVER "SERVERNANE\INSTANCENAME"
August 27, 2010 at 12:10 pm
May also be a security issue. Can you run the package directly from SSMS or does this prompt for a password?
Export the package to dtsx file format. Open in a text editor and review the ProtectionLevel. Try setting this to 0.
If this is the issue read this. http://msdn.microsoft.com/en-us/library/ms141747.aspx
August 27, 2010 at 12:38 pm
Try both of your suggestions. No sucess.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply