July 25, 2011 at 10:42 am
gauravin2007 (7/25/2011)
The CSV File are on My Local Drive It is not on other Server.
By default the SQL Server Agent Account is not going to have permissions to your PC.
I don't believe that you want to deploy a package to production that references a file on your local PC?
If you move the file to the Server that the SSIS package executes on then the package should execute.
If you place the file on another server then the SQL Server Agent Account must have permissions to read the file if only a read operation is being performed.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 1, 2011 at 11:18 am
This Problem is not on 1 Project. I am getting this on every Project Please suggest what should I do.
[SSIS.Pipeline] Warning: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console.
August 1, 2011 at 12:38 pm
If you have a permissions issue on the account that you are using to run the packages every package will fail.
You have not answered any of the questions that you were asked and I assume that you have not tried what was suggested.
If you provide additional information than you increase the probability that you will get a solution to your problem.:-P
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 2, 2011 at 3:24 pm
Thanks It did worked with the Admin Rights 🙂
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply