.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

The DataFlow task has no components. Add components or remove the task.

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :Sql Server
Hello, we have the following problem: 1. Simple DTS-Packet with very simple data flow "Source -  Destination" from Access to SQL Server is prepared as file. It is executed under our own WinForm C# Application. 2. On one machine (SQL Server 2005 Developer Edition) everything works fine. 3. When we try to execute this package on another machine (SQL Server 2005 Standard Edition) we get message "The DataFlow task has no components. Add components or remove the task" and the task does not do anything. However, it runs fine under "dtexecui". We have already search the problem in the internet and could not find anything that could solve the problem (we don't use Source Safe). Thank you very much in advance, Vladimir

View Complete Post

More Related Resource Links

How to get the Task/Components Source Creation Name at Event Handler level


My SSIS Package has Task1 and Task2, there is an Event Handler attached at Package level OnPreExecute event.


Events are captured fine on OnPreExecution of Package, Task1 and Task2 but

I want to capture the Source Creation Name at Event Handler level…I have only variables like SourceID, SourceName, SourceParentGUID and Creation Name at Event level... not the Source Creation Name.


Is there anyway we can capture the Task/Components Source Creation Name at Event Handler level??



SQL 20008 UNINSTALL does not remove all installed components



- SQL 20008 UNINSTALL does not remove all installed components

After installing FEATURES="SQL,IS,TOOLS" and uninstalling every feature I know with :


- I still have these components left installed :

Microsoft Office 2003 Web Components
Microsoft SQL Server 2008 Native Client
Microsoft SQL Server Compact 3.5 SP2 ENU
Microsoft Visual Studio 2008 Shell(integrated mode)
Microsoft Visual Studio Tools for Applications 2.0

Any ideas on which FEATURE to select to uninstall these from the command line ? (I do not want to uninstall manually from Control Panel Add Remove Programs.)

Instruct DataFlow task to Redirect bad input rows to Log file?

Hi all,

I am new to SSIS 2005 packages but have written many in DTS 2000.

I am importing a CSV flat file into a SQL server table with SSIS 2005. How do I tell the Dataflow task to redirect rows that don't have the proper number of columns into a Text log file so I can inspect the bad rows later?

I have pointed the Red Error arrow to a text file and defined all the Columns to redirect the error to the text file. I have set the Max error count to 200. However, the entire package fails at the first bad row in the PrimeOutput() method, indicating that Column 13(the last one in the Row) is missing in a particular row. I have tried setting Ignore the error, but that doesn't work either.

I have created a DTS 2000 package that works on the same CSV input and the same SQL table destination. It seems to have no problem with my instructions.

I must be missing something. Can someone tell me what it might be? I really would like to use SQL 2005 or even SQL 2008 because of the new features available, but I am stuck on what I thought would be a very easy first step (because it is very easy in DTS 2000).

Any help would be appreciated. Thanks...

how to insert value into a Identity column in temporary table using dataflow task



I have requirement.

I have a temporary table with and identity column,table will get populated with data on the execution of a dataflow task except the identity Column.now I need to insert value into identity column.

How can I acheive this.


Thanks, A2H

How to find a dataflow task executed suceesfully or not.


Hi All,

How we can find out a Dataflow task executed successfully or not.

Basically after the dataflow i need to have a check whether dataflow task executed successfully or not.

If successfull then only I have to move with other tasks.If not I have to stop the execution there itself.

How can i do this.


Thanks, A2H

Event Handler (send mail task) firing multiple times for each dataflow error - How can I stop the da


I've set up an OnError event handler for my package which sends an email containing the name of the file that fails import through my dataflow task. The problem is the dataflow experiences three errors (one for each task it is attempting to complete) which in turn causes three duplicate emails to be sent.

I'd prefer to stop the dataflow task completely rather than allow it to try to complete the remaining tasks after the first error. Is this possible? Alternately, how can I set up my event handler to only send one email regardless of the number of dataflow errors that occur?

Thanks in advance!

Parallel Debugging: Debugging Task-Based Parallel Applications in Visual Studio 2010


In Visual C++ 10 and the Microsoft .NET Framework 4, Microsoft is introducing new libraries and runtimes to significantly ease the process of expressing parallelism in your code base, together with new tool support for performance analysis and debugging of parallel applications. In this article, you will learn about debugging support in Visual Studio 2010, much of which is focused on task-based programming models.

Stephen Toub, Daniel Moth

MSDN Magazine September 2009

Windows with C++: Task Scheduler 2.0


The new Task Scheduler in Windows Vista can do so much more than previous versions. We introduce some basic concepts and building blocks you can put to use in your own scheduled task projects.

Kenny Kerr

MSDN Magazine October 2007

Cutting Edge: Simplify Task Progress with ASP.NET "Atlas"


Dino Esposito rewrites his task progress bar with the help of ASP.NET "Atlas."

Dino Esposito

MSDN Magazine October 2006

Cutting Edge: Reporting Task Progress With ASP.NET 2.0


The progress bar is great for keeping users informed about the progress of a task. Unfortunately, there's no progress bar element built into ASP.NET, so Dino Esposito solves that problem with his ProgressPanel control.

Dino Esposito

MSDN Magazine September 2006

Visual Studio .NET: Building Windows Forms Controls and Components with Rich Design-Time Features, P


This is the second of two articles discussing the extremely rich design-time features of the .NET Framework. Part 1 discussed the basics, showing you where to start and how to extend your control implementation through attributes and interfaces, as well as their effects on the property browser, code serialization, and other controls. Part 2 continues the journey by concentrating on design-time functionality that you can implement beyond your components and controls, including TypeConverters, UITypeEditors, and Designers. It would be impossible to cover everything you can do in two short articles, which is a testament to just how all-encompassing and flexible the design-time capability of the .NET Framework is.

Michael Weinhardt and Chris Sells

MSDN Magazine May 2003

Visual Studio .NET: Building Windows Forms Controls and Components with Rich Design-Time Features


Visual Studio .NET provides support for designing rich features into your controls and components, allowing you to set properties, set form placement, inherit from base classes, and much more. So how does Visual Studio .NET do all this? What does the Windows Forms designer do? What's the difference between a control and a component? How does Visual Studio integrate your controls so that they can access features of the .NET Framework?In this article, the authors answer these common questions by building a clock control and taking the reader along for the ride. In building the control, hosts and containers are illustrated, the property browser is explained, debugging is discussed, and a general overview of the design-time infrastructure is presented.

Michael Weinhardt and Chris Sells

MSDN Magazine April 2003

Contexts in .NET: Decouple Components by Injecting Custom Services into Your Object's Interception


The .NET Framework can use contexts as an object's execution scope and intercept calls going to and from the object, similar to the way COM+ provides component services. What is new with this mechanism is that the runtime allows developers to take part in the interception chain and add powerful services, thus extending existing component services. This in turn decouples the business logic from the system plumbing and simplifies long-term maintenance. Presently, .NET contexts and interception are undocumented aspects of .NET. This article presents the underlying interception architecture and message processing, explains custom context attributes, and walks through a custom interception-based component service.

Juval Lowy

MSDN Magazine March 2003

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