jrmendez
asked on
SSIS Job SQL Server
Hi everyone
I need some help with a problem related to a execution of a SSIS Package in a SQL Server Job. I'm trying to connect an Oracle DB to extract data from it in order to inserted into a SQL Server table.
But I keep getting this error: (mainly the ORA-12514)
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3042.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 11:41:41 AM
Error: 2009-07-17 11:41:42.94
Code: 0xC001000E
Source: Carga_Idiomas_Oracle
Description: The connection "Carga_Idiomas_Oracle.dtsx " is not found. This error is thrown by Connections collection when the specific connection element is not found.
End Error
Error: 2009-07-17 11:41:43.32
Code: 0xC0047062
Source: Data Flow Task Lee los idiomas de oracle [1]
Description: System.Data.OracleClient.O racleExcep tion: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
at System.Data.OracleClient.O racleExcep tion.Check (OciErrorH andle errorHandle, Int32 rc)
at System.Data.OracleClient.O racleInter nalConnect ion.OpenOn LocalTrans action(Str ing userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
at System.Data.OracleClient.O racleInter nalConnect ion..ctor( OracleConn ectionStri ng connectionOptions)
at System.Data.OracleClient.O racleConne ctionFacto ry.CreateC onnection( DbConnecti onOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.D bConnectio nFactory.C reatePoole dConnectio n(DbConnec tion owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.D bConnectio nPool.Crea teObject(D bConnectio n owningObject)
at System.Data.ProviderBase.D bConnectio nPool.User CreateRequ est(DbConn ection owningObject)
at System.Data.ProviderBase.D bConnectio nPool.GetC onnection( DbConnecti on owningObject)
at System.Data.ProviderBase.D bConnectio nFactory.G etConnecti on(DbConne ction owningConnection)
at System.Data.ProviderBase.D bConnectio nClosed.Op enConnecti on(DbConne ction outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OracleClient.O racleConne ction.Open ()
at Microsoft.SqlServer.Dts.Ru ntime.Mana gedHelper. GetManaged Connection (String assemblyQualifiedName, String connStr, Object transaction)
at Microsoft.SqlServer.Dts.Ru ntime.Wrap per.IDTSCo nnectionMa nager90.Ac quireConne ction(Obje ct pTransaction)
at Microsoft.SqlServer.Dts.Pi peline.Dat aReaderSou rceAdapter .AcquireCo nnections( Object transaction)
at Microsoft.SqlServer.Dts.Pi peline.Man agedCompon entHost.Ho stAcquireC onnections (IDTSManag edComponen tWrapper90 wrapper, Object transaction)
End Error
Error: 2009-07-17 11:41:43.32
Code: 0xC0047017
Source: Data Flow Task DTS.Pipeline
Description: component "Lee los idiomas de oracle" (1) failed validation and returned error code 0x80131938.
End Error
Error: 2009-07-17 11:41:43.32
Code: 0xC004700C
Source: Data Flow Task DTS.Pipeline
Description: One or more component failed validation.
End Error
Error: 2009-07-17 11:41:43.32
Code: 0xC0024107
Source: Data Flow Task
Description: There were errors during task validation.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 11:41:41 AM
Finished: 11:41:43 AM
Elapsed: 1.969 seconds
I hope someone can help me here please!!!
thanks in advance.
I need some help with a problem related to a execution of a SSIS Package in a SQL Server Job. I'm trying to connect an Oracle DB to extract data from it in order to inserted into a SQL Server table.
But I keep getting this error: (mainly the ORA-12514)
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3042.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 11:41:41 AM
Error: 2009-07-17 11:41:42.94
Code: 0xC001000E
Source: Carga_Idiomas_Oracle
Description: The connection "Carga_Idiomas_Oracle.dtsx
End Error
Error: 2009-07-17 11:41:43.32
Code: 0xC0047062
Source: Data Flow Task Lee los idiomas de oracle [1]
Description: System.Data.OracleClient.O
at System.Data.OracleClient.O
at System.Data.OracleClient.O
at System.Data.OracleClient.O
at System.Data.OracleClient.O
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.OracleClient.O
at Microsoft.SqlServer.Dts.Ru
at Microsoft.SqlServer.Dts.Ru
at Microsoft.SqlServer.Dts.Pi
at Microsoft.SqlServer.Dts.Pi
End Error
Error: 2009-07-17 11:41:43.32
Code: 0xC0047017
Source: Data Flow Task DTS.Pipeline
Description: component "Lee los idiomas de oracle" (1) failed validation and returned error code 0x80131938.
End Error
Error: 2009-07-17 11:41:43.32
Code: 0xC004700C
Source: Data Flow Task DTS.Pipeline
Description: One or more component failed validation.
End Error
Error: 2009-07-17 11:41:43.32
Code: 0xC0024107
Source: Data Flow Task
Description: There were errors during task validation.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 11:41:41 AM
Finished: 11:41:43 AM
Elapsed: 1.969 seconds
I hope someone can help me here please!!!
thanks in advance.
http://www.sqlservercentral.com/Forums/Topic516217-148-1.aspx
did you specify the oracle connection password in a configuration file? SSIS packages do not store the connection password, instead you should suply it in a configuration file. check taht is correct.
ASKER
Yes I did specify the password in a config file XML.
Then I add the configuration file as shown in the image I attached.
Is there something wrong with that?
ssis-config.JPG
Then I add the configuration file as shown in the image I attached.
Is there something wrong with that?
ssis-config.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.