Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Data Flow Paths missing when loading SSIS 2012 package on Windows 2008 R2 server

Answered Data Flow Paths missing when loading SSIS 2012 package on Windows 2008 R2 server

  • Thursday, January 24, 2013 4:12 AM
     
     
    Sign In to Vote
    0

    Hi,

    I have developed a package in SSIS 2012 which uses some custom controls.  I can load it and run it on my development PC but when I copy the package solution to the server and try and open it in Visual Studio Shell, I cannot see the data flow paths in the data flow tasks and it does not work.

    I have added a couple of screen to show what I mean.

    I am not sure what I am doing wrong.  Can someone help me please.

    Thanks,

    Steve

    This is how it looks on the development PC...

    and this is how it looks on the server...


    • Edited by QCCAT Thursday, January 24, 2013 4:37 AM
    •  
     

All Replies

  • Thursday, January 24, 2013 5:51 AM
     
     
    Sign In to Vote
    1

    Hi

    Are the Dll's of the custom components properly registered and place in the desired location on the server. Make sure it is done via visual studio command prompt (GAC). I think that is why it is not able to recognise.

    Please mark it as helpful.

    Thanks

    Sumit

     
  • Thursday, January 24, 2013 5:56 AM
     
     
    Sign In to Vote
    0

    Hi Sumit,

    I have registered all the custom components using GAC.

    Thanks,

    Steve

     
  • Tuesday, February 05, 2013 3:20 AM
     
     Answered
    Sign In to Vote
    0

    I have figured that out.  It turns out that I had Service Pack 1 for SQl Server 2012 installed on the server.  When I installed it on my PC, I was faced with the same issues.

    After doing some more digging, I discovered that SP1 overwrites the fix in CU3 that I had installed previously.

    Uninstalling SP1 and re-installing CU3 fixed the issue.

    The package now runs in Visual Studio 2010 on both my PC and the server.

    • Marked As Answer by QCCAT Tuesday, February 05, 2013 3:20 AM
    •