S
stoned99
Guest
Has anyone managed to use the DDTEK.DB2 provider with SSIS? I managed to reference DDTek.DB2.DB2Connection in the ProviderDescriptors.xml and retrieve a list of tables for an ADO destination using (Note I reduced NumberOfColumnRestrictions from 4 to 3 to make it work) but I'm unable to return the columns. I keep getting the error Message: More restrictions were provided than the requested schema ('Columns') supports. I've tried reducing the NumberOfRestrictions as I did with the tables schema call and no luck. I'm doing this so that I can use SSIS's dynamic mapping to control how dates are formatted (the default includes a time component even for basic dates) For the record the MS OLE DB2 provider does work, and I used the mapping files as my starting point, but I wanted to use the ADO.NET provider for performance reasons.
Continue reading...
Continue reading...