Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Operation could not be completed : Access is denied
the Test connection works fine. I can create a brand new SSIS package, create my connection and save it and it will work fine. But I can edit an existing SSIS and save the modification to the connection. I aslo tried deleting the connection in the existing SSIS and create a new one and I can't...- Eddiecan
- Post #3
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
Operation could not be completed : Access is denied
Hi, I'm trying to make a modification and change the settings on one connection and when I'm trying to click OK/save it I get "The operation could not be completed: Access is denied" (this on SQL Server 2005, MS Visual Studio(BIDS)) I searched the web and I found out people were saying to go...- Eddiecan
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
SSIS and Connection Password
Thanks for the info I changed it to EncryptwithUserKey and now I'm getting : [Get Status Records [655]] Error: System.InvalidOperationException: Invalid operation. The connection is closed. at System.Data.OracleClient.OracleCommand.GetStatementHandle() at I'm trying to connect my...- Eddiecan
- Post #3
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
SSIS and Connection Password
Hi, I have an SSIS package where it keeeps failing and give the following error message : "System.Data.Odbc.OdbcException: ERROR [28000] [Oracle][ODBC][Ora]ORA-01005: null password given; logon denied ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR...- Eddiecan
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Integration Services (SSIS)
