.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

When editing a SSIS package in Visual Studio, copy-paste actions have annoying behaviours.

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

Currently, I'm in a project with high use of SSIS packages.

I've setup a package with many Sequence Containers in order to group Tasks and have these groups to execute modularly before continuing in the next group.

There are Tasks that are very similar, so I just copy-paste them and then change properties.

The problem is that, when I do the "paste", the Task rectangle is always placed in a left-bottom location relative to the currently existing Tasks and Sequence Containers (instead of below the coordinates of the mouse after the right click, as one would expect).

It was already annoying when I didn't use Sequence Containers, because I had to scroll around just to pick the Task in the strange place to where it was copied and put it in the right place.

But it started to be worse with Sequence Containers. Although it really detects the coordinates of the mouse and puts the Task inside a Sequence Container if I right-click over an empty space of the container, it continues to place the Task in a very far left-bottom place relative to the remaining objects. It causes the Sequence Container to stretch until its border contorns the Task in that strange place. I have to 1) move the Task object to the right place and 2) resize the Sequence Container borders to its original status.

Currently, to avoid the step 2 abov

View Complete Post

More Related Resource Links

Paste As Visual Basic: A Visual Studio Add-In That Converts C# Code To Visual Basic


Build a Visual Basic add-in that lets you copy C# code and paste it into Visual Studio as Visual Basic using the code converter of your choice. Scott Swigart shows you how.

Scott Swigart

MSDN Magazine February 2006

Smart Tags: Simplify UI Development with Custom Designer Actions in Visual Studio


Windows Forms 2.0 components expose smart tags by utilizing Designer Actions. By taking advantage of this feature, you can add smart tags to your own custom components to make setting their properties and other actions much easier and developer-friendly.

Michael Weinhardt

MSDN Magazine July 2005

Copy/Paste Fails in Management Studio

After opening Management Studio and doing some editing it is possible to copy/paste things in the query editor. After a while (working in another app) I come back to Management Studio and I can't copy/paste anything anymore. If I try to copy from the results window I get an error message that the clipboard operation did not succeed. If I try to copy from the query editor window it just doesn't copy. I can copy/paste in other apps without a problem.   I have seen this problem described in other forums so I'm not alone but I have 3 other computers where this problem does not occur. The one machine with the problem is hyper-threading. I wonder .... Any other ideas? It is not the clipboard getting full but I can't rule out much else.

MS Visual STudio 2010 Beta and SSIS Designer - BI Development Studio

Hello, I am trying to use SSIS Designer with BI Development Studio.  I downloaded MS Visual Studio 2010 Beta and do not find an option to get into either the SSIS Designer or BI Development Studio. Can someone please help?   Thanks, Chela 

SSIS "Save copy of Package.dtsx as" is not available

Hello,I had previously upgraded my Visual Studios to 2008 Pro, and have just upgraded to SQL Management Studio 2008.  I can create/edit/upgrade packages using 2008, but when I attempt to put them on the server there is no File > "Save copy of Package.dtsx as" option available.  The only options are Save, Save as, and Save All.  Any ideas?

SSIS package is giving error when ran thru JOB...its running good when I execute in BI Studio or Exe

Friends I am getting weird issue...I built an SSIS package. In one variable I used express builder and built like this... RTRIM( (DT_STR, 2,1252)  (((DT_I4) ( (DT_WSTR, 3) (SUBSTRING( @[system::machineName] , 12, 16 ))) +1) /2)) when I run the package outside ie., with VStudio or execute utility it running absolutely with out any problem. But when I created a job just to execute that package in particular timings...the job is totally failing by throwing error....the error output is like the following: Started:  10:22:33 AM Error: 2010-02-27 10:23:06.23    Code: 0xC00470C2    Source: Rerun_MissingFiles    Description: Error code 0x80020005 occurred attempting to convert from data type DT_WSTR to data type DT_I4. Error: 2010-02-27 10:23:06.23    Code: 0xC00470C4    Source: Rerun_MissingFiles    Description: Casting expression "(SUBSTRING( @[system::machineName] , 12, 16 )))" from data type "DT_WSTR" to data type "DT_I4" failed with error code 0xC00470C2. End Error Can any one help me please? Thanks in advance.

