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 |
|
sarahmfr
Posting Yak Master
214 Posts |
 Posted - 2012-01-06 : 12:06:42
|
| I have a ssis package the had dataflow excel is source I set the property debugging 64bit to false in the package property pageIt works fine from within ssisOn creating a schedule job to run the package on trying to run the jobI get the following error"DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS<c/> as no OLE DB provider is available"I went to the job step properties and in execution option I set use 32 bit run time. (I Checked that)But I still get the same errorPlease I need help.Thankssarah |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
sarahmfr
Posting Yak Master
214 Posts |
Posted - 2012-01-07 : 13:19:40
|
| Thanks a lot.But I can not use file format of ssis package due to security restrictions.I can use only sssis packages within sql.Thanks againsarah |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-08 : 02:43:25
|
| thats ok. the key is to use 32 bit version of DTExec. Read the article fully. all other options you can retain same value. just change the DTExec path to point to 32 bit------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
package not working in a job excel not support 64