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

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

SSIS 2008 generates Class not registered

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
I am getting the following error in SQL Server 2008 R2 (build 10.50.1734) x86 platform BI Development Studio (BIDS) 9.0.30729.4462 with .NET Framework 3.5 SP1 in a Integration Services project Data Source View table when I attempt to Explore Data: Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)) This happens on a Windows 7 Professional workstation x86 platform, (but has not been observed on Windows XP). The error occurs on Data Source Views bound to a Data Source connected to a SQL Server 2005 SP3 (build 9.0.4053) and SQL Server 2008 R2 server (I'm sure it's not a server issue, but a workstation issue). I have successfully unregistered and re-registered DTS.DLL and DTSComm.DLL in the registry, with no resolution to the issue. Does anyone have any ideas? Thanks.Greg

View Complete Post

More Related Resource Links

SSIS 2008 generates Registration information for this application needs to be updated - VSTA.exe

I am getting the following error in SQL Server 2008 R2 (build 10.50.1734) x86 platform BI Development Studio (BIDS) 9.0.30729.4462 with .NET Framework 3.5 SP1 in a Integration Services project. I have a package with a Data Flow task that contains a Script Component. I edit it and attempt to edit script and I get the following error: Registration information for this application needs to be updated. To update, log on as an administrator and run this command: C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\VSTA.exe /HostID SSIS_ScriptComponent /setup About a minute later, another box displays with the following message Cannot show Visual Studio Tools for Applications editor. Additional information: The VSTA designer failed to load. “System.Runtime.InteropServices.COMExeption (0x80004005) Error HRESULT E_FAIL has been returned from a call to a COM component at VSTADTAProvider.Interop.VSTADTEProiderClass.GetDTE(String bysHostID, Uint32 dwTimeout). I execute the command above running as an administrator (there are no output results). BIDS displays the same symptoms. This happens on a Windows 7 Enterprise (I said Professional in an earlier but un-related post) workstation x86 platform. I get the error even if I create a new script component in a new data flow task in a new package. I also have VS 2010 Premium Edition (build 10.0.30319.1 RTMRel) i

Using Conditional Split data Transfer in SSIS 2008

This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.

VS 2008 IDE does not see the AsyncPostBackTrigger class


I am trying to work with the AJAX AsyncPostBackTrigger class in the System.Web.Extensions 3.5assembly. I am in VS 2008 and the project is targeted for .NET 3.5.

In the IDE, the source for Default.asp, I am getting a warning (wavy green line) for the <Triggers> tag and the <asp:AsyncPostBackTrigger> tag. The cue for the Triggers tag is "XHTML 1.0 Transitional - element triggers is not supported".

for the other tag it is saying it is not a known element. Intellisense doesn't even list the <asp:AsyncPostBackTrigger>

Anybody have any suggestions what I may be missing? The System.Web.Extensions v 3.5 is listed in the Web.Config file and is in the project references.


Issues with SSIS and SQL 2008 - Integration services not running

Hey guys, I installed SQL 2008 with complete BI studio including Integration Services. When i check in my services - i cant see my integraiton services in there When i try to connect to Integration Service using localhost, I cant connect it And when i try to run setup of SQL 2008 - It shows that Integration Services already installed and that what i checked when i fetched my Installation tool report from SQL Server to verify i have it installed. Why can i access Integration services, if i already have it, Please suggest with ideas, checks i can make to ensure every setting is in place. Thanks. Would appreciate for quick response.  

Output parameters in OLEDB Command component - SSIS 2008

I have a package that I developed in SSIS 2005 and recently ported to 2008. Everything runs great except an OLE DB Command component that calls a stored procedure that uses output parameters. When I try to run this, I get this error: Error: 0xC0202009 at Data Flow Task, OLE DB Command [100]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Syntax error, permission violation, or other nonspecific error". Error: 0xC004701A at Data Flow Task, SSIS.Pipeline: component "OLE DB Command" (100) failed the pre-execute phase and returned error code 0xC0202009. When I do the same thing in SSIS2005, it works fine. So I setup a new package with 1 data flow. In that data flow, I added a source component, an OLE DB Command, and a destination.  I then tested this with a stored procedure that took no parameters. It worked fine. I then tested it with a stored procedure with 1 parameter defined as OUTPUT. This generated the error.   Is there an issue with output parameters in an OLE DB Command in SSIS 2008?   Thanks!http://bobp1339.blogspot.com

