January 29, 2010 at 5:08 pm
Step ID1
ServerSERVERNAME
Job NameWFR
Step NameWFR
Duration00:00:00
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: ABC\XYZ. ...sion 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:01:02 PM Error:
2010-01-29 16:01:02.61 Code: 0xC0202009 Source: FRXSERVER Connection manager "XSERVER.WL" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE
DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description:
"Communication link failure". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "TCP Provider: An
existing connection was forcibly closed by the remote host. ". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D
Description: "Login failed for user 'ABC\XYZ'.". End Error Error: 2010-01-29 16:01:02.61 Code: 0xC020801C Source: Data Flow Task OLE DB Destination
[439] D... The package execution fa... The step failed.
I am trying to automate an SSIS package which imports data into a sql server table from a text file . Looks like the account ABC\XYZ does not the permissions
to import the data from the text file into the table when I try to automate the SSIS package.But when I manually run the SSIS package the import happens
sucessfully .
Thanks
January 29, 2010 at 5:11 pm
I am trying to automate an SSIS package which imports data into a sql server table from a text file . Looks like the account ABC\XYZ does not the permissions
It looks like you answered your own question. Your user account has access to the folder location of the flat file but the account ABC\XYZ does not. Grant ABC\XYZ access to the folder where the flat file is stored and everything should work as expected.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply