June 6, 2005 at 12:03 pm
I have this code in my ASP page:
objPkg.LoadFromSQLServer "WMCCWKTBSWZ90EZ", "asp", "rob", DTSSQLStgFlag,"","","","CopyIssuers3"
DTS package "CopyIssuers3" is logging to EventViewer.
This is what EventViewer shows:
-----------------------------------------------
Package Name: CopyIssuers3
Package Description: (null)
Package ID: {C3B6F00A-6CCE-46B2-8882-40FE96A936FF}
Package Version: {2E001A4B-E750-452C-A05E-CB3522661E69}
Package Execution Lineage: {72F5E791-3E0A-41FB-A800-2C885EF2C29B}
Executed On: WMCCWKTBSWZ90EZ
Executed By: opeshrob
Execution Started: 6/6/2005 1:38:42 PM
Execution Completed: 6/6/2005 1:38:46 PM
Total Execution Time: 4.036 seconds
Package Steps execution information:
Step 'Truncate' failed
Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:Login failed for user 'WMCCWKTBSWZ90EZ\IWAM_WMCCWKTBSW0074P'.
Step Error code: 80040E4D
Step Error Help File:
Step Error Help Context ID:0
----------------------------------------------------
opeshrob is my domain account.
My question is why the log shows that "Package is executed by opeshrob"
but later when it fails it specifies a differenr account 'WMCCWKTBSWZ90EZ\IWAM_WMCCWKTBSW0074P'?
June 7, 2005 at 5:45 am
Check to see if objPkg is defined as a Package object rather than a Package2 object. Load the package with the following method call.
objPkg.LoadFromSQLServer "WMCCWKTBSWZ90EZ", "asp", "rob", 0, Nothing, Nothing, Nothing, "CopyIssuers3"
-Mike Gercevich
June 7, 2005 at 7:32 am
I would be very interested in the code that executes the packages from an ASP page. Can you inculde the steps leading to the actual execution of the package?
June 7, 2005 at 7:40 am
June 7, 2005 at 8:09 am
thanks!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply