Cant open dtsx project when the data source is Excel

Question

hi All,

i have problem opening my dtsx file.
it returns error like:

TITLE: SQL Server Import and Export Wizard
------------------------------

An error occurred which the SQL Server Integration Services Wizard was not prepared to handle.

------------------------------
ADDITIONAL INFORMATION:

Exception has been thrown by the target of an invocation. (mscorlib)

------------------------------

The connection type "EXCEL" specified for connection manager "{AD831AF9-657F-4509-981E-EE593FDFA421}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
 ({004CD349-A469-43E7-AE5E-CDA5629AEBFB})

------------------------------

The connection type "EXCEL" specified for connection manager "{AD831AF9-657F-4509-981E-EE593FDFA421}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
 ({004CD349-A469-43E7-AE5E-CDA5629AEBFB})

everything was working fine a week ago, when i try to open it again this mornging for modification, everything isnt good.

any idea what should i do?

thanks!!!

---

AddinGanteng

Answer 1

Check for following :

Hope your package is not saved as DontSaveSensitive property in Protection Level ..
open in dtsproj project in notepad and check the connection manager setting as to what connection manager that is given still exists or not ...
might be that what credentails u have given int he connection manager for that database does no longer exist..might be that one of ur tasks is disbabled and but it still references a connection manager that to longer exists..
hope this helps....

Answer 2

Hi,
As you mention that the same package was working fine but suddenly it's failing....

Q1:  Are you able to open other packages or can create new packages?

If not then some dll is missing. please try after reinstall the SSIS.

Thanks-

---

Let us TRY this | Don’t forget to mark the post(s) that answered your question

Answer 3

hi dibmas n ETL...

thanks for replying.

everything working fine a week ago. no error whatsoever.

this is my first package of SSIS =) i'm quite new with this.

i can't open this package, and i can't create new package when i set an Excel files as the data source.

---

AddinGanteng

Answer 4

Are you trying to open this package on a 64 bit computer in BIDS, then there might be validation error as Micorsoft JET driver is not avaialable with 64 bit. On the SSIS project properties try changing the 64 bit run time to true and see whether you get any errors.

Note: The option of 64 bit run time true will work only during design time not at run time.

---

Regards, Raju

Answer 5

No, its 32 bit, run on 32 bit server

---

AddinGanteng

Answer 6

Hi,

Is there any login credentials changed? Is the excel sheet is password protected? Check it.

Thanks,

---

SatBI

Answer 7

no, nothing changed... everything was fine... its just i keep getting the error.. something like the Excel driver has gone.

---

AddinGanteng

Answer 8

Perhaps the Excel driver is gone.  Do you have the driver and/or Office installed on that server?  Could it have been removed?

---

Answer 9

hi thanks,

sorry it took so long to reply.

yes, the driver or ms.office is installed.
btw, i have this problem on my laptop.. a 32bit.

i don't know whether i've removed it or not. long as i remember, i've done nothing with ms.office :) just regular stuffs, no modifications.

---

AddinGanteng

Answer 10

Hi,
Better you re-install ms office on your laptop.

Thanks-

---

Let us TRY this | Don’t forget to mark the post(s) that answered your question

Answer 11

already re-install ms office. still the same error..

