.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

SSIS SQL jobs failing urgent help please!!!

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

Here is the error I am getting when running the SQL jobs, this sql job basically runs the SSIS package. Not sure where to look at to fix this error:

Description: The log provider type "DTS.LogProviderTextFile.2" specified for log provider "SSIS log provider for Text files" is not recognized as a valid log provider type. This error occurs when an attempt is made to create a log provider for unknown log provider type. Verify the spelling in the log provider type name.



View Complete Post

More Related Resource Links

CDC Jobs Failing

Hi Team, I had a Database AAAA on Dev Server which was CDC Enabled. Then I restored it From a Production Backup without KEEP_CDC option. After That i enabled CDC and now the Capture Job is getting Failed. M getting the below error. Can someone help me out please Executed as user: XXX\AAA. Could not locate text information records for the column "Comments", ID 8 during command construction. [SQLSTATE 42000] (Error 18773)  The Log-Scan Process failed to construct a replicated command from log sequence number (LSN) {00029267:0002b669:00a0}. Back up the publication database and contact Customer Support Services. [SQLSTATE 42000] (Error 18805)  Log Scan process failed in processing log records. Refer to previous errors in the current session to identify the cause and correct any associated problems. [SQLSTATE 42000] (Error 22859).  NOTE: The step was retried the requested number of times (10) without succeeding.  The step failed.Thanks & Regards, Manjunath C Bhat, http://manjunathcbhat.blogspot.com http://manjunathcbhat.wordpress.com

