SQL Job does run but SSIS package errors out

  • 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.

  • 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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply