Post reply

SSIS package failure on renameing files Error code: 1073548540

  • April 22, 2013 at 10:44 am

    #274192

    Hi,

    I am getting following error when package is executed from BIDS:

    Error: 0xC002F304 at File System Task, File System Task: An error occurred with the following error message: "Could not find file 'E:\Import\'.".

    Error received through send mail task:

    Error code: -1073548540

    Error description: An error occurred with the following error message: "Could not find file 'E:\Import\'.".

    Steps followed:

    1. Created an SSIS package to load .txt and .csv files, perform insert/update/delete operations

    2. Rename files before loading new data. (fails here)

    Development environment:

    SQL Server Version: SQL Server 2008 R2 SP2 (64-bit)

    OS: Windows Server 2008 R2 Standard SP1 (64-bit)

    Created BIDS project on server (logged in with my domain account)

    Also gave full permissions (SQL server account, SQL agent account, my domain account) on parent folder containing SSIS project and export folder.

    Tried Executing package from BIDS, File system and SQL Server (after importing)

    Please let me know where am I going wrong.

    Verified file task mentioned on :

    http://help.pragmaticworks.com/dtsxchange/index.htm#page=FAQ%20-%20How%20to%20loop%20through%20files%20in%20a%20specified%20folder,%20load%20one%20by%20one%20and%20move%20to%20archive%20folder%20using%20SSIS.htm

    PS: BIDS project created in user profile and executing from same (this was failing), so moved to server drive and changed all paths accordingly (still failing).

    Same works successfully on my laptop.

    Thanks in advance.

    Any suggestions are very much appreciated.

    -Puja

  • April 22, 2013 at 10:51 am

    #1608760

    If E: is not a local drive on the server, I would try using a UNC file path instead.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • April 22, 2013 at 12:04 pm

    #1608787

    Thanks Phil for quick reply.

    E: drive is local to SQL box. Gave path as \\servername\e$\Import

    Still not working 🙁

    -Puja

  • April 23, 2013 at 11:16 am

    #1609191

    Its working fine. Was using wrong source path variable. Also have added SQL service account and agent account as admin on local drive.

    Thanks once again!

Viewing 4 posts - 1 through 3 (of 3 total)

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