Execute an SSIS package from ASP.net (C#) - my package keeps failing. Help! - Works on localhost but

I'm looking for any and all information on how to execute an SSIS package from my asp.net web site. I have written the call and when I run the application from (Localhost) it works, but when I run it from the server it does not.Here is my code to call and execute the package: public string ProcessFiles(int ClientID, string FileName) { //System.Security.Principal.WindowsImpersonationContext impersonationcontext; //impersonationcontext = ((System.Security.Principal.WindowsIdentity)ServiceContext.User.Identity).Impersonate(); string packagePath = "\\\\\\Customer File Import.dtsx"; Microsoft.SqlServer.Dts.Runtime.Application app; Microsoft.SqlServer.Dts.Runtime.Package pkg; Microsoft.SqlServer.Dts.Runtime.Variables vars; Application integrationServices = new Application(); DTSExecResult result; FileName = FileName.Substring(FileName.Length - 25 , 25); app = new Microsoft.SqlServer.Dts.Runtime.Application(); pkg = app.LoadPackage(packagePath, null); //pkg = integrationServices.LoadFromSqlServer("Customer File Import.dtsx", "", "healthtech\\brian.montfort", "Nightdragon8", null); vars = pkg.Variables; if (pkg.Variables.Contains("

SQL Agent Failing when trying to run my SSIS Package

My SQL Agent was working fine.  Now when I try to run it, it failes when trying to run my SSIS package.  I looked in the logs, and job history, no luck in finding any critical errors. My SSIS package runs fine through VS 2005 in debug mode. Here are the only errors: 01/04/2006 09:53:48,,Warning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect01/04/2006 09:53:48,,Warning,[260] Unable to start mail session (reason: No mail profile defined)01/04/2006 09:53:48,,Information,[129] SQLSERVERAGENT starting under Windows NT service control01/04/2006 09:53:48,,Error,[364] The Messenger service has not been started - NetSend notifications will not be sent01/04/2006 09:53:30,,Information,[432] There are 11 subsystems in the subsystems cache01/04/2006 09:53:29,,Information,[339] Local computer is BG-SQL2005 running Windows NT 5.2 (3790) Service Pack 101/04/2006 09:53:29,,Information,[310] 1 processor(s) and 512 MB RAM detected01/04/2006 09:53:29,,Information,[103] NetLib being used by driver is DBNETLIB.DLL; Local host server is01/04/2006 09:53:29,,Information,[102] SQL Server ODBC driver version 9.00.139901/04/2006 09:53:29,,Information,[101] SQL Server BG-SQL2005 version 9.00.1399 (0 connection limit)01/04/2006 09:53:29,,Information,[100] Microsoft SQLServerAgent version 9.00.1399.06 (x86 unicode retail build) : Process ID 1860

SSIS Package failing

Hi there, There is SQL agent job that runs a SSIS package once a day, but for the last few days its been failing. As far as I can tell nothing has changed. The Database name is 'Greece' The error message is:   Message Executed as user: S2\ServiceAccount. ...9.00.4035.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  10:14:18  Error: 2010-09-13 10:14:49.36     Code: 0xC0202009     Source: NL LCDB Import Products Connection manager "Greece.eu.LB.com,10563.msdb.BNLSQL"     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E4D.  An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E4D  Description: "Login failed for user 'BNLSQL'.".  End Error  Error: 2010-09-13 10:14:49.36     Code: 0xC020801C     Source: NL LCDB Import Products Log provider "NL LCDB Import Products"     Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Greece.eu.LB.com,10563.msdb.BNLSQL" failed with error code 0xC0202009.  There may be error messages

Problem running SSIS package in Jobs

Hello friendsI'm trying to run my SSIS packages as a step inside a sql agent job.This runs normally when the package uses the SAME database as used to create my job.The problem occurs if I create a job to run the package and this package must execute queries in another database. Probably authentication problem. So how to authenticate my package and the job runs normally ?thanks in advance.

Data Flow Task failing to drag-and-drop onto SSIS Control Flow

This morning, I started having problems with Visual Studio 2005 on XP when I tried to create an SSIS project; I was getting an error message about the failure to create an SSIS runtime object, with the reference "Unable to cast COM of type 'Microsoft.SqlServer.DTS.Runtime.Wrapper.PackageNeutralClass' to interface type". Digging here and elsewhere on the Net, I used regsvr32 to re-register msxml3.dll, msxml6.dll, and dts.dll. This allowed me to create a new SSIS project, but I was unable to add a data flow task to the Control Flow pane -- when I dragged the control onto the pane, nothing happened, and when opened the Data Flow pane and clicked on the 'No data flow task has been defined. Click here to create a data flow task" link, I got a 'Failed to create the task. The designer could not be initialized." error. Searching here and on the Net, I uninstalled and reinstalled the SQL Server 2005 workstation tools.

After doing this, I am still unable to create a data flow task by dragging the task out of the toolbox; the pointer assumes the right form for the drag-and-drop, as it does for other tasks, but when I release the mouse button, nothing happens. However, when I go to the Data Flow pane and click on the 'click here to create a new data flow task', it creates the task, and I am able to use copy-and-paste to make copies of the data flow task

SSIS Jobs VS SQL Server Job Agent


Which one of them is better to just run a set of Strored Procedures on a daily basis.

Can I have some Adv and Dis advantages. Please.


Uniqueidentifier field failing during conversion in SSIS



I am trying to convert a table from one schema to another and the destination table (SQL CE) contains a uniqueidentifier field. This field can accept nulls and is optional. I am not supplying any values for it.

But when I run the package it throws an error.

SQL Server Compact Destination [107]: Data conversion failed. [ OLE DB status value (if known) = 2 ]

If I map a dummy value for this column then the error doesnt occur. Any help would be appreciated. Thanks,

Ganesh Ranganathan
[Please mark the post as answer if it answers your question]

Please, help with a set up to run SSIS jobs.



We have SQL 2008 Enterprise Edition (64-bit) 10.50.1600.1 RTM. It seems I have all rights and permissions there as well.


I tried different methods to run a job but it’s always failed with the message:

The job failed.  Unable to determine if the owner (Domain\MyLogin) of job MyJob has server access (reason: Could not obtain information about Windows NT group/user ‘Domain\MyLogin’, error code 0x5. [SQLSTATE 42000] (Error 15404)).  


It seems I’m trying to do all things advised from different sources:

-          <

SSIS on Cluster also 2005 packages and 2008 db connections and jobs?


Hi, multipart questions.

We have a SQL 2008 Cluster where we do not want to install SSIS.  We have a SQL 2005 SSIS instance on another server  for packages.

here goes

1. Can we configure jobs on the SQL 2008 custer to point to the 2005 SSIS instance? and do we need SSIS installed on the SQL 2008 cluster to do this?

2. Can we run jobs on a SQL 2005 instance, pointing to a SQL 2005 SSIS instance/packages on a third server that connect to a SQL 2008 DB instance . I know that sounds crazy, but where exactly is the CPU and memory load in that design.. job on one server, package a seperate server and db on a third server.?

3. As mentioned, I have SQL 2005 SSIS instance.  I have local admin on that server and can connect to the ssis instance from my sql 2005 sql client on my desktop.  I added a new user to the server and added them to the SSIS and users group. I also made sure they could write to the folder where they will deploy packages. However, they get some kind of access denied while trying to connect, unless I give them local admin on the server.  What more access do they need than to be in the users and SSIS group and have write access to an SSIS deployment folders?


Many Thanks.

SSIS job failing successfully



I have a series of SSIS packages I use to copy data from a MYSQL database to SQLServer.  The packages are set up to execute via a scheduled job.  I each case, the data is copied, but the step that executes the package fails.


Date  7/31/2008 12:54:42 PM
Log  Job History (Test t_accounts)

Step ID  1
Server  xxxxxx

Job Name  Test t_accounts
Step Name  exec
Duration  00:00:02
Sql Severity  0
Sql Message ID  0
Operator Emailed  
Operator Net sent  
Operator Paged  
Retries Attempted  0

Executed as user: xxxxxxx. Microsoft (R) SQL Server Execute Package Utility  Version 9.00.3042.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.   
Started:  12:54:42 PM  DTExec: The package execution returned DTSER_SUCCESS (0). 
Started:  12:54:42 PM 
Finished: 12:54:43 PM 
Elapsed:  0.969 seconds. 
The return value was unknown.  The process exit code was -532459699.  The step failed.


I've turned on logging for every event in the package, but don't see anything that looks like a failure.



Source = MYSQL 5.0 using MYSql Connector /.Net 5.1.6

Destination = MSSQL 200

SSIS Urgent


Hi i am very new to ssis....i need your help please help me out


I do have  txt file(source),count 8900 rows of data ,20-header n trailer adi ragged right record

My requirement is

Write an SSIS package

SSIS is essenstially the wrapper to validate the file, call bcp, then report any errors back to the front end  ??????.

((((I need to write a script task i guess..))))

Validations that SSIS will do: Verify file exists.?????

Validate file size is > 0.????

Call bcp and return any errors back.????

Line count compare stage tables with flat files.?????


These are the steps i need to do can you guys help me out ,suggest me



Errors when using Proxy/Credentials to execute SQL Agent jobs that access SSIS packages


Running SQL Server 2008, on Windows Server 2008.

I'm having a problem trying to execute a job.  The job has executed successfully when I configure the SQL Agent account (domain account with sysadmin permissions in the instance) as the owner/executor of the job.  However, I want to tighten down security so I'm trying to use a proxy/credential.

Here are the steps I've followed:

1) create a non-privileged SQL account called "SQLJobOwner" that owns the job.

