Error when trying to Run/Rebuild a package transfered from another machine

• arik_beri

  Old Hand

  Points: 377

  More actions

  July 5, 2010 at 5:54 am

  #141156

  Hello everyone,

  I'm recieving an error message when trying to run/build a package, saying:

  System.UnauthorizedAccessException: Access to the path 'C:\BI\SSIS\XXX\XXX\bin\XXX.dtsx' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.SetAttributes(String path, FileAttributes fileAttributes) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.BuildIncremental(IOutputWindow outputWindow)

  I should mention that I've been working on this package using my local machine at home, with my own computer settings, and now trying to copy it to my server at work. Before doing so I've changed the ProtectionLevel of the package properties to DontSaveSensitive, and after updated all my connection managers.

  Thanks for your help,

  Arie.

• Alexander G.

  SSCrazy

  Points: 2705

  More actions

  July 5, 2010 at 9:05 am

  #1188805

  Kinda basic:

  Is your XXX.dtsx already existing in the bin directory?

  Do you have file system write permission on the file and the directory?

• Jason Wisdom-380639

  SSCrazy

  Points: 2083

  More actions

  August 16, 2010 at 1:23 pm

  #1207540

  I just had this problem and figured it out.

  Delete the bin\ directory and rebuild.

  A bin\ dir from a foreign machine seems to give it fits.

  HTH,

  Jason