Microsoft SQL Server Hosting : Error while importing excel file

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by mayurgogia 0n 24 November 2008

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

Learn more Microsoft SQL Server databases here. Should you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting