.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Cant open dtsx project when the data source is Excel

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :Sql Server
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

View Complete Post

More Related Resource Links

Merge SQL to Excel--Need .Net button to open on fly and have current SQL data!


           Hello all,
I do not know if this is the proper place to ask this, but my question is...
I have a SQL DB and I want to convert it to Excel Sheet (I did this using the wizard)!
In my aspx page I have a button.  So when I press this button I want the Excel sheet to open!  But I need the Excel sheet to show me the up to date information that is in the SQL DB.  

Best Practices for extending an Open Source project

I am beginning an implementation and customization of an open source e-commerce application (nopCommerce).  I'm looking for any for any suggestions and / or recommendations to annotate or document any source code changes I would make in order to allow for the easiest integration of new versions of the application that are released. I do have TFS 2010 implemented but I do not have much experience with the product.  I tried to merge the source of a new release but ran into some difficulty, especially when files were deleted from the project. For much of the project I can copy existing user controls and create custom versions for my use, but there will be some modification of the actual source code required. Anyone have any suggestions? Thanks in advance.  

Excel Data Source SSIS AcquireConnection failed 0x80004005 unspecified error

Nuances of using Excel data sources with SSIS Your Development Machine Setup Needs Jet Drivers, available along with the default Office install so if you have Excel working fine locally, this is enough. Installing the "Office Data Connectivity Components" (download file name AccessDatabaseEngine.exe) as well as having Office installed corrupts the Jet Driver stack so that SSIS in VS 2008 cannot create the object to read the XLS file. You will see the title error "Unspecified Error" and "80004005" code. Resolution: Uninstall the Jet Engine pack on your development XP machine if you have Office. It will be listed as something like "Microsoft Access Database Engine (2010)". Run Office 200x setup with the Repair option and reboot. Try configuring the task in SSIS and it should be able to read the Sheet names again and columns.  Live Server (32-bit and 64-bit) Deploying your SSIS package to a server without Office 200x means it will not have the Jet Engine drivers to read XLS, XLSX files. You must install the 32-bit Office Data Connectivity Components - Jet Drivers mentioned above found here  (http://www.microsoft.com/downloads/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en). There are no 64-bit drivers; therefore regardless of 32 or 64-bit live environments, this step is the same. You shoul

Microsoft Excel and Sharepoint KPI's (External Data Source)

This is my first post i hope i get a clear answer for my question. I recenty have been working on KPI's drawn from Microsoft Excel documents that i created. However, as we know, external data sources in excel don't work with sharepoint. If that was possible it would have saved the company a lot of time and effort My questions are: Is there any way to have external data sources with some advanced modifications, or any other way that would simulate this process? (External data update) Can i directly update my data by tampering the database where the excel file is saved?   I don't know if the files uploaded in sharepoint are stored in a database, so i want some validation around this. (Name of the database, path etc.)   Hope you can shed some light to my questions Thanks in advance Theo

betfair open source project


Anyone know of any open source project or low cost source code in asp.net to a web application similar to betfair

Data Source Library won't open / grayed out


I saw a similar question but the answers didn't solve my problem so here it goes.  I have a site, and many subsites underneath.  For all of them it says I'm owner/full control.  They even gave me control of the site above mine so I could have permission to do a lot of things on my sites.  Ok well every site works the same.  I open them in SharePoint Designer and can insert data view and see the data sources under the "current site".

However, this one site i have says "current site" in the data source library tab, but it is grayed out and I can't expand it.  My IT contact has no idea what's wrong since I have full permission to all these sites.  I can add webparts through sharepoint designer to this site, I just can't add data views (and I really need data views for what I'm doing).

This is a site that's been around for a bit but this is the first time I started using it to insert data views.  Unfortunately it's a live site so I can't just delete/recreate as other things on the site are currently in use and going through workflows.  

Any suggestions are appreciated!  Where can I look?  What should I check? 

Thanks so much!

Initialization of the data source failed in Excel 2007 from As 2008R2


Environment: Win server 2003 , Office2007, SQL Server2003, PowerPivot for Excel

All the user do have access to connect the cube. am the admin user and i get the same error message.

"Initialization of the data source failed. Check the database or contact your database administrator. Make sure the external database is avaliable, and then try to operation again.

I have tried deleteing the data source and creating a new one.

Can any one help with this there are other fourms on this but i can't see a answer for it.


SSIS excel data source numeric values returned as null

Hello everyone, long time no see!, I have a problem and was hoping someone can help me:
I'm using SSIS 2005 Enterprise edition,  I'm creating a package that reads an excel (xls) file using the "excel source" component, and it dumps the data into an OLEDB destination (a sql server).
When I drag the excel source component and create the excel connection to my file the component automatically reads the columns and their datatypes.

The problem is that I have a column which has numeric data and the package uploads as NULL every number that starts with a zero. (note: in excel this column is formatted as "text", despite it has only numbers, because it's the only way excel maintains the left sided zeros).
So I checked the data types by right clicking the excel source component -> show advanced editor and my surprise is that this column's data type is detected as double-precision float, and it doesn't let me change it.

I tried the answer posted here: http://devselekta.blogspot.com/2007/09/ssis-excel-data-source-values-returned.html but it only works when the first row of data has a number beginning with zero on this column.
Someone knows how to get the data imported correctly? Thanks in advance.

CLASS Not Registered - Excel 2007 Data Source (Not 64 Bit machine)


First off, I am not running on a 64 bit machine.

I keep getting the following error when I try to run a task that has an ODBC connection to an xlsx file on a SQL Server 2005 server using SQL Server Agent.

Executed as user: ACCT02\ssc_emr_ra. ... 9.00.4035.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  7:29:39 AM  Error: 2010-10-28 07:29:42.63     Code: 0xC0202009     Source: RFC_Data_Load Connection manager "Excel ODBC Connection"     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040154.  An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  Hresult: 0x80040154  Description: "Class not registered".  End Error  Error: 2010-10-28 07:29:42.63     Code: 0xC020801C     Source: Data Flow Task OLE DB Source [3052]     Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Excel ODBC Connection" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method c

Cannot refresh OLAP-based data in Excel Services workbook in browser (SP 2010 / Project Server 2010)



In SharePoint 2010, Project Server 2010, Business Intelligence Center, upon attempting to refresh OLAP data in an Excel chart in the browser, the following error appears:

An error occurred during an attempt to establish a connection to the external data source.  The following connections failed to refresh:

My ODC Connection Name

We have loaded and configured Project Server 2010 according to spec (http://technet.microsoft.com/en-us/library/ee662109.aspx).  Excel Services is configured according to spec (global settings, trusted file locations, trusted data providers and trusted data connection libraries).  The Secure Store Service is configured with the ProjectServerApplication target application. 

Non-OLAP data refreshes of spreadsheet data work fine in the browser.  OLAP data refreshes in the Excel client itself work fine.  Only the OLAP refreshes in the browser fail.  The problem occurs whether using a Microsoft ODC or one that we created (saved in a trusted location).

The ULS log has only one error, which is:

06/21/2010 13:47:17.86  w3wp.exe (0x1238)               &

Excel services external data source connection


can't connect to an excel services data source on the sharepoint 2010

Error : ... can't connect to external datra source .....

Excel Services establish a connection to the external data source


Hello All,

I am getting below error when I click Slicer in excel 2010 powerpivot chart.

An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh:

PowerPivot Data

I am using SQL Analysis services cube to fetch data into my powerpivot using windows authentication mode.

Appriciate any help.




SSRS reports using Excel work book as the data source


HI All,

I have to create the Dashboard for which the the source data is in Excel work books .WE do not want to buy the license for Excel services . I was trying using SSRS integrating with share point .When i was creating reports using source as Excel works by creating DSN for the ODBC connection I was getting the following error

I wrote  the the following query to get the report from Excel work book

select * from [Activity $] where Activity is my work sheet name

An errrror Occured while executingthe quesry

ERROR[42000] [Microsoft] [ODBC Excel Driver ]Invalid Bracketing of name 'Activity $'


Moderator Note: NEVER ask for quick; asap help or say your question is urgent. Wait your turn.

Data Mining Project in BIDS: Why cant data source views be based on a query?

I've created an analysis services project in BIDS with the intention of creating a mining strucuture. I notice that you cannot create a data source view based on a query and that it must be based on linking actual tables (via the access looking GUI).  In my scenario I have a very long and complicated query which uses temp tables to retreive the data I want to use for mining.   Am I forced to insert this data into a table in order to create and use a mining structure?  Or are there other ways to do it?

'Add project data source' database location?


Hey guys,

So I'm having trouble browsing for my databases in the Data Source Connection Wizard in Visual C#.

Just so you know where I'm at, here are the steps I've taken so far.

-> I click on my datagridview DataSource property and choose 'add project data source'.

-> 'Choose Data Source Type' -> database -> next

-> 'Choose Database Model' -> dataset -> next

-> 'Choose Your Data Connection' -> New Connection

Now I'm required to browse or type in my database string in the connection properties section and I don't know where my databases are stored.

Basically, what I'm trying to achieve is find the default location of where my sql server databases are stored on my hard drive so I can link them to my program.

Following my steps previously described I then press the 'browse' button and the FileDialog comes up directed at "C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Samples" which is where I find the northwind database.

I wish to locate a database I've created in sqlserver 2008, but cannot locate the database files anywhere on my hard drive.

I am able to achieve a connection through use of 'using System.Data.SQLClient' and creating a connection string, but would like to have to database as a datasource so I can work

display data into GridView from excel sheet

I have to display data from excel sheet into my gridview and also I need to figure out a way to store data into excel files from my web page. I am using C# 3.5, VS 2008.

Creating an Excel Spreadsheet and Adding Data to It Programmatically

The Interoperability services make it veryeasy to work with COM Capable Applications such as Word and Excel. Thisarticle reveals using Excel from a managed application. Excel is thespreadsheet component of Microsoft Office 2000. The majority of Excelprogrammatic functionality is exposed through Automation via the typelibrary Excel9.olb. The intention of this article is to express that amanaged application can interrelate with Excel as a COM server.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend