Hi,

I have to import data from a hand made Excel file into a data base. The
excel file is build by an other department of my company. As this process
needs to be done many times, I build a SSIS package for it.
My problem is the following: as the Excel file is build manually, Typos can
happen easily. Thus, I need to check the data type first before being able
to just import it in the Database. A date must be a date with a proper
format that the DB can understand and store, a char(30) must be a string
not exceeding 30 characters and so on... Is there anyone who knows what's
the best approach in SSIS to check data type before importing the data in a
DB table? I have no idea if there is a pre-defined task for that... Or if I
should write some custome (C#?) code for that (if so, how?)

Best regards and thanks in advance.

Francois Malgreve

Hello msnews.microsoft.com,

Ok there are a number of ways to attack this and depending on your actual
requirements they may differ. One solution would be to use a conditional
split transform. In there test the length of the column and if it meets
your criteria you pipe the row one way else you pipe it a different way downstream.
Another way is to use a Script transform. Once inside here with your VB.Net
code you can pretty much do whatever you want.


Thanks

Allan