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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 ssis master package fail.

Author  Topic 

mahesh.maha
Starting Member

1 Post

Posted - 2007-10-29 : 09:29:53
Hi

I have created a SSIS master package. It is contains two child package. The master package is running in fine .

But i am calling the master package in the sql server agent\jobs,the following error coming.



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 'test1'."



pl help me.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-29 : 22:38:59
Is it sql login? Does the package save password properly?
Go to Top of Page
   

- Advertisement -