.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

Visual Studio 2008 crashes on SSIS Data Flow Task opening

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

Visual Studio 2008 crashes on SSIS Data Flow Task opening.
This is a random behavior on random SSIS packages on Data Flow Task opening on packages that I've finished developing last week. The packages does not executes with error.

Error Description from Event Viewer:
Faulting application devenv.exe, version 9.0.30729.1, stamp 488f2b50, faulting module msdds.dll, version 9.0.30729.1, stamp 488f2e31, debug? 0, fault address 0x00012b6a.

I'm runnig SSIS development against SQL SERVER 2008 ENT 64.

There is already a fix for this ?

My environment description:
Microsoft Visual Studio 2008
Version 9.0.30729.1 SP
Microsoft .NET Framework
Version 3.5 SP1
Installed Edition: Professional

Microsoft Visual Basic 2008 91605-270-4167253-60984
Microsoft Visual Basic 2008
Microsoft Visual C# 2008 91605-270-4167253-60984
Microsoft Visual C# 2008
Microsoft Visual Studio 2008 Tools for Office 91605-270-4167253-60984
Microsoft Visual Studio 2008 Tools for Office
Microsoft Visual Web Developer 2008 91605-270-4167253-60984
Microsoft Visual Web Developer 2008
Crystal Reports    AAJ60-G0MSA4K-68000CF
Crystal Reports Basic for Visual Studio 2008
KB944899, KB945282, KB946040, KB946308, KB946344, KB946581, KB947171, KB947173, KB947180, KB947180, KB947180, KB94

View Complete Post

More Related Resource Links

WPF Designer (in VS 2008 and VS 2010) crashes with Visual Studio

Good day all. I have the following question: WPF designer in both VS 2008 and VS 2010 crashes with Visual Studio when I try to edit UI form. Moreover, it crashes even when I try to save .xaml.cs file. Meanwhile, Winforms and Dataset UI editors work as usual. Are there other people met this issue? And how could I fix up this problem? Deleting the .suo file, uninstalling silverlight, repairing visual studio, and further googling did not help me. Thanks in advance.

Visual Studio 2008: having trouble in opening any web page

hi alli am unable to run any web page in the browser that i design in visual studio..i didnt understand that what happened.As the visual studio was working fine and i can easily run my websites that i create in it but now i tried to run different pages in its internal browser,internet explorer,mozilla firefox but they give error(the error which we get when we are not connected to internet and try to open a url).Even i had tried to build a new website and run it but the problem is still..i cant figure it out thats why came here and posted.so can anyone help me out...

How to use SharePoint 2007 list data in Reporting Service (Visual Studio) 2008?

Jeez - I have been googling left and right, and tried all the suggestions. No luck in getting it to work. I am using Reporting Service 2008 tools in my VS2008, trying to create a simple report using SharePoint 2007 data (from a simple list). Here is what I've been doing: Created a simple SharePoint list in a test site - only one column (Title) with one record of data. Started Visual Studio 2008 and created a new Report Server Project Wizard project. I named the data source "dsTest". Type: "XML". As connection string I used: http://site/subsite/subsite/_vti_bin/lists.asmx. Credentials: "Use Windows Authentication (Integrated Security)". Clicked Next and arrived at the "Design the Query" form. I entered this in the Query string box: <Query> <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems" /> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> </Query> Clicking Next I get this error: An error occurred while the query design method was being saved. Failed to execute web request for the specified URL. Soap Fault: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown. Now if I view the Details when trying it inside the Query Builder I get this: <errorstring xmlns="http://schemas.mi

Is there any Data Flow Task in SSIS to merge 3 different recordsets (from 3 different tables) and se

I have a requirement, that has 3 different Execute SQL Task that returns 3 different recordsets which differ from each other.  I want to know whether these 3 recordsets can be sent as Input to a Script Component.  I know that Script Component accepts only 1 Input... But is there any way, to have this done

need hint for ssis data flow task...



In my project, i have two data sources tables lets say oledb1 and oledb 2 in data flow task.

i want to load the data into destination (oledb3) by using the following logic...

select col1, col2, col3 from oledb1 where col1 not in (select col1 from oledb2);

Please help me...



Concatenating several rows data into one field Visual Studio 2008


Below is my a example of my table and data.  I am using Visual Studio 2008.  I need to concatenate field customer_report with like field ‘number’.  I added a new SQLDataSource and put the query below into it.


Select Main.number,

       Left(Main.CustomerNotes,Len(Main.CustomerNotes)-1) As "CustomerNotes"

