.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

Recordset Destination Component Error in SQL Agent

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :Sql Server

I am using the Recordset Destination Component to populate an Object Variable, and then using a For Each Component to loop over that Variable.  The package executes perfectly if I run it from within BIDS, however, when I execute as a Job Step within the SQL Server Agent, I get the following error:

Description: Component "component "Recordset Destination" (34)" could not be created and returned error code 0x80070005. Make sure that the component is registered correctly.  Code: 0xC0048021  Recordset Destination [34]     Description: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "Recordset Destination;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0"  Code: 0xC0047017

I have tried executing in the Job Step every way I can think of...as command line from file system, from within SQL Server, as 32-bit, 64-bit, Windows Auth, SQL Server Auth...

Any Ideas?



Microsoft Visual Studio 2005
Version 8.0.50727.42  (RTM.050727-4200)
Microsoft .NET Framework
Version 2.0.50727 SP1

Installed Edition: IDE Standard

View Complete Post

More Related Resource Links

Error Registering COM+ Component

Hi All,

I am experimenting with using EnterpriseServices. I created a component, created the SNK file, compiled the DLL. In the assemblyinfo.vb file, I added '<Assembly: AssemblyKeyFile("c:\key.snk")> '.
I created a new package in COM+, When I attempt to add the .dll to the package i get:

An error occured while processeing the last operation.
Error Code 80020009 - Exception ocurred.

The eventlog may contain additional troubleshooting information.

Here is the Event log:

Installation of 'TransactionalComponentsCore.dll' into '{6367F5F1-56A7-4223-97AC-51F7DC1D53EB}' failed with an exception:

System.EnterpriseServices.RegistrationException: Could not install type library 'TransactionalComponentsCore.tlb' into application 'TransactionalComponentsCore'.

Server stack trace:
at System.EnterpriseServices.RegistrationDriver.InstallTypeLibrary_W2K(ApplicationSpec spec)
at System.EnterpriseServices.RegistrationDriver.InstallTypeLibrary(ApplicationSpec spec)
at System.EnterpriseServices.RegistrationDriver.InstallAssembly(RegistrationConfig regConfig, Object obSync)
at System.EnterpriseServices.RegistrationHelperTx.InstallAssemblyFromConfig(RegistrationConfig& regConfig, Object sync)
at Sys

sql server agent - job schedule 22022 error


Hi ! I have scheduled a job in sql server 2008 to send birthday e-mails. I run the script and it looks wroking but in agent schedule it doesn't. I am getting the below error; what is the problem?

