Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
macsterling
Yak Posting Veteran
56 Posts |
 Posted - 2008-11-29 : 18:52:10
|
| I am getting an "Error 0xc002f210: Preparation SQL Task: executing the query "possible faliure reasons: Problems with the query, Result Set" property not set correctly,, parameters not set correctly, or connection not established correctly"Any ideas? the connection is established The generated query adds a $ at the end of the sourcename (Budgets$ - the source is the name of the worksheet -Budget) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-30 : 01:47:19
|
| How are you trying to export excel? using Data Flow Task? |
 |
|
|
macsterling
Yak Posting Veteran
56 Posts |
Posted - 2008-11-30 : 08:56:41
|
| I am using the wizard |
|
|
|
macsterling
Yak Posting Veteran
56 Posts |
Posted - 2008-11-30 : 08:57:42
|
| Actually I am importing using the SQL 2005 wizard |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-30 : 11:54:35
|
| which step does this error occur? |
|
|
|
macsterling
Yak Posting Veteran
56 Posts |
Posted - 2008-11-30 : 19:16:29
|
| the initializing steps workthe setting SQL command worksthe setting connections both workthe preparing for execute stopsthe pre-execute stopsthe executing gets the errorthe rest of the steps are stoppingI am importing a small test)spreadsheet that has one column of "gneral" data and 12 columns of currency. There are column headers (noted in the prep.) I tried changing the currency to numbers and took off the headers. It was built in office 2007 and saved as a 97 - 2000 spreadsheet. I even tried saving from another machine with 2003 and using that. I am using the import from SQL 2005 developers version. Everthing is on one machine. I have tried moving the spreadsheet around on the disk to see if there something was not working there. I also tried to connect the excel as a linked server and that failed also. (the "non specific" error) |
|
|
|
macsterling
Yak Posting Veteran
56 Posts |
Posted - 2008-11-30 : 20:23:38
|
| This i srelated to a CLSID error (80040154) I think have found in the web that it means that there is an unregistered DLL associated with the CLSID #. I have searched the registry very carefully and there is none with the number provided in the error message. This leads me to believe that it is looking for something that is not only unregistered, but not even there (to be unregistered). Is this associated with a web app. If so, what is the connection between a web app and SQL? |
|
|
|
macsterling
Yak Posting Veteran
56 Posts |
Posted - 2008-11-30 : 20:47:00
|
| I just imported the spreadsheet into an access db and tried to import that. I got the same error. It musty be something about the way SQL is set up.The full error message is:Error 0xc002f210: Preparation SQL Task: Executing the query "" failed with the following error: "retrieving the COM class factory for companant with CLSID {7816B----blah blah} failed due to the following error: 80040154.". Possible failure reasons: Problems with the query, "Result Set" properly not set correctly, parameters not set correctly, or connectioon not established correctly.As I was typing this I noticed that the name of the query is "" - as in nothing. Possibly the qyuery is not being dreated correctly, or at all. Any ideas how I can check? |
|
|
|
|
|
|
error when importing from excel