RE: Import Warning Message

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Med,

I had the same problem when I set up a proxy account to use the ssis service
through the SQL server agent.

I deleted the proxy account and it seemed to work fine for running a
straight import
I re-created the proxy account and

Regards,

Andrew

"Med" wrote:

Hi,

My Source DB is on a hosted remote sql server 2005. I created an exact
database on my local SQL 2008 Developer. I use SSIS to import data from
remote SQL 2005 to local DB (SQL 2008 Dev) , which deletes rows in
destination tables and allows Identity Insert. As far as I can see, all
rows of all tables are imported, but I also get the following Warning:

Warning 0x80049304: Data Flow Task 1: 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.

I have googled this problem, but couldn't find any useful answer. I also
thought this might be permission issue and I used my local sa login, but
still got the warning.


Does anyone know what is causing this warning?


Kind Regards


Med


.

Relevant Pages

  • Re: SQL Server Agent Proxy Account / XP_CMDSHELL
    ... The proxy account is unrelated to SQL Server object permissions. ... must have xp_cmdshell execute permissions when xp_cmdshell executed ... execute permissions on xp_cmdshell. ...
    (microsoft.public.sqlserver.security)
  • Re: installing SQL 2008 x64 on Vista Enterprise x64-Firewall warnings
    ... I can't see the warning at the moment but my recollection is that is just warns you that the firewall is on and you might have to configure it. ... Since setup doesn't know what you want to do with SQL Server it can't tell if you have configured it correctly. ... How can I get rid of this warning and continue with my installation? ... 135 TCP - SQL Server Integration Services ...
    (microsoft.public.sqlserver.setup)
  • Re: Cscript from a SQL Stored Procedure?
    ... You may want to check the proxy account. ... >that uses SQL SERVER 2000 as it's database. ... >Basically we are trying to add code that calls the .vbs script so that when ... >doesn't seem to execute. ...
    (microsoft.public.sqlserver.server)
  • Re: Stupid SQLCE warning message
    ... you just pretend you did not see ... >> I am trying to replicate SQL Server Database to SQLCE and solving one ... >>>Incorrect Deployment Warning ... >> How can I ignore this messae and start application in debug mode from ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: BULK INSERT ignores UNIQUE index with IGNORE_DUP_KEY set?
    ... you get a warning and not an error - is that correct? ... SQL Server only emits a warning. ... CREATE TABLE blamblam ... Duplicate key was ignored. ...
    (comp.databases.ms-sqlserver)