SSIS data transforamtion
I am importing excel file tables into SQL Server using SSIS. While
importing i need to change the data of particular column. When and how it
can be achieved?
Eg: My Excel contains a column "Country" with values like "India", "United
States", "Russia". However When transfering the data to SQL server, I want
it to be stored as "IND", "USA", "RU"
No comments:
Post a Comment