CODEWITHSUNDEEP
sql-servervisual-studiossis
user979189
user979189

Reputation: 1298

SSIS package shows blank screen in design mode

I created an SSIS package using SQL Server Data Tools 2015 a week back. And today I opened the package and it just shows the blank screen.

I read about this issue here and it seems that was the defect in earlier versions and it is fixed.

Has anyone faced this issue in SQL Server Data Tools? How can I fix it and save my package?

Upvotes: 42

Views: 32810

Answers (8)

Shah
Shah

Reputation: 21

Right click the package in solution explorer window, click view code, and the in code window , right click and select view designer.

Upvotes: 0

Tim
Tim

Reputation: 1226

  1. While the package is opened with the white page, rename it in the solution.

  2. Save the package and close.

  3. Rename the package back original name (while package is closed). This rename will open the package and hopefully set it back so that you can edit it.

Upvotes: 121

Graham Cottle
Graham Cottle

Reputation: 11

The rename and reopen trick worked for me. I also tried another way. I closed Visual Studio and then located the .suo file under the .vs folder. I deleted that and then reopened and the file reloaded. I hope that isn't too dangerous an approach; it stops git changes being made when the rename is performed

Upvotes: 1

Zberteoc
Zberteoc

Reputation: 1

In the Solution Explorer right click on the .dtsx package file and then click on View Designer.

Upvotes: 0

Richard
Richard

Reputation: 1

I have just encountered this; solution opens but all blank and no sub folders or files in the Solution Explorer. Tried the above suggestions, but no luck. Right clicked on the solution name and selected 'Reload Project' and all good. Hope this helps someone.

Upvotes: 0

Chris Adragna
Chris Adragna

Reputation: 632

I have tried the trick to rename the package. It works as long as I keep a new name, but when I rename the package back to its old name, the problem returns. Importing a new copy of the .dtsx file into the same (broken) project did not fix the problem. [Referring to answer by @Joe]

Here is the only solution that always works for me:

  1. Create a new Visual Studio (or SSDT) solution.
  2. At the new project dialogue, choose "Integration Services Import Project Wizard"
  3. A wizard starts up [hit next if at optional "Wizard Introduction"]
  4. At "Select Source" page choose "Integration Services Catalog"
  5. Browse to server and the project deployment you need to fix

This works, but if your deployed SSIS package(s) was not up to date you need to continue with these two actions:

  • Delete the package(s) in the new (fixed) solution that are old.
  • Import the newer package(s) via "Add Existing Package" from the problematic solution

I suspect this happens due to a problem in the .database or .dtproj file.

Upvotes: 0

Joe Vago
Joe Vago

Reputation: 51

Tim's answer above helped but didnt work for me. Instead this worked in Visual Studio 2015:

  1. Close the solution
  2. Move the .dtsx file that will not open to another folder (ex: C:\Temp)
  3. Rename the .dtsx file to the name you want
  4. Open the solution - you should get a message that the package is missing.
  5. In Solution Explorer, right-click on "SSIS Packages" and select "Add existing Package"
  6. Package Location should be "File system". Click the "..." button and select the moved and renamed .dtsx file. click OK

The .dtsx file should now be added in the solution correctly named - and open for editing.

Upvotes: 1

Jim
Jim

Reputation: 609

All white on open? Just happens from time to time, the stuff is there just close and reopen Visual Studio always makes it come back for me.

But if not you could always find the dtsx file under it all in your users folder:

C:\Users\<yourusernamehere>\Source\Workspaces\<Projectworkspace>

copy it and then pull it back in by right clicking the SSIS Packages folder in Solution Explorer and add existing package see if you can see it then.

Upvotes: 14

Related Questions