SSIS PACKAGE ERROR

• sql Anand

  SSCommitted

  Points: 1597

  More actions

  January 2, 2012 at 12:57 am

  #250635

  hi

  in my ssis project i am having 20 packages by using package execute task i execute all this 20 package but now i getting error like this in some packages

  Error: Error 0xC0012050 while loading package file "C:\Documents and Settings\ADMIN\My Documents\Visual Studio 2008\Projects\LOAD.dtsx". Package failed validation from the ExecutePackage task. The package cannot run.

  .

  and this error in some packages

  Error: Error 0x80070020 while loading package file "C:\Documents and Settings\ADMIN\My Documents\Visual Studio 2008\Projects\tnddata.dtsx". The process cannot access the file because it is being used by another process.

  .

  how to solve this problem

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  January 2, 2012 at 1:25 am

  #1427322

  sql Anand (1/2/2012)

  ---

  ... The process cannot access the file because it is being used by another process.

  Looks like the package is opened by another person or process. Get it closed.

  You can store the packages in the server, instead of file system, to avoid this situation in the future.