Moving SSIS Package

Hi,

I have to move my SSIS Project from Machine1 to Machine2 in a Development environment.when i open the Project in Machine2 .i have to restore all the connections in the connection manager. even after restoreing the connection sucessfuly .the package looks perfectly with out any error.but when i run the package.i am getting the following error

[Connection manager "Srv1.DBTest"] Error: An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80040E4D Description: "ORA-01017: invalid username/password; logon denied ".

How to solve the problem.

Thanks

Jegan

I'd say the Oracle connection has lost the password, which may be caused by your Protectionlevel property for the package. I'd recomened using DoNotSaveSensitive, and then use a configuration to provide the connection details. This makes it easier if any connection detaisl chance as you jsut edit (common) configurations rather than having to chaneg the packages.

Setting the Protection Level of Packages
(http://msdn2.microsoft.com/en-us/library/d4b073c4-4238-41fc-a258-4e114216e185.aspx)

|||

Are you using Windows Authentication or Sql Server Authentication in your Oledb connection. Try using the user id /pass one which you were using in machine one ....second if you are using windows authentication log in the machine two with the same user id for which ur oledb connection manager is configured...

I think it should solve your problem.....:--)

|||

Darrne, its working fine . thanks for the help.

Vikram Thanks for the suggestion.