Hi,

  I ma using Import task to import excel data to SQL server, but in column mapping we have lot to changes in column name.we are using work group edition to import the data so i cant save the task as SSIS pckages also.

is it possible to script the task before running the task.

or any other possible way in sql to automate the above work..

Hi ,

  You can try having a look into getting the data from excel using Linked server as well. Refer to the below link for steps

  https://support.microsoft.com/en-us/kb/306397