I am trying to import some data from excel file by changing some column names and adding some columns through DTS package. I have mapped all the transformations and it looks fine. But when i execute the package it gives an error "No value given for one or more required parameters." Can anybody tell me where i am mistaken....
Just follow steps for error:
-->create an excel file : Test with ABC,pqr column headings.
-->Import this to MS SQL and save the dts.
-->Add a column "xyz" to the sql table Test.
-->Now edit the dts transformation source tab sql query >> select `ABC`,`pqr`,`xyz` as 'null' from `Sheet1$`
You will find that Parse Query Would work. But when you click on preview. It will raise the error "No value given for one or more required parameters."