Post Upgade task, Upgrading SSIS Pacakges to SQL Server 2008.

Hi, I am trying to upgrade sql 2005 packages to sql 2008 after doing in-place upgrade of DE and SSIS. Can I know what packageformat column in msdb.dbo.sysssispackages refer to, as according to http://msdn.microsoft.com/en-us/library/cc879336.aspx the value should be 2 if the package is in sql 2005 and it should be 3 if it is upgraded. But I am seeing only 0 or 1.   Can I know any other method to figure out version of the ssis packages? I am having issues upgrading SSIS Packages from 2005 to 2008, using SSIS package upgrade wizard.   Thanks for your help. Regards, KRanp.

ssis sql 2000 image to 2008 varbinary Failed to retrieve long data for column

Hi, I have a task that to migrate the image type column from sql 2000 to varbinary type in sql 2008. The source column having 3812353 max datalength size for the column. The package always failed with following error message. [OLE DB Source [13177]] Error: Failed to retrieve long data for column "attch_file_content_t". [OLE DB Source [13177]] Error: There was an error with output column "attch_file_content_t" (13209) on output "OLE DB Source Output" (13187). The column status returned was: "DBSTATUS_UNAVAILABLE". [OLE DB Source [13177]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "output column "attch_file_content_t" (13209)" failed because error code 0xC0209071 occurred, and the error row disposition on "output column "attch_file_content_t" (13209)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. Meng Chew

Diffrences in SSIS 2005 and SSIS 2008?

Hi All,   How to convince interviewer in  major differences in ssis 2005 and ssis 2008.In my system I have ssis 2008.Can I install ssis 2005? How to install? Thanks CMK…

Deployment bug: Class not registered

I deployed my web app from my development machine (WinXP Pro) to the production server (Windows 2003).  Everything works except for a COM library I am referencing from my business object.  The references in my solution are: Web Project --->  Business Layer Project (DLL)  ---> COM Library I suspect part of my problem is I didn't properly deploy, I just grabbed everything under \wwwroot\MyWebApp and copied it to the server.  I'm going to be researching proper deployment strategies, but in the meantime maybe someone could give me suggestions.  In my error log, the exception source is "Interop.AccpacCOMAPI", and the message is "Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))" and the stack trace is as follows: at AccpacCOMAPI.AccpacSessionClass.Init(String ObjectHandle, String AppID, String ProgramName, String AppVersion) at WSTimesheets.AccPacWrapper.GetAccPacEmployeeList(Guid AppUserID) in C:\Documents and Settings\Joe\My Documents\Visual Studio 2005\Projects\WellServe\BusLogic\WSTimesheets\AccPacWrapper.cs:line 239 Here is a snippet of the code:1 // Open a session to AccPac 2 bool sessionOpened = false; 3 bool linkOpened = false; 4 AccpacCOMAPI.AccpacSession accpacSession = null; 5 AccpacCOMAPI.AccpacDBLink dbLinkRead = null; 6

Deactivate WPF commands globally (class registered)

Hello everyone, I need to deactivate the default WPF commands in a globally way, i'm talking about those that are registered as "class commands". Here's the reason : We are upgrading an old application to WPF, that application uses some key shortcuts that overlap with default wpf commands. I know that that should be a problem as commands attached to an instance have more "priority" than those that are attached to the "type" or "class". The problem is, we cannot attach the input binding (notacommand to disable the shortcut) to every instance. It will be, either overkill (modify all the styles) or almost impossible (controls instantiated by third party controls).   So, is there a way to disable wpf "class attached" commands in a globally way ? Thank you.

ssis 2008 Loading MULTIPLE EXCEL file

HI it is possible for me to load multiple text file using for each loop,but if i try the same process for EXCEL file then my excel source throws an error. Also when i created my variable in value  i have given the path of my excel file ,still it didnt help me..because the moment i map the variable with the connection string of source excel connnection(property->expression->connection string) it start giving error if you could help me or provide some reference it will be of great help http://bi-polar23.blogspot.com/2007/08/loading-multiple-excel-files-with-ssis.html i tried this link but got stuck with it on step 12 and 14 (below  is my connection string) and variable is @Filename which i have created Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\mushtaq.sheikh\Desktop\ForEach\New Microsoft Excel Worksheet1.xlsx;Extended Properties="Excel 12.0;HDR=YES"; The moment i try to edit my connection string by comparing connection string provided in link it gives error(an OLEBD error has occured with error code 0x80040E73) on excel source Thanks in advance

How to create a SSIS package to import records form SQl Server 2008 tables to text files

I am a newbie to SSIS and would like to create a package to accomplish the task referenced in the above title. Will appreciate any links and pointers in the right direction.   Thanksakoranteng

Problem with Merge Join and condition splt trasnformations in SSIS 2008

  Hey, While working SSIS in 2008 we have encountering some weird problems with Merge, Merge Join and Condition Spilt transformations, here are the details... Condition Split and Merge Join and Condition Split: Please check the below diagram(not really just tried) for the complete details. Just FYI data is in sorted order   condition Split -> 420000      | 18                                                          | 419982  Merge Join(left)  -- src1(6000)      |10  Condition Split      |9     |1   the merge join transformation is not returning the complete 18 rows to the next transformation that's why we are missing 8 rows. But if we adds a sort transformation (getting warning as data is already sorted) before merge then complete 18 rows were passing to the condition split. Also tried modifing the source query just to return 18 rows then also it was passing the 18 rows to next trasnformation except with full load.       Merge: We have two sorted data sources and first one has 40000 records and second source have 12000 records and after the Merge transformation we have Condition Split transfor

SQL Server 2008 Script Componant Error - [SSIS.Pipeline] Error: component "Script Comp Name" (48) fa

Hi All,   I am facing one strange issue in SSIS 2008. I have developed one SSIS package which is importing excel data into SQL Server 2008. This Package contains some Scirpt componants. This package is working fine on Windows XP machine but when I am trying to run on Windows 2003 server it gives me error "[SSIS.Pipeline] Error: component "SCR RDSTableRelation" (48) failed the post-execute phase and returned error code 0x80004002". Surprising thing is that if on windows server 2003server  if I drag a new script componat and paste the previous script code itself then it works fine. Even if I copy-paste the existing script componant and give source-destination connectino to this new script componant then also it works.

Database diagram failur - Invalid class string SSMS 2008

Hi There -  Help needed In SSMS 2008 (not express) the Database Diagram  cast the exeption "Invalid Class String" (MS Visual Database Tools). Why is this happening. I have used the diagram designer before succesfully My OS W7 - SqlServer 2008 - every thing updated  - every service pack installed I have tryed reinstall seceral times - not positiv What is going on - It had been working (1 month ago) Please help Freddy

SSIS 2005 & 2008 BIDS and VS2005/2008 Will VS2010 work with either SSIS package?

I've read the old posts about having to have the BIDS version match the SSIS package version. My question is with VS2010 is there any change? Can I edit either of the old versions of SSIS packages in VS2010 or do I have to have 3 versions of Visual Studio/BIDS on my machine? TIA J

Error on VS 2008 Class Library project: are you missing an assembly reference?)

http://msdn.microsoft.com/en-us/library/bb153523(office.12).aspx Working with ASP.NET 2.0 Web Parts and Windows SharePoint Services 3.0 Based on the above MSDN Walkthrough, I created a Class Library VS 2008 project. When clicking the Build menu, 11 errors on System.Web.Security etc popped up.  What's wrong? *********************************************** using   System; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; Error 1 The type or namespace name 'Security' does not exist in the namespace 'System.Web' (are you missing an assembly reference?) Error 2 The type or namespace name 'UI' does not exist in the namespace 'System.Web' (are you missing an assembly reference?)
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