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 and then change them as I want, so I've got a sort of workaround, but I want to identify why I can't just drag the task onto the pane. Other suggestions for addressing related problems suggested using regsvr32 to reregister DTSPipeline.dll, but that failed to do anything visible. I was using the program without a problem yesterday, and had made no configuration changes; I suspect that a GPO update may have been pushed to the computer overnight, causing the problem, but I don't know what could do this.
August 12th, 2009 11:25pm
Sean - I am having the same problem. It has been seceral days since I worked in SSIS, but for some reason today, I am having the same problem as you. Did you find a solution?
August 13th, 2009 4:09pm
It's a missing dll or assembly causing the problem - just need to identify which one. Usually unisntalling the SQL Management Tools feature, and reinstalling that feature does the trick. Since some of the assembiles are shared between Management Tools and SSIS, you might have to uninstall both Tools & SSIS and reinstall them both to get it working.Do you have this fusion log viewer tool? C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\FusLogVW.exeIf you do, run it, and configure it to show failures. - Close BIDS and open BIDS fresh. - Refresh the fusion log viewer, Clear the viewer to clear out any load time assemblies that are references.- Then create the new package, and drop in the dataflow.- Then refresh the fusion log to show if any assembiles got loaded. Click on each one and it will open in Internet Explorer. The page will show details if the Bind was successful or if the Bind failed. I suspect the error will be something like "Bind result: hr = 0x80070002. The system cannot find the file specified."Thanks, JasonDidn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance
August 16th, 2009 5:34am
Jason,I too am exhibiting the same problem. I try to drag and drop the Data Flow Task from the Toolbox to the Control Flow window and it doesn't allow me to do it.I tried your FusLogVW.exe thing above, logging failures to disk. I restarted BIDS, and then refreshed the log viewer. no assemblies showed up. I created a new package, (even went one step further and tried a whole new project also) and...it didn't appear to do anything. Refreshing shows nothing.I am probably doing something wrong...but what it is right now escapes me. I guess I will have to uninstall the Sql Management Tools thing...LayneLayne Mills
October 8th, 2009 4:01am
Wierd question that could be related - Is your MS DTC (Distributed Transaction Coordinator) service started?If MSDTC is started, disregard. If MSDTC won't start, and the application log in event viewer says it fails to start, then investigate it...Go into the Administrative Tools > Component Services snapinLook for the Distributed Transaction Coordinator under the tree structure under My computer on the left. Right click and view the properties on of the DTC.Check the Security tab and check the Account being used. We have seen this kind of error go away when enabling "Enabled MSDTC for Network access" which is a quandry to me - I'm not sure why this setting changed anything, but for some folks it helped.Thanks, JasonDidn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance
October 8th, 2009 5:50am
I had the same problem, for no reason I could distinguish between one day and the next, I could no longer drag data flow tasks into my package from the toolbar. No error message, nothing. Eventually in sheer frustration I double-clicked the data flow task in the toolbar, and it worked. Still doesn't drag and drop, all the other tools will drag and drop, but the only way to add a data flow task is to double-click it.Go figure.
November 27th, 2009 9:23am
You have an SSIS package in debugging mode. Go to "Debug", "Stop Debugging" and then check again if SSIS toolbox items are ready for drag-and-drop again.Cheers,Ferruccio Guicciardi Application Support
February 24th, 2010 7:46pm
You have an SSIS package in debugging mode. Go to "Debug", "Stop Debugging" and then check again if SSIS toolbox items are ready for drag-and-drop again.Cheers,Ferruccio Guicciardi Application Support Nope. Thats not it. As I said ... for weeks now, all toolbar items work fine, drag and drop, everything. Just the Data Flow task, I drag it from the toolbox (mouse changes to insert pointer), but NOTHING happens when I release the drag. But if I double-click the Data Flow Task in the toolbox it is added.Cheers,--MikeJ Nver mind though ... the double-click works as a work-around for me, and if it ever does bug really start to bug me, I will uninstall and reinstall.
March 3rd, 2010 10:24am
Hi, I too have suddenly encountered this drag and drop issue overnight. For me though it is all items not just the data flow task. I am also unable to move any existing items in a package. I can remove, add, modify and save just not drag and drop. Yes I can double-click to add new tasks but what a mess! MikeJ - did a reinstall sort it for you? If anyone has a solution I'd love to hear about it (if possible with appropriate instructional annotation for a DBA yet to become best friends with Visual Studio!) Thanks, Simon
September 23rd, 2010 7:29pm
Hi Simon, I did not reinstall, but subsequently noticed I only had this problem in Visual Studio 2005. Visual Studio 2008 works perfectly. When I have to work in 2005, I just live with the problem. It might even be that the problem is due to me running both versions, as I support clients with different versions of SQL. Good Luck, -Mike
September 27th, 2010 2:51pm
double clicking worked for me
May 17th, 2011 11:50am