I just want to discuss a method with you to discover the column data types of a table in a DB2 database. I not own the documentation and only a reduce set of tables are exposed, I mean, I only have read access to 4 tables.
At the moment I select all of the columns using a OLEDB Source (MS DB2 Driver) and then connect this source directly to an OLEDB Destination, SQL Server database, and press the "New" button as the target table, just to let SSIS determine (or guess) the columns data type.
The SSIS is good at guessing but I would like to make my own method, like a basic verification of available types.
For instance, if a column has only numbers is numeric, but if it has numbers, NULLs and empty values ("") could also be numeric. But the empty values make the SSIS to marks it as a VARCHAR column, even if the column does not have alphabetic characters.
Any ideas or comment would be appreciated.