SQL Job does run but SSIS package errors out

• zdonev

  SSC Journeyman

  Points: 79

  More actions

  January 21, 2009 at 4:19 pm

  #126928

  Hi,

  here is a quick info about my environment setup:

  Developer user: domain\zoran

  SQL Agent Account: domain\zoran

  UNC path: \\testserver\Exportfolder\coitem.csv

  I developed a package which runs fine under BIDS but as soon as I run it through a job I get following message:

  Executed as user: domain\zoran. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:32:18 AM Error: 2009-01-21 09:32:19.19 Code: 0xC0202070 Source: Import_coitem Connection manager "coitem_flat_file" Description: The file name property is not valid. The file name is a device or contains invalid characters. End Error DTExec: The package execution returned DTSER_SUCCESS (0). Started: 9:32:18 AM Finished: 9:32:19 AM Elapsed: 0.844 seconds. The package executed successfully. The step succeeded.

  I tried to encryption with password and to load the package to the server. Nothing worked so far.

  I have full right to the unc path. Is there an issue with SSIS and UNC paths because it works when i set the import path to be locally (C:\..)

  What do I miss?

  I appricate any help! I am strugeling a hole day whit this porblem.

• VG-619426

  Hall of Fame

  Points: 3914

  More actions

  January 21, 2009 at 5:04 pm

  #930793

  Hi,

  Where is the file \\testserver\Exportfolder\coitem.csv located ?

  Like if it is in D drive, then I would give UNC path like this:

  \\testserver\D$\Exportfolder\coitem.csv

  VG