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.
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.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteSuch 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.
ReplyDeleteI 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
ReplyDeleteExactly, you're very kind of us about comment!. buy instagram likes paypal real
ReplyDeleteGreat 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.
ReplyDeleteIs 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 ?
ReplyDeleteEfficiently 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
ReplyDeleteI 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
ReplyDeleteLiên hệ Aivivu, đặt vé máy bay tham khảo
ReplyDeletevé máy bay đi Mỹ bao nhiêu tiền
chuyến bay từ mỹ về việt nam tháng 1/2021
bay từ đức về việt nam mấy tiếng
giá vé máy bay từ nga về việt nam
lịch bay từ anh về việt nam hôm nay
chuyến bay từ paris về hà nội
khách sạn cách ly ở sài gòn
Useful
ReplyDelete