Ssis package path in the configuration dtsx file [Answered]RSS

• • Reply
  pkishanv

  None

  0 Points

  6 Posts

  Ssis package path in the configuration dtsx file

  Jun 08, 2013 07:22 AM|pkishanv|LINK

  I've tried adding the aabsolute path into the config file and tried executing the package which won't work

  Eg: \DatabaseName\PackageName

  I've added an entry into the package config file of the path and used that variable in the package execution settings. Error says

  Error 0xC001000A. Failed to load the package "@[User::PackagePath]" from SQL Server "Database Engine". Make sure the package exist on the SQL Server and you have the correct credential to access it.

  Its very Urgent .... Issue in prod ... Please help

• • Reply
  Angie xu - M...

  All-Star

  32809 Points

  3816 Posts

  Microsoft

  Re: Ssis package path in the configuration dtsx file

  Jun 13, 2013 04:11 AM|Angie xu - MSFT|LINK

  Hi pkishanv

  You can refer the package configurations to learn how to set configuration dtsx file path, at the same time you can also use relative path for ssis packages dtsConfig files, the blog will be available for you,

  # Package Configurations

  http://msdn.microsoft.com/en-us/library/ms141682.aspx

  # use relative path for ssis packages dtsConfig files

  http://myblog-sdn-bhd.blogspot.com/2009/02/use-relative-path-for-ssis-packages.html

  # use relative paths for SSIS packages dtsConfig files

  hope it helps you,

  Regards

  MSDN Community Support
  Please remember to click "Mark as Answer" the responses that resolved your issue.
  If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.