All, I was experimenting with BulkInsert Task in a SSIS package and I’m unable to get it to work. We have two SQLServers, (A) Database SQLServer - NYCSQL20 (B) SSIS SQLServer – NYCSSIS20. NYCSSIS20 hosts all the SSIS packages and NYCSQL20 hosts the databases. On NYCSSIS20, I copied the csv file nycdw7p020.csv into D:\SSIS\Working\. On NYCSSIS20, the SQLServer service runs under local system credentials and the SQLServer Agent service runs under NYCDomain\NYCSQLAGT account. On NYCSQL20, both the SQLServer service and SQLServer Agent service run under NYCDomain\NYCSQLDEV account. When I first ran the job, the job failed with this error - Cannot bulk load because the file "D:\SSIS\Working\nycdw7p020.csv" could not be opened. Operating system error code 3(The system cannot find the path specified) even though the file does exist at the specified location. After reading through the below details in BOL, I created a share and ran the job and this time the error is slightly different from the earlier error Cannot bulk load because the file "\\NYCSSIS20\ssis\Working\ nycdw7p020.csv" could not be opened. Operating system error code 5(Access is denied.). ms-help://MS.VSCC.v90/MS.VSIPCC.v90/MS.SQLSVR.v10.en/s10is_1devconc/html/c5166156-6b4c-4369-81ed-27c4ce7040ae.htm < The source file that the Bulk Insert task loads can be on the same server as the SQL Server database into which data is inserted, or on a remote server. If the file is on a remote server, you must specify the file name using the Universal Naming Convention (UNC) name in the path.> Does anyone know what I’m missing? rgn

Perhaps this is the way you set up your job to run. My thinking the Agent does not run under the NYCDomain\NYCSQLAGT account or it does not posses enough rights over the local file system. Make sure you set your job to run as described here: http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx Arthur My Blog

Additional Info - The SQLServer environment is SQLServer 2008. I also tested this package on our development SQLServer (which hosts both Database server and SSIS server) and the package works successfully

I think it must be still the rights (I hope the path is correct) Arthur My Blog