Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
majolamp
Starting Member
15 Posts |
 Posted - 2008-05-12 : 03:16:59
|
| Hi AllI'm new in SSIS Development. I have manage to design and deploy my Package to production SQL(MSDB) Security rely on server storage. The problem start when I start scheduling in SQL JOB I'm getting the following error.Executed as user: UCC-SQL\SYSTEM. ...ion 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:57:01 AM Error: 2008-05-12 08:57:02.08 Code: 0xC0202009 Source: Test_deployment_Table Connection manager "BLAKE-DBN12.Staging" 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 'BLAKE\UCC-SQL$'.". End Error Error: 2008-05-12 08:57:02.08 Code: 0xC020801C Source: Data Flow Task Test_Deployment [97] ... The package execution fa... The step failed.What can I do to avoid this. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-12 : 03:50:32
|
| The error message seems like this is due to a network problem rather than a problem with the package itself. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-15 : 22:22:21
|
| Is 'BLAKE\UCC-SQL$' a valid login of data source? |
|
|
|
|
|
|
Scheduling SSIS Package in SQL JOB