Pages

Tuesday, May 12, 2015

We
will start creating small project which loads data from source flat file to
destination SQL Server database. We included few ways to load data. There may other
ways that would be discussed later in our tutorials

Change data types in Show Advance
editor of Source transformation which causes error. Right click and go to Show
Advance editor and go to tab Input and output properties. Select excel source
properties and drill down the columns select the column which you want Under
Data type properties change the data type. Here above picture indicating that
data type that is DT_DATE (DATE) and DT_WSTR (STRING) miss match. Whatever the data types coming from the source
u need to use those data types in sequential transformations. Then only you
won’t get these type of errors.