:(

---

AddinGanteng

Answer 12

create a new package with excel as destination or source connection and build the package and see its giving any error or not.. let us know the output of it.

---

Please mark the post as answered to help others to choose the best. chandra sekhar pathivada | www.calsql.com (SQL Server Community Website)

Answer 13

its 32-bit

creaated new package.. trying to point to Excel as the source...
ding... it's the same errors shows up...

TITLE: SQL Server Import and Export Wizard
------------------------------

An error occurred which the SQL Server Integration Services Wizard was not prepared to handle.

------------------------------
ADDITIONAL INFORMATION:

Exception has been thrown by the target of an invocation. (mscorlib)

------------------------------

The connection type "EXCEL" specified for connection manager "{AD831AF9-657F-4509-981E-EE593FDFA421}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
 ({004CD349-A469-43E7-AE5E-CDA5629AEBFB})

------------------------------

The connection type "EXCEL" specified for connection manager "{AD831AF9-657F-4509-981E-EE593FDFA421}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
 ({004CD349-A469-43E7-AE5E-CDA5629AEBFB})


does reinstalling BI will do?
hmmmhhh

---

AddinGanteng

Answer 14

Hi,
I think you are missing some dll. please try to re-install the BI.

let us know your observation.

Thanks-

---

Let us TRY this | Don’t forget to mark the post(s) that answered your question

Answer 15

reinstall BI, same error still occurred. when i open existing *.dtsx

i got this error message when i create new project and trying to add new Data Flow task:

TITLE: Microsoft Visual Studio
------------------------------

Registration information about the Data Flow task could not be retrieved. Confirm that this task is installed properly on the computer.

------------------------------
ADDITIONAL INFORMATION:

TaskHost "{C3BF9DC1-4715-4694-936F-D3CFDA9E42C5}"' is not installed correctly on this computer. (Microsoft.DataTransformationServices.Design)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=TaskHostNotInstalled&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


pfiiuuuhh...

---

AddinGanteng

Answer 16

--> install the latest service pack ( if your OS is windows vista then install the http://www.microsoft.com/downloads/details.aspx?FamilyID=90E2942D-3AD1-4873-A2EE-4ACC0AACE5B6&displaylang=en)

---

Please mark the post as answered to help others to choose the best. chandra sekhar pathivada | www.calsql.com (SQL Server Community Website)

Answer 17

try to generate a csv file first instead of Excel and let us know the result.

---

Please mark the post as answered to help others to choose the best. chandra sekhar pathivada | www.calsql.com (SQL Server Community Website)

Answer 18

the same error message... EXCEL Connection Manager stuff..

btw, why does the drivers in my ODBC Manager window, on the Drivers tab.. the drivers are written in italy.
for the first driver it says:
Driver da Microsoft para arquivos texto (*.txt, *.csv)

and the rest are written on italian language. is this the thing that make my SSIS won't work?

or should i reinstall OS? for last resort maybe... :(

---

AddinGanteng

Answer 19

first you need to figure out that whether the problem is with Excel Driver only or with the SSIS installation.

generate text file instead of excel using the text file connection , if it fails then you have to look into the installation of BIDS

---

Please mark the post as answered to help others to choose the best. chandra sekhar pathivada | www.calsql.com (SQL Server Community Website)

Answer 20

hi,

thanks Chandra for your replies...

on MSStudio i could import/export to another file except Excel. it always generates error.

on SSIS, i can't add data flow to new projects, this means, i can't start off anything. i can't test whether its the excel driver or the SSIS installation.
on SSIS, i can't open existing projects which usually working fine before this problem arise.

does microsoft aware of this error? i've been googling, none of the solution i found works. some people end up reinstalling OS.

---

AddinGanteng

Answer 21

hi dibmas n ETL...

thanks for replying.

everything working fine a week ago. no error whatsoever.

this is my first package of SSIS =) i'm quite new with this.

i can't open this package, and i can't create new package when i set an Excel files as the data source.

---

AddinGanteng

Proposed as answer by mistake, please unmark.

---

Raju

Answer 22

did you install the latest service pack and fixes for your excel version?

---

Duane Douglas, MCAD, MCITP | http://www.ssisbi.com | Please mark the post(s) that answered your question.

Answer 23

Hi,

I'm installing SQL Server 2005 on Windows XP SP2.
I'm applying SP2 on SQL Server 2005

I got MS Office 2007 installed.
i received updates from Microsoft once a month.

but still, the problems occured.

i was installing Office 2003 (Excel only), as my application (using cube) only works with MS Office 2003 OWC. already uninstalled MS Office 2003, but the problem still there.

should i really have to reinstall Windows?

---

AddinGanteng

Answer 24

do the following steps and let me know the results inline

1. create a new project in SSIS with text file as destination
2. if above step is working fine then replace the text file connection with excel destination
3. if above step is not working then send the screen shot of the error or error message.

---

Please mark the post as answered to help others to choose the best. chandra sekhar pathivada | www.calsql.com (SQL Server Community Website)

Answer 25

It sounds like your installation has become corrupted.  You should contact Microsoft Customer Support.

---

This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 26

Yes, might be calling them is a good idea..

i've reinstall Windows, and everything works fine -_-'

thanks all for ur helps!

---

AddinGanteng