Using the SSIS OLE-DB command on non friendly destinations (iSeries DB2)
At the risk of becoming pigeonholed as the guy who only posts about SSIS and iSeries interaction I have decided to post yet again on this subject area. The information provided below may lend itself to other non SQL server OLE DB destinations but I have not tried it with anything other than the MS OLE-DB driver for DB2.
The Issue:
How do you get OLE-DB Command object to work with MS OLE-DB provider. When you go to map parameters nothing is provided in the column mapping window.
The Fix:
You must manually add the columns to the External Columns Output in the Input and Output Properties tab under the OLE DB Command Input section. Then you define these parameters to have correct data type and scale, precision, or length as the DB2 object you are operating on.
The Walk Through:
Setting up the source in this case a SQL Server table:
go
create table testSource
(testChar char(1) not null primary key
,testInte int not null
)
go
insert into testSource
values('T',1)
insert into testSource
values('S',2)
Setting up the destination table on the iSeries:
create table testDest (
testChar char(1) not null
,testInt int not null
)
See Mom no Parameters:
Adding columns:
Running:
Technorati Profile