Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS package failure on renameing files Error code: 1073548540 Expand / Collapse
Author
Message
Posted Monday, April 22, 2013 10:44 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, July 17, 2014 2:00 PM
Points: 230, Visits: 237
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
Post #1445067
Posted Monday, April 22, 2013 10:51 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:35 AM
Points: 5,024, Visits: 11,754
If E: is not a local drive on the server, I would try using a UNC file path instead.


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1445070
Posted Monday, April 22, 2013 12:04 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, July 17, 2014 2:00 PM
Points: 230, Visits: 237
Thanks Phil for quick reply.

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

-Puja
Post #1445099
Posted Tuesday, April 23, 2013 11:16 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, July 17, 2014 2:00 PM
Points: 230, Visits: 237
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!
Post #1445591
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse