SQL 2008 SSIS to Excel 2007: Cannot connect

Windows Server 2008 R2
SQL 2008
Excel 2007

I finally got a package created that would get past the 64 bit non support of Excel.  I had to use the wizard, but now the data set from my query is being written into my Excel spreadsheet perfectly.  I've tested it 3 or 4 times.  Good results every time.

Now, I create a job and call the SSIS package and start getting that error again:

Description: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is
available.

What's going on?
DavidLumpkinAsked:
Who is Participating?
 
LIONKINGConnect With a Mentor Commented:
Did you check the "Use 32-bit runtime" checkbox in the advanced configuration of your job?
0
 
DavidLumpkinAuthor Commented:
I certainly appreciate the response.  I've looked every where and do not find a place to set this on the job.  I have googled for advance configuration for jobs and haven't found anything.  I'm sure I'm just missing it.
0
 
DavidLumpkinAuthor Commented:
Found it!! Thank you, thank you.
0
 
LIONKINGCommented:
Glad it helped...
0
All Courses

From novice to tech pro — start learning today.