Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sql to Excel detination

Status
Not open for further replies.
S1002

S1002

Programmer
Aug 28, 2007
14
US
Hi,
I created a SSIS package to export data from SQL query to Excel I had to do data conversion to get rid of the converion errors str to unicode datatypes.

I used OLDB detination with extended property as 8.0 because my excel destination is MicroSoft Excel 97-2000


Can anyone please help me fixing this error
[OLE DB Destination [55]] Error: The AcquireConnection method call to the connection manager "MicroSoft Excel 97-2000" failed with error code 0xC0202009.
 
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
CSV to SQL table with not allow null issue
Replies
3
Views
441
Cpreston
Cpreston
grnzbra
  • Locked
  • Question
SSIS in SQL Server 2022
Replies
4
Views
563
grnzbra
grnzbra
marydn
  • Locked
  • Question
Send Nicely Formatted SQL Query via Email
Replies
0
Views
453
marydn
marydn
minhtran360
  • Locked
  • Question
Where do I look for my SSIS pasckage that just being deployed to my sql server?
Replies
1
Views
1K
mark williams
mark williams
grnzbra
  • Locked
  • Question
Excel Import Maps 255 Char Max
Replies
0
Views
294
grnzbra
grnzbra

Part and Inventory Search

Sponsor

Back
Top