Visual Studio 2008 crashes on SSIS Data Flow Task opening


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

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 'copy web site' error


I am getting the following error when I try to establish ftp remote connection using the 'copy web site' feature on visual studio 2005.

unable to open the web 'ftp://209.*.*.*/httpdocs'. The computer is disconnected from the network.

Why can't I connect to the remote site on visual studio 2005? I can do the same thing on Dreamweaver with no problem. I can ping the IP successfully. I can open the ftp URL on a web browser with no problem.

Creating a SSIS package to get data from free DBF (Visual FoxPro table) in 64 bit SQL Server


Hi everybody,

I originally posted in the wrong forum MSDN Thread

I'm trying to create (for test purposes) a package to load data from VFP table into SQL Server 64 bit. So far I can not figure out how to do it - I created DSN as outlined in Todd's blog, but I don't know what to do next.

Can someone please give me step by step instructions so I will know if it's possible or not? I was under impression it's not possible, but Todd's blog seems to suggest otherwise.

Thanks in advance.

Premature optimization is the root of all evil in programming. (c) by Donald Knuth

Naomi Nosonovsky, Sr. Programmer-Analyst

My blog

SSIS Projects in Visual Studio 2010 Beta 2

Is there any way to open/upgrade or create an SSIS project (2008) in vs 2010 b2?  I want to migrate my datawarehousing solution and these projects are excluded and it says they are not valid with this application...

Visual Studio Performance is terrible when editing data templates


I am building a WPF application that has multiple resource dictionaries and data templates.  I have my settings set to always open xaml in the source only view, and I have looked to see if I could find any other settings that would help my performance.

In visual studio 2010 the performance gets so bad I literally cannot work.  If I type one letter, the letter shows up and then visual studio thinks for several minutes before letting me type another letter and repeating the cycle.  It does seem that rebooting my computer helps, but it gets bad quickly enough that rebooting too often isn't exactly a good solution.

Does anyone have any information that can make visual studio usable for working with my xaml?

All that is gold does not glitter, Not all those who wander are lost

How can I copy a SSIS package from one server to another server and maintain the same OLE DB Connect


I have an SSIS package that has 10 data flow tasks that was created in Visual Studio 2005.

Each one has a different OLE DB Source but the same OLE DB Destination table.

I am moving from one 2005 server (A) DB to 2008 server (B) DB.  The DB has the same name. The 3 connections used for the 10 different OLE DB Source will be on server (B). The 1 connection used for the 10 different OLE DB Destination will be on server (B). The same OLE DB Destination table is also on server(B). 

When I convert this package to Visual Studio 2008, I lose my connections and have to change each one to the connections on server (B).

Is there a way to change the OLE DB Connection manager 1 time, without having to change it 10 times for the OLE DB Source?

Is there a way to change the OLE DB Connection manager for the OLE DB Destination 1 time, without having to change it 10 times for the OLE DB Destination table.

Thanks for your help.


ASP.NET 4 and Visual Studio 2010 Web Development Beta 2 Overview

Many exciting changes for ASP.NET are coming in the .NET Framework version 4. This document gives an overview of many of the new features that are included in the Beta 2 release of the .NET Framework 4 and of Visual Studio 2010.

Visual Studio 2010 Beta 2

This is a big deal. This isn't ".NET 3.6" - there are a lot of improvements of .NET 4, and it's not just "pile on a bunch of features so you get overwhelmed." I've been working with and talking to many of the teams involved and even though it's a cheesy thing to say, this is a really customer-focused release.

ASP 4 - Whirlwind Tour around .NET 4 (and Visual Studio 2010) Beta 1

There's a lot of stuff that's new and added in .NET 4, but not in that "overwhelming-I-need-to-relearn-everything" way. More in that, "oh, this is way easier/simpler now" way. Like, moving data around with ADO.NET DataServices is easy, binding with client templates is easy, there's F# if you need it, the "dynamic" keyword if you need it, Silverlight's already installed, oh, and the parallel stuff will freak you out, but in a good way.

Short Overview of SharePoint Features in Visual Studio 2010

As you probably know, Visual Studio 2010 was announced earlier this week and it contains a lot of cool features and project templates for SharePoint developers. Below is a short overview for some of the SharePoint development related features and project templates.
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