RE: Error while executing the SSIS package
- From: Sean McCown <SeanMcCown@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 1 Feb 2008 11:45:09 -0800
This one shouldn't be that hard...
OK, so you've most likely got one of 2 things going on here...
1. You've deployed with the 'encrypt with user key', which is the default.
What you need to do is save the package with 'Don't save sensitive data'.
this is a package-level property, so click anywhere in an empty space in the
control flow and you'll get the properties for it on the right. The choice
is somewhere close tot he bottom.
2. The acct the package is running under on the server doesn't have the
rights it needs to access the file.
--
Read my book reviews at:
www.ITBookworm.com
Blog Author of:
Database Underground -- http://weblog.infoworld.com/dbunderground/
DBA Rant – http://dbarant.blogspot.com
"AVL" wrote:
Hi,.
Here is a strange problem i"m facing with my SSIS pakcage.
I've a SSIS package which reads from a csv file and loads the records into
database. I've used a Flat File as source and OLEDB as destination.
On my development machine, the package runs fine. But when I deploy package
to the server, tehn I'm unable to execute the package. It
gives the below error
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: "Login
failed for user 'FAC\EBMSDBH$'.". End Error Error: 2008-01-18 05:30:26.72
Code: 0xC020801C Source: BuilidingOrFacilityDim EBMSAPP(OLTP) [1]
Description: SSIS Error Code
DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection
method call to the connection manager
"ebmsapp.facilities.unc.edu.HostedControls" failed with error code
0xC0202009. There may be error messages posted before this with more
information on why the Acquire. The step failed.
how do i resolve it?
- Prev by Date: RE: DTS Package moves only one record (randomly)
- Next by Date: RE: ssis, sql job and windows authentication - how to impersonate
- Previous by thread: RE: DTS Package moves only one record (randomly)
- Next by thread: RE: ssis, sql job and windows authentication - how to impersonate
- Index(es):
Relevant Pages
|
