I have an SSIS package importing data from excel. I have coded it and deployed it on the sql 2008 server. I then execute it via a stored procedure with the following:
'C:\"Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTExec.exe" /sq "HRIS"'
@cmd = @cmd
' /SET \Package.Variables[User::path].Properties[Value];"'
This works fine when i execute it on my local machine. But when I try to call this Stored proc from my asp app (classic asp, not .net) I get the error:
Source: HRIS Connection manager "SourceConnectionExcel"
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".
Any help would be greatly apprecitated
View Complete Post