faqts : Computers : Databases : Microsoft SQL Server

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

3 of 14 people (21%) answered Yes
Recently 1 of 10 people (10%) answered Yes

Entry

Problem running dts package from stored procedure......

May 1st, 2005 15:09
Dominic Mcghee,


Okay so here's my problem. 
when I execute the stored procedure I've created I get this error 
message:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or 
access denied.
....................................................................
my stored procedure code looks like this
SET @sMethod = 'LoadFromSQLServer'
EXEC @hr = sp_OAMethod @object,  'LoadFromSQLServer
(''DBMGDP'',''Pcode'' ,''pcode'' , 256, , , , "Import Planet Code from 
BigRed")'
IF @hr <> 0
BEGIN
	EXEC sp_OAGetErrorInfo @hPkg, @src OUT, @desc OUT
	SELECT hResult = @hr, Source = @src, Description = @desc, Info 
= 'Method - ' + @sMethod, 0 , 0, 0
	RETURN
END
...................................................................