July 22, 2011 at 12:08 pm
Hi All,
I am getting error while running the SSIS Package. I am trying to insert Flat File (csv) to SQL Server Table. While transferring the data SQL is showing an error
"[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."
Please suggest what can be the possible solution for this. Thanks for the help in advance.
July 22, 2011 at 12:13 pm
The following link is an article that is a fix for this issue.
http://support.microsoft.com/kb/2496375
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/
July 22, 2011 at 12:20 pm
Hi,
It shows to get a cumelative SP1 for SSIS, but the question is how to get it. Could you please help me how to get it ? Thanks for the help.
July 22, 2011 at 12:43 pm
What version of SQL Server are you running and what SP's and patches have you installed?
Did you recently perform any upgrades before you encountered this error?
I will try and find out if something else could be generating this error.
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/
July 22, 2011 at 12:48 pm
I should have gone with my gut instinct but this sounds more like a permission issue.
Are you running this using your user credentials or the SQL Server Agent Account?
http://www.sqlservercentral.com/Forums/Topic692952-391-1.aspx
What version of SQL Server are you running and what SP's and patches have you installed?
Did you recently perform any upgrades before you encountered this error?
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/
July 23, 2011 at 12:45 pm
Hi,
I am using SQL 2008. I haven't installed any of the updates lately. Please advice how can I insert the csv file in SQL Server.
Note : The bulk Insert is not working on it.
July 23, 2011 at 12:58 pm
gauravin2007 (7/23/2011)
Hi,I am using SQL 2008. I haven't installed any of the updates lately. Please advice how can I insert the csv file in SQL Server.
Note : The bulk Insert is not working on it.
What account are you using?
Are you running the package interactively using your account or via the SQL Server Agent Account?
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/
July 25, 2011 at 8:11 am
Hi,
I am trying to run the report with the SQL Windows Authentication is that you are talking about or is there something else we are talking here ? Please advice.
July 25, 2011 at 8:17 am
Are you running as a Job (SQL Server Agent Account) or as you User Account or another Account?
Does the account have the proper permissions?
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/
July 25, 2011 at 8:18 am
I think the question is this: are you running the package from Visual Studio logged in as yourself, or are you running it via a SQL Server Agent job?
John
July 25, 2011 at 9:19 am
I am trying to run it as a SQL Server Agent R2. And I have the permission to the Server to do everything in the Server I am not the Admin in the Server but have Read and write access in the Server. Does we need anything else to get this working. Thanks for the help in advance.
July 25, 2011 at 9:24 am
In that case, it's the permissions of the SQL Server Agent service account that are important, not the account you are logged on as. Is the CSV file on a different server? If it is, you should use a domain account to run SQL Server Agent and make sure it has permissions on the location of the file.
John
July 25, 2011 at 10:32 am
The CSV File are on My Local Drive It is not on other Server.
July 25, 2011 at 10:32 am
John Mitchell-245523 (7/25/2011)
I think the question is this: are you running the package from Visual Studio logged in as yourself, or are you running it via a SQL Server Agent job?John
Thank you. That is what I was trying to say all along. When I initially hinted at permissions I did not know how job was being run for that information was not provided.
If a package fails is it in the development stage or is it failing as a job using the SQL Server Agent Account?
I have answered many post and in each instance the problem was with the permissions of the SQL Server Agent Account.
If it does not successfully complete SSIS package can you execute it without running it as a job (BIDS Environment)?
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/
July 25, 2011 at 10:34 am
gauravin2007 (7/23/2011)
Hi,I am using SQL 2008. I haven't installed any of the updates lately. Please advice how can I insert the csv file in SQL Server.
Note : The bulk Insert is not working on it.
Can you be more specific than the bulk insert is not working on it?
What error are you getting? What is happening?
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/
Viewing 15 posts - 1 through 15 (of 18 total)
You must be logged in to reply to this topic. Login to reply