SSIS - Data Conversion and Derived Column


Lets say we have some data in text file that we need to load into our SQL table. We have to perform data conversion on SaleDate and then also have to get previous date from SaleDate to insert into our final Table.

Solution :

Step 1:
Create file file source by using Flat File Source.
Step 2:
Bring Data Conversion and connect to Flate File Source as shown and convert the data type to DT_DBDATE

Step 3:
Bring Derived column Transformation so we can get previous date from SaleDate coming from Source. Remember we have converted the SaleDate to DT_DBDate and now we will use column Copy of SaleDate in our Derived Column.

Final Output:

Put Data Viewer between Derived column and Destination so see if all values are transformed correctly.

1 comment:

  1. I admire this article for the well-researched content and excellent wording. I got so involved in this material that I couldn’t stop reading. I am impressed with your work and skill. Thank you so much. Dataentrysolindia offers the Top Data Conversion Services at the affordable price.