SSIS - Path Name Failure

• Colin Betteley

  Hall of Fame

  Points: 3095

  More actions

  July 15, 2010 at 10:33 am

  #221347

  I am running a SSIS package to get data from a spreadsheet.

  I log onto the SQL Server as the profile running SQL and can manually run the package direct from BIDS, no problem.

  If I run as a scheduled job then the job fails stating that the path to the file does not exist.

  I have checked the path name numerous times and the task is running asthe same user in both cases, but only works direct from BIDS.

  What am I missing?

  Thanks

  Colin

• emily-1119612

  SSCarpal Tunnel

  Points: 4166

  More actions

  July 15, 2010 at 10:38 am

  #1193626

  Have you seen this: http://support.microsoft.com/kb/918760

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  July 16, 2010 at 2:37 am

  #1193942

  For those too lazy to copy-paste:

  http://support.microsoft.com/kb/918760

  And you're right, that is usually the problem: permissions.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• Colin Betteley

  Hall of Fame

  Points: 3095

  More actions

  July 19, 2010 at 8:24 am

  #1194914

  All,

  Have resolved the issue by moving away frrom a mapped drive and using full file path \\ServerName\Director\AnotherDirectory\etc

  Thanks

  Colin

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  July 28, 2010 at 3:06 pm

  #1199509

  Mapped drives are a bad plan using SSIS, stay away.

  CEWII