Hi every body.
I m stuck in weird problem and i.e that my package get fail when i execute it through a job.
But it works abs fine when i execute its through BIDS, Managament studio and even through command prompt.
I am using protectionlevel="DoNotSaveSensitive" and i m storing my user name and password +connection info in my xml configuration file.
but still i m getting this error...
[font="Arial"][/font]Message
Executed as user: BROADCOM\SVCSQLDEV026. ...0.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:04:12 AM Progress: 2008-02-07 00:04:15.19 Source: DFT DatawareHouse to QADC DB Validating: 0% complete End Progress Error: 2008-02-07 00:04:17.13 Code: 0xC0202009 Source: DFT DatawareHouse to QADC DB DM1 DataWareHouse [1] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E09. End Error Error: 2008-02-07 00:04:17.14 Code: 0xC02020E8 Source: DFT DatawareHouse to QADC DB DM1 DataWareHouse [1] Description: Opening a rowset for "[dbo].[Rev_3B_1007S]" failed. Check that the object exists in the database. End Error Error: 2008-02-07 00:04:17.14 Code: 0xC004706B Source: DFT DatawareHouse to QADC DB DTS.Pipeline Description: "component "DM1 DataWareHouse" (1)" failed validation and returned validation status "VS_ISBROKEN". End Error P... Process Exit Code 1. The step failed.
The error regaring check that "[dbo].[Rev_3B_1007S]" object exist in the database....is weired...
since object doest exists in the database..and the user which i m using in xml file has appropriate rights to access this object....
Any immediate help is highly appreciated
Thnx
Rashid