Error while creating excel file on server where excel is not installed

hi experts,
my package works on local machine but doesnt work when I move to a server...
I get error at the execute sql task where I have the connection manager as "Excel" and I create an excel file with a tab and some headers, I have tried a solution that was suggested online to change the package properties to 64bit as false, I have tried that but it doesnt work either, please help:
[Execute SQL Task] Error: Failed to acquire connection "Create_genericExcel". Connection may not be configured correctly or you may not have the right permissions on this connection.
sqlcuriousAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kevin CrossChief Technology OfficerCommented:
sqlcurious, what are the values set behind the [Execute SQL Task] and what exactly is the SQL statement trying to do. As the error message implies, your local SQL instance may have certain features enabled that the server does not. In addition, locally you are executing as a sysadmin most likely whereas that may not be the case on the server. Further, if this is writing out a file to a path that does not exist or the server does not have permissions to via the account running SSIS then you may be getting the permissions error for valid reason.
0
Reza RadConsultant, TrainerCommented:
what is your connection type? Excel or OLE DB?
try with OLE DB also and let us know the result
0
sqlcuriousAuthor Commented:
Hi Reza_rad the connection type is excel and I tried OLEDB, it works fine.
Hi MWVisa1 the execute sql task creates a excel file with a tab name and headers, thanks. And all the assumptions that you had regarding the errors is not true.
Thanks!
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Reza RadConsultant, TrainerCommented:
Hi Reza_rad the connection type is excel and I tried OLEDB, it works fine.
so this means that your problem solved by OLEDB connection?

0
sqlcuriousAuthor Commented:
No my problem is not solved, I will still need to create an excel file using execute sql task and excel as the connection
thanks
0
jogosCommented:
May want to read this:
"For example, the Microsoft OLE DB Provider for Jet, which connects to Access databases and Excel spreadsheets, is not available in a 64-bit version. "
http://msdn.microsoft.com/en-us/library/ms141766.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sqlcuriousAuthor Commented:
thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.