CodeDigger


When I copy over an SSIS package I have been developing from my laptop to my desktop with Windows File Sharing (shared folders) across a home network, the moved package fails to load properly. I can see the Control Flow tasks but not the Data Flow tasks - they simply disappear! I have update the Connection Managers to point to the new machine, and tested them (OK).

Its the same as this issue posted here

And Here

Creating an empty package and clicking to create a new data flow cause this error:


TITLE: Microsoft Visual Studio
------------------------------


Failed to create the task.


------------------------------
ADDITIONAL INFORMATION:


The designer could not be initialized. Microsoft.DataTransformationServices.Design)

Seems the only way is to uninstall and reinstall Client Components.

How do I uninstall and reinstall Client Components when I try to do that, SQL Server Setup tells me "None of the selected features can be installed or upgraded. Setup cannot procees since there is no effective change being made to the machine...."

I had selected "Workstation components, Books online and Development tools". This is already installed - so how I can reinstall it if I get this message above which does not let me proceed.






Re: Cannot load Data Flow tasks

jwelch


Uncheck it in the installation dialog to uninstall it.







Re: Cannot load Data Flow tasks

Subhash Subramanyam

Hi CodeDigger,

A Question for you is: If you a create a new package on your desktop and drag a dataflow on the Controlflow, does that work fine

If your answer is no, then it seems that it's clearly some other issue not related to deployment.Trying the following steps might help. First try the Step 3, if it doesn't work, try Step 2 followed by step 3, Finally make sure that Step 1 is done before you use this in your desktop.

  1. While deploying to other machine, make sure you do not use EncryptSensitivewithUsekey, Instead use EncryptSensistive with Password. and provide a password.
  2. Go Add / Remove Programs, Click Change/Remove, Repair the Installation and Apply SP2.
  3. In the run command, type devenv /setup. Now open the BIDS, Check if you can add the dataflow task into the control flow.

Thanks

Subhash Subramanyam