i am having one excel sheet of Emp in which salary in text not i want to load this into SQL Server table with casting of Salary into Integer in sql server table , can any one please guide me how can i do this thanks in advance. Regards, Amitesh Srivastva

Try below stpes 1. Use Execl source 2. Right click on that, choose Show advance editor 3. Input and Output Properties 4. Output columns 5. choose the salary column 6. right side data type properties 7. change the data type to numeric Or Store the data into stage table from there you can use cast or convert function. update the data to final table /R.

Get the data from the excel surce as it is and use a derived column or data conversion component to convert it to integer.Nitesh Rai- Please mark the post as answered if it answers your question