From(Select distinct PS2.number, 

           (Select PS1.customer_report + ',' AS [text()]

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

how to improve/optimize ssis pacakge data flow task


in my SSIS package, i have a Dataflow Task,

it reads data from text file and store into db table, in this data flow task i have only flatfile source and oledb destination nothing else (such as derived columns etc)

is there any way that i can improve the performance, each feeds has 13 columns with 70,000 rows in it

could you please tell me how to optimize this dfd step if exist any

thanks in advabce

Windows Application Migration - Visual Studio 2008 to 2010 - The "GenerateResource" task failed unex


I hav a windows forms application built using VS 2008 which I am trying to migrate to VS 2010 & .net 4.0.

I got this nasty bug and found that it is due to the embedded images in the resource file.

<!-- [if gte mso 10]> <mce:style>

The "GenerateResource" task failed unexpectedly. System.InvalidOperationException: The security state of an AppDomain was modified by an AppDomainManager configured with the NoSecurityChanges flag.

I tried the following solutions suggested in various forums.

I added the < NetFx40_LegacySecurityPolicy enabled

Delimiter File Read Task Installer failed to show in SSIS Data Flow Items


I downloaded the Delimiter File Read and followed the instruction and installed it. The file is on the correct directory (>:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents) The file DelimitedFileReader.dll is there.

However, when I go to BI Development Studio and try to add the new task I can't see it in the SSIS Data Flow Items...it is not visible. Does anyone know why I can add/see it?



SSIS data flow task not loading all rows from sybase server



Using a data flow task I am trying to load data from a table in sybase server to sql server. There are approx 10000 rows in the sybase table, however for some reason which I am not able to find out, at random certain no of rows are getting inserted. e.g. in one run 800 rows then 200 rows etc.

Can somebody please guide me on this?

Visual Studio 2008 Help Crashes on Search


I can't get to the Object Libraries using Help Search in VS 2008. This seems to be a common problem. I have Windows 7 Professional, 64-bit machine.

Is there a fix for this?


SSIS - Data Flow Task Reads Fast But Importing the Output,Update & Deleting Extremely Slow & runs lo


Good day, I need help please.

In my source I read about 4mil records in a matter of seconds But Importing the Output to the Same Table takes about an 1 hour to update.

My Source Read is the Same Table to which i'm Importing, Updateing,Deleting

Importing: Table Lock & Check Constraints are checked

Please any ideas & suggestions will be great.

Thank You

Cannot consume WCF Data Service from Visual Studio 2008


Hi all

I created  two similar oData services:

1. ADO.NET Data Service with Visual Studio 2008 and the .NET 3.5 SP

2. WCF Data Service using Visual Studio 2010

and they both work in IE.

I can make a Service Reference to the first one with VS2008.

The problem is when I try to use Visual Studio 2008 as a client and I try to add a Service Reference for the WCF Data Service made with Visual Studio 2010:
an Error (Details) occurred while attempting to find services at 'http://.............Myservice.svc'

and the Detail is:

Parameter name: edmxDocument

the xml of the 2 services is perfectly the same (with the exception of the url in the "base" attribute in the service node)

Any tip?




Visual Studio 2008 and SQL Server 2005 SSIS packages


My home machine has sql 2005  and Visual Studio 2005 installed. I uninstalled VS 2005 (RTM) and installed VS 2008 (RTM) in its place. I then found that the SSIS templates were missing. Lesson: don't uninstall VS 2005 if you want to use SSIS 2005!


1. Is there any "workaround" to this issue?


2. (If the answer to 1 is "No") I will install VS 2008 side-by-side with VS 2005 on the same box.  When the SSIS issue is finally resolved, can I uninstall VS 2005 without doing damage to the VS 2008 install?










Visual Studio 2010 crashes when opening XAML files


I'm having a problem opening XAML files in Visual Studio 2010.  When I open a XAML file, Visual Studio become very slow and the XAML file never produces an outline or a rendered version of the XAML.  When I click in the text of the XAML, it can take several minutes for the cursor to appear where I clicked.  The XAML file is rather small - just a grid with some basic controls on it (a grid, stack panel, radio buttons, date pickers, etc).  The problem occurs if I open any XAML file in the project, though.

When I watch devenv.exe in the task manager, as soon as I open a XAML file, the process is consuming 100% of one of the CPUs and begins eating chunks of memory at the rate of about 5MB/second and creating a new thread about every two seconds.    The memory use grows until it's about 700MB and the number of threads climbs to between 450-470 before it levels off.  Even after it stops producing new threads and consuming more memory, the XAML file is still unresponsive and it's still using 100% of one of the CPUs.  Even after a half hour, the CPU is still at 100% with 452 threads.

I have completely uninstalled and reinstalled Visual Studio but I'm still having the same problem.

I'm running XP sp3 32-bit with VS 2010 Ultimate on a dual core machine with 4GB RAM.  At this point I simply can't edit XAML

Export SQL Data to Microsoft Excel (using Visual Studio 2008, c#) in asp.net

I have list of tables in my database.

how to retrieve list of tables including data into databound control and

how to export the tables data to excelsheet individually.. 

a)Gets the list of tables within the database 
b)Gets data 
c)Exports the data to excel worksheets (there are 2 methods defined (1) range method (2) cell by cell 
d.) Saves the excel sheet

plz provide the code for above requirements as soon as possible

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