April 9, 2003 at 12:38 pm
In my DTS package, I create a "Transform Data Task" to transfer data from an Excel file to a SQL Server database. Then I try to preview the data from the task properties screen and I got the following error:
Error Source: Microsoft JET Database Engine
Error Description: No value given for one of more required parameters.
And the reason for this error is that there are 4 parameters automatically created when my SQL query looks like :
SELECT F3, F4, F5, F6
FROM [sim_GDP$]
WHERE (F3 IS NOT NULL)
AND (F4 IS NOT NULL) AND (F5 IS NOT NULL)
If change my query to :
SELECT *
FROM [sim_GDP$]
There are no such a problem, there are no parameters are created and I can see the values in F3 - F6. Anybody knows what causes this?
April 9, 2003 at 12:55 pm
I think that the F3, F4, etc are column names assigned when there are no specific column names in the Excel spreadsheet. Have you tried giving your spreadsheet columns names and then referencing these names in the query? Also, if there is any formatting in any columns other than the ones that have data, the process will try to assign generic (F7, F8, etc) names for those columns and import them as well. This could cause those columns to be picked up as variables or parameters since they would not be listed in your query as well.
Just my guess...
hth,
Michael
Michael Weiss
Michael Weiss
April 9, 2003 at 1:25 pm
Thank you, Michael. The truth is that when my query select 1 column, there is one parameter created, if select 2 columns, 2 parameters created. So I don't think the parameters are created for other columns than those I specify in the query. Using the column name does not help to solve this problem either.
any more idea?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply