i am trying to run SSIS package for loading a flat file content to database. but i am getting an error saying "Cannot bulk load because D:\ExcelLoading\NewDataFiles\Data\BC_FL_ZIP_0512.txt could not be opened. operating system error code 3 "

When you execute this command on a sql server, it's looking for the file on your sql server, and not on your local box. So if you haven't already, you must put the file on your sql server, and then issue the command with the file-path on your sql server. If you already have the file on your sql server, then you simply got the file path wrong. Thanks, Saikat

Are you sure that the account that you're running the packages under has the proper permissions to the folder? Are you running from Visual Studio, or from SQL Agent? Regards, JasonMCITP BI Developer - MCTS SQL Server (http://bichopsuey.wordpress.com/)

thanks alot it's working now.