Thursday, January 24, 2013 4:12 AM
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.
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
Thursday, January 24, 2013 5:51 AM
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.
Thursday, January 24, 2013 5:56 AM
I have registered all the custom components using GAC.
Tuesday, February 05, 2013 3:20 AM
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