2) create a stored credential (domain account) that has an account on the local machine where the instance resides, and has "log on as batch" permissions.

3) created a login to the instance for the domain account that is stored as a credential, and granted sysadmin permissions to the account.

3) create a new proxy called "SSISProxy", and granted access to the SSIS subsystem.

4) Added job owner "SQLJobOwner" as a principal in the SSISProxy configuration window.

5) changed the job step that executes the SSIS package to "Run as" the "SSISProxy".


When I execute the job, the job fails with the following error:

Unable to start execution of step 1 (reason: Could not get proxy data for proxy_id = 1).  The step failed.

In addition, I get

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.

Web Deployment - Setup failing - aspnetca.exe


I have created websetup in windows 7 environment, asp.net 3.5, IIS 7.

Client System is windows 7 and IIS 7

Our client configuration is Windows 7, IIS7 dotNet Framework 3.5.
Following error raising below...
Faulting application name: aspnetca.exe, version: 7.5.7600.16385, time stamp: 0x4a5bcd3c
Faulting module name: aspnetca.exe, version: 7.5.7600.16385, time stamp: 0x4a5bcd3c
Exception code: 0xc0000005
Fault offset: 0x0001d912
Faulting process id: 0xe80
Faulting application start time: 0x01cb3604624975cd
Faulting application path: C:\Windows\system32\inetsrv\aspnetca.exe
Faulting module path: C:\Windows\system32\inetsrv\aspnetca.exe
Report Id: a05d368d-a1f7-11df-8336-4487fc612414
PFA Here I"m attaching custom action script. 

urgent help please (c#)


Hi all,

I need urgent help. (c#coding)

This is a work application form. There are 4 different parts, each of all get different information from user. First, general information like, firstname, lastname, birth etc. Second one is about educational information.

On page there is a dropdown with items; primary education, high school, university etc.(User chooses last completed education). And after that selection, here loads user controls according to selection. During this I have problem with postback. It postbacks all page even I use updatepanel.

I'm writing all code above, first main page(work application form) then designer part; third usercontrol codebehind, last usercontrol designer part.

Please, I really need urgent help very very much.

Thanks to helpers.

First main page: codebehind:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;

public partial class _Default : System.Web.UI.Page
    //these are usercontrols i talked about; highschool, university etc.
    BizimUserControl buc = null;
    liseusercontrol luc = null;
    yuksekunivuc yuc = null;
    universiteusercontrol uuc = null;
    yukseklisansusercontrol yluc = null;
    doktorausercontrol duc = nul

Live website slow - very urgent


Hi All, 

Finally i came to know because of firebug that  ScriptResource.axd's (multiple) are making my files slow on first click

How do i merge them into 1 ??



1. ScriptResource.axd is making my page slow in first click.

On second click onwards its fine as i have added handler from http://madskristensen.net/post/Compress-WebResourceaxd-in-ASPNET.aspx   It helps performance but from second click onwards.I am testing it with FireBug.

2. I have also seen and treid http://www.codeproject.com/KB/aspnet/AspNetOptimizer.aspx  but not able to make out how to implement in my application.

3. I also tried http://madskristensen.net/post/Optimize-WebResourceaxd-and-ScriptResourceaxd.aspx but it has error, I tried making chnage as per the discussion in url but it is sill giving error.

4. I have also made scriptmanager as release mode

Please help its urgent


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