September 24, 2014 at 8:51 am
Hi
I am building a bunch of packages on our new server and all was going well until I edited the project using the client tools on my PC. I now receive the below error if I try to execute any of the packages on the server (all is still fine on the client). I have scoured the net but I don't seem to be able to come up with a solution. I have tried altering the folder & object permissions for my login (that created the project on the server and edited using the client) but I still get the error.
Any help would be greatly appreciated.
ERROR:
TITLE: Microsoft Visual Studio
------------------------------
Failed to start project
------------------------------
ADDITIONAL INFORMATION:
Exception deserializing the package "Access to the path 'G:\VisualStudio\Test\Test\bin\Development\Test.ispac' is denied.". (Microsoft.DataTransformationServices.VsIntegration)
------------------------------
Access to the path 'G:\VisualStudio\Test\Test\bin\Development\Test.ispac' is denied. (mscorlib)
------------------------------
BUTTONS:
OK
------------------------------
Nique
--------
It's better to try and fail than fail to try
September 24, 2014 at 9:00 am
Are the client tools on your PC of a more recent version than your server? Sounds like you may have upgraded your package when you edited it, and now it can't run on the older version.
John
September 24, 2014 at 9:04 am
They are both 2012 SSDT.
I do have 2005 and 2008R2 BIDS previously installed on the client machine. The server is 64 bit.
Nique
--------
It's better to try and fail than fail to try
October 13, 2014 at 7:54 am
The fix for this that worked for me was to:
1. exit Data Tools
2. open Task Manager and end any processes of DTSDebugHost
3. Delete the ISPAC file
4. open Data Tools and rebuild the package
November 24, 2014 at 4:48 am
Hi Dave
Thanks for your response. My fix involved deleting the .ispac file and also giving access to myself for the folders I created...!
Thanks
Nique
Nique
--------
It's better to try and fail than fail to try
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply