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 |
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2013-03-07 : 19:55:07
|
Hi,I'm using 2008 R2 and Excel 2010.I want to export some rows to an Excel sheet. I could use an SSIS package but I wanted to do it all within a job if possible.When I run my query, which outputs the resultset to an Excel worksheet, I get this error:OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.Any ideas?Thanks, Jack |
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-03-07 : 20:15:44
|
Use SSIS and execute that via SQL Agent Job. |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2013-03-07 : 21:21:09
|
Well, I may have to use SSIS. But I would like to know if there is a solution to the error message.Thanks for your reply, Russell. Jack |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-03-08 : 11:44:07
|
We'd have to see your query, but the error message is pretty clear.When you said you don't want to use SSIS because you want this in a job I assumed you didn't know you that you CAN use it in a job...in fact that's the most common way SSIS is used. |
|
|
|
|
|