Eric M Russell (4/24/2013)
I am using SSIS 2008. The task is following.
1: Execute a storted proc and using the output create a CSV file.
2: this CSV file need to be copy to network drive e.g. (\\servername\datafolder)
please suggest what is the easiest way to acheiev this.
You may already know this, but depending on how the SSIS package is executed (scheduled in SQL Agent job, run manually from SSMS, etc.) it could run either locally on your PC or remotely on the server. Also, insure that account under which the package will execute has access to the file system and network resource.http://blogs.msdn.com/b/michen/archive/2006/08/11/package-exec-location.aspx
Good advice indeed. If everyone knew this, there would be approximately 12 million fewer Internet pages containing requests for help along the lines of: "My package runs fine in BIDS but fails when scheduled as a SQL Agent job"!
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.