SSIS - Data Conversion and Derived Column

Scenario:

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.



11 comments:

  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.

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. Such a crisp and easy article. SSIS is one of the best I have ever used. Can you be more elaborative about the tool. I am pretty new to this. But I am working in data conversion service company for long time now. Will wait for your next article.

    ReplyDelete
  5. I wanted to thank you for this excellent read!! I definitely loved every little bit of it. I have you bookmarked your site to check out the new stuff you post. hex to decimal converter

    ReplyDelete
  6. Great Blog! This post gives a better idea. Thanks for the useful information. I hope you will share some more content. Please keep sharing! Opt to hire small business support services from telxcomputers.com.

    ReplyDelete
  7. Is it possible to merge Derived Column and Data Conversion into one. We can perform data conversion in derived column transformation as well. What is the disadvantage of doing that ?

    ReplyDelete
  8. Efficiently written information. It will be profitable to anybody who utilizes it, counting me. Keep up the good work. For certain I will review out more posts day in and day out. Nevada Fake ID

    ReplyDelete
  9. I got too much interesting stuff on your blog. I guess I am not the only one having all the enjoyment here! Keep up the good work. maine coon kittens

    ReplyDelete