| Author |
Topic |
|
qman
Constraint Violating Yak Guru
442 Posts |
 Posted - 2011-01-18 : 10:58:37
|
| I am trying to populate a DB2 table with records read from SQL Server.My issue is that I do not see my DB2 connection manager in the list of OLE DB connection managers when editing my OLD DB Destination Editor. How can I write these records to DB2 if I can't connect to the my DB2 destination? Should I be doing this using different Data Flow Destination.I should note that I am trying to connect to a connection manager using a provider of ".Net Providers for OleDB\IBM OLE DB Provider for DB2".Hope this makes sense... |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-18 : 11:34:44
|
| You can use the OLEDB connection manager and type in the properties. Is the driver installed? |
 |
|
|
qman
Constraint Violating Yak Guru
442 Posts |
Posted - 2011-01-18 : 12:10:59
|
| I am using IBM OLE DB Provider for DB2. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-18 : 12:56:39
|
| Is it installed on your workstation that you're developing the package on, and on the SQL Server that the package will be executed from? |
|
|
|
qman
Constraint Violating Yak Guru
442 Posts |
Posted - 2011-01-18 : 13:01:32
|
| Working fine, thanks Russell. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-18 : 13:21:49
|
| Excellent! |
|
|
|
qman
Constraint Violating Yak Guru
442 Posts |
Posted - 2011-01-19 : 07:42:30
|
| Interesting what is happening now... Within SSIS, I can connect to the DB2 table which I want to populate. I can see all the tables which I have to work with, and can select the specific table needed. However, the package fails when it runs that step.Almost like it is a DB2 security issue. The odd thing, I can insert records directly into the DB2 table using a SQL statement externall to SSIS. The same credentials are being used for this SQL statement and the connection manager in SSIS..... Do you think the issue is with the package or with security on DB2. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-19 : 09:53:44
|
| Depends...what error does it fail with? |
|
|
|
qman
Constraint Violating Yak Guru
442 Posts |
Posted - 2011-01-19 : 10:04:06
|
| 8:47:18 AM,1/19/2011 8:47:18 AM,0,0x,ExternalRequest_post: 'IRowset::GetColumnsRowset failed'. The external request has completed.AND 8:47:21 AM,-1073450974,0x,SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OLE DB Destination" (1473) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-19 : 10:47:24
|
| Might be a data mapping issue. You can test that the connection succeeds and that you can execute queries by something simple like SELECT 1;Is this an Execute SQL Task or a Data Flow Task? |
|
|
|
|
Populating DB2 table with SQL records