TITLE: Microsoft.SqlServer.Smo
Start failed for Job 'Sending_transferdb_birthdate_e-mails'. 
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1447.4+((KJ_RTM).100213-0103+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Start+Job&Link

Microsoft .NET Framework 2.0SP1 (CBS): [2] Error: Installation failed for component Microsoft .NET F

I downloaded the the .Net Framework 3.5 from Microsoft and I am trying to install the .Net Framework 3.5 in a clean Windows Vista Ultimate installation but it fails. The dd_dotnetfx35error file shows:   [03/08/08,19:05:35] Microsoft .NET Framework 2.0SP1 (CBS): [2] Error: Installation failed for component Microsoft .NET Framework 2.0SP1 (CBS). MSI returned error code 1[03/08/08,19:05:46] WapUI: [2] DepCheck indicates Microsoft .NET Framework 2.0SP1 (CBS) is not installed. Thank you for your help.

Error while executing a package through SQL Server Agent

Hi All,   I have a ssis package. It has 3 tasks, first task updates a record in Oracle database to set an Indicator to “Y”, second task process SSAS Cube and the third again updates the same record and sets the indicator to “N”. This package has 2 data sources, one is Oracle and the other is Analysis Services. I gave the credentials for the Oracle and use NT Authority for Analysis services.   When I am executing from BIDS package is executing successfully. But when I am calling the job to execute this package its throwing me the error. Below is the error.     Message Executed as user: User\Username. ...ion 9.00.4035.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  10:57:46 AM  Error: 2010-08-27 10:57:46.79     Code: 0xC0016016     Source:       Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.  End Error  Error: 2010-08-27 10:57:47.16     Code: 0xC0202009     Source: Ord_test Connection manager &q

Transactional Publication With Article Using DATE Datatype Causes Snapshot Agent to Fail with Error

So I am using SQL Server 2008 Enterprise Edition (64Bit) and have run into a strange problem that is baffling me. I have two tables that I need to replicate.  They are identical in specification except the name (one is for monthly stats and one daily stats) CREATE TABLE [dbo].[statsDailyLite]( [EntryDate] [date] NOT NULL, [SetID] [int] NOT NULL, [ProductID] [smallint] NOT NULL, [Hooks] [int] NOT NULL, [AdViews] [int] NOT NULL, [Clicks] [int] NOT NULL, [UAdViews] [int] NOT NULL, CONSTRAINT [PK_statsDailyLite] PRIMARY KEY CLUSTERED ( [EntryDate] ASC, [SetID] ASC, [ProductID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ) GO CREATE TABLE [dbo].[statsMonthlyLite]( [EntryMonth] [date] NOT NULL, [SetID] [int] NOT NULL, [ProductID] [smallint] NOT NULL, [Hooks] [int] NOT NULL, [AdViews] [int] NOT NULL, [Clicks] [int] NOT NULL, [UAdViews] [int] NOT NULL, CONSTRAINT [PK_statsMonthlyLite] PRIMARY KEY CLUSTERED ( [EntryMonth] ASC, [SetID] ASC, [ProductID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ) GO They both conatin a thousand or so test rows of data, and they are both in a transactional publication going to another SQL 2008 box. Now when the tables are empty

Error starting SQL Server Agent - Could not load the DLL xpstar90.dll. Reason: 126

AD Service account password was changed.  Now the SQL Server Agent (MSSQLSERVER) will not start even after updating the password.  Have no access into the databases.  Log files say "Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.)."  Service Account has Full rights on system.  Any help in solving the problem would be great.

error HRESULT E_FAIL has been returned from a call to a COM component

hello every one i see this error some times when i designed the page and close the program and came back.but this error do not stop debugging the page and hide all controls is my page and i cant use smart tag and see the controls.what should i do?

Error in Script component in the Data Flow Task

Hi, I need a small help. This is what i require. I need to generate a auto increment number using script component and assign it to target column. use db1 go create table src (name varchar(10) ) insert into src select 'A' union all select 'B' union all select 'C'   create table trg (id int, name varchar(10) ) while loading the trg table, i need to generate a auto increment number and then load it to target. Finally, my trg table data should look as follows id name 1  A 2  B 3  C This is what i have done inside the package. step1 : declared a global variable "tmp" of int32 step2 : created a connection manager pointing to "db1" database step3 : drag n drop data flow task step : inside the data flow task , i have the following        OLEDB Source  (select name from src)           |        Script Component (i have added a new Output column "v_id" of int datatype in INPUTS AND OUTPUTS page)           |        OLEDB Destination In the Script page in Script component , in ReadWriteVariables | User::tmp, I have chose Visual Basic 2008 and clicked the EDit script and inside the Editor this and inisde the below routine i have added only two

Need an example of error in OLE DB Source component when source is Excel file.

I want an example of error (not truncation) in individual row or individual cell that can occur in OLE DB Source component when source is Excel file. I'm trying out Error Output of data task component.  I have already tried out Error Output of OLE DB Destination component.

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.

SQL Reporting Services 2008 Role in SCCM 2007 R2 has error component status message (SMS SRS web ser

SQL Reporting Services 2008 (SMS SRS web service is not running on SRS Reporting point server) with SCCM 2007 R2 -error component status message My environment is (x86) Windows Server 2008 SCCM 2007 R2 with SQL 2008.  The configuration is as follows: SCCM Configuration 1.The reporting Point role on SCCM is installed (SMSSRSRP Setup log is states the install was successful)2.DataSource Settings are SCCMSERVER\SCCM_DB  Test Connection Succeeded3.Database Authentication is set to use (Credentials Stored Securely on the Report Server) I've configured the same credentials in the Reporting Services Configuration ManagerI can access SQL Reporting Services without issue and run reports, etc; but I'm continuing to receive these error status messages..  SRSRP.log Repeats the following: Timed Out... SMS_SRS_REPORTING_POINT 4/17/2009 1:01:58 PM 2076 (0x081C)STATMSG: ID=7403 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_SRS_REPORTING_POINT" SYS=SMS Server SITE=SITE_CODE PID=2748 TID=2076 GMTDATE=Fri Apr 17 17:01:59.165 2009 ISTR0="SMS Server" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_SRS_REPORTING_POINT 4/17/2009 1:01:59 PM 2076 (0x081C)Failures reported during periodic health check by the SRS Server SMS Server. Will retr

Master Detail-Modal Popup Duplicate Component ID error

This is my main page in which I have collapsible panel and my phone gridview is contained in it. The Initial page loads up properly and shows the gridview. All the errors happen when I select a gridview row for modal popup edit. I get the following errors one after other after ignoring each one of them. I have been struggling with his for almost a week. I would appreciate if someone could help me get rid of these errors. Following are the sections of the main page and the code in the gridview ascx control . Main GridView User Control Page.<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPages/basemaster.master" %> <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %> <%@ Register TagPrefix="ucophone" TagName="ucopsphone" Src="~/UserControls/online_app_phone_gv.ascx" %> <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <div> <asp:UpdatePanel ID="UpdatePanel1" runat="server"> <ContentTemplate> <asp:CollapsiblePanelExtender ID="CollapsiblePanelExtenderPhone" runat="server" TargetControlID="PanelContentPhone" Supp

Anyone can share the code (or) the component - XML Destination Adapter

Is there anyone, who can share me the Code (or) the component itself for XML Destination Adapter.  I have a requirement to create XML file as a destination from the source being 3 to 4 tables.  Request your quick response for this.  Thanks a lot.

Error: The replication agent has not logged a progress message in 10 minutes

Hello,      We are consistently getting the error message below on our subscribers that have blob images. Is there a way to increase a setting to avoid SQL to throw this error, or another suggestion? Thanks in advance.   John   Error messages: The replication agent has not logged a progress message in 10 minutes. This might indicate an unresponsive agent or high system activity. Verify that records are being replicated to the destination and that connections to the Subscriber, Publisher, and Distributor are still active.   18 -BcpBatchSize 10000018 -ChangesPerHistory 10018 -DestThreads 218 -DownloadGenerationsPerBatch 518 -DownloadReadChangesPerBatch 10018 -DownloadWriteChangesPerBatch 10018 -FastRowCount 118 -HistoryVerboseLevel 318 -KeepAliveMessageInterval 30018 -LoginTimeout 1518 -MaxBcpThreads 218 -MaxDownloadChanges 018 -MaxUploadChanges 018 -MetadataRetentionCleanup 118 -NumDeadlockRetries 518 -PollingInterval 6018 -QueryTimeout 40018 -SrcThreads 218 -StartQueueTimeout 018 -UploadGenerationsPerBatch 318 -UploadReadChangesPerBatch 10018 -UploadWriteChangesPerBatch 10018 -Validate 018 -ValidateInterval 60   Due to the memory leak issue with respect to replicating blobbed images we have changed UploadGenerationsPerBatch to = 3.

TX Replication Error: Agent set to verbose 2


Tx Replication is giving an error

Command attempted:

if @@trancount > 0 rollback tran
(Transaction sequence number: 0x00001E880000202E000800000000, Command ID: 1)

Error messages:

2010-09-16 20:10:17.543 Microsoft SQL Server Log Reader Agent 10.0.2531.0
2010-09-16 20:10:17.597 Copyright (c) 2008 Microsoft Corporation
2010-09-16 20:10:17.622 Microsoft SQL Server Replication Agent: logread
2010-09-16 20:10:17.647
2010-09-16 20:10:17.663 The timestamps prepended to the output lines are expressed in terms of UTC time.
2010-09-16 20:10:17.717 User-specified agent parameter values:
   -Publisher Server_A
   -PublisherDB db_A
   -Distributor Server_b
   -DistributorSecurityMode 1
   -Output C:\Users\xyz\Desktop\OUTPUTFILE.txt
   -Outputverboselevel 1
   -XJOBID 0x052684F1D410C746B5AFE798220E5440
   -XJOBNAME Server_A-db_A-5
   -XSUBSYSTEM LogReader
   -XSERVER Server_A
   -XCancelEventHandle 0000000000000960
   -XParentProcessHandle 00000000000009F0

Component Service Error; Where is the object?


Has anyone seen this before?

The machine-default permission settings do not grant Local Activation permission for the COM Server application with CLSID {000C101C-0000-0000-C000-000000000046} to the user QUILNET\SPFarmAccount SID (S-1-5-21-174560267-3847720226-3386768351-2185) from address LocalHost (Using LRPC). This security permission can be modified using the Component Services administrative tool.

I looked for 000C101C-0000-0000-C000-000000000046 in the component services MMC but I couldn't even find any existance of it to change the permissions. any ideas?


Owner, Quilnet Solutions

.NET 3.5 SP1 failed with the error message - Error code 1603 for this component means Fatal error du

I had Beta version of VS 2008 and I wanted to install .NET 3.5 SP1. Installation led to some serious problems. I tried almost everything to install .NET 3.5SP1 (or VS 2008 SP1), nothing works

* VS 2008 has been uninstalled
* 3.5 uninstalled and cleaned
* 3.0 uninstalled and cleaned
* WF components removed
* document manager components removed

when I try to reinstall 3.5SP1, I keep receiving the following error in dd_dotnetfx35error

[01/11/09,00:23:05] XPSEPSC Installer: [2] Error code 1603 for this component means "Fatal error during installation.
[01/11/09,00:23:06] XPSEPSC Installer: [2] Setup Failed on component XPSEPSC Installer
[01/11/09,00:23:32] WapUI: [2] DepCheck indicates XPSEPSC Installer is not installed.

Then I check the contents of dd_dotnetfx35install for the event error log and found the following
[01/11/09,00:23:05] XPSEPSC Installer: ***ERRORLOG EVENT*** : Error code 1603 for this component means "Fatal error during installation.
[01/11/09,00:23:05] Setup.exe: AddGlobalCustomProperty
[01/11/09,00:23:06] XPSEPSC Installer: ***ERRORLOG EVENT*** : Setup Failed on component XPSEPSC Installer
[01/11/09,00:23:06] Setup.exe: GetGlobalCustomProperty - Property: {BBE1827C-F2FD-4FDA-A6D6-C83B62FFFDCA} - PropertyName: compfailed - Value: 0
[01/11/09,00:23:06] XPSEPSC Installer: CBa
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