Howdy,
Trying to run a SSIS package in my .Net app. The error is below. The
connection string in the package has the complete connection with user name
and password, DELPHI\OPTIMUSP RIME is my workstation...
FailureError in Microsoft.SqlSe rver.Dts.Runtim e.Package/Connection manager
"DestinationCon nectionOLEDB" : An OLE DB error has occurred. Error code:
0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Native
Client" Hresult: 0x80040E4D Description: "Login failed for user
'DELPHI\OPTIMUS PRIME$'.".
Error in Microsoft.SqlSe rver.Dts.Runtim e.TaskHost/Destination -
tblTrafficStops [131] : The AcquireConnecti on method call to the connection
manager "DestinationCon nectionOLEDB" failed with error code 0xC0202009.
Error in Microsoft.SqlSe rver.Dts.Runtim e.TaskHost/DTS.Pipeline : component
"Destinatio n - tblTrafficStops " (131) failed validation and returned error
code 0xC020801C.
Error in Microsoft.SqlSe rver.Dts.Runtim e.TaskHost/DTS.Pipeline : One or more
component failed validation.
Error in Microsoft.SqlSe rver.Dts.Runtim e.TaskHost/ : There were errors
during task validation.
Script is below:
Dim app As New Application
Dim pkg As New Package
Dim pkgLocation As String
Dim pkgResults As DTSExecResult
Dim vars As Variables
Dim el As New EventListener
pkgLocation = Server.MapPath( "app_data/import.dtsx")
pkg = app.LoadPackage (pkgLocation, el)
pkgResults = pkg.Execute(Not hing, Nothing, el, Nothing, Nothing)
Response.Write( pkgResults.ToSt ring)
Response.Write( el.EventLog)
--
David Lozzi
Delphi Technology Solutions
Blog: www.lozzi.net