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..