I am extracting from Sybase into a SQLSERVER 2000 table. How do I
goverride the sql governor within the pump step. The error I'm getting
is

Step Error Description:The task reported failure on execution.
(Microsoft OLE DB Provider for SQL Server (80004005): The query has
been canceled because the estimated cost of this query (3670) exceeds
the configured threshold of 500. Contact the system administrator.)
Step Error code: 8004043B

Doing a global increase in the governor will not be allowed by the
administrator as this job is running during prime time.

thanks

Lookup the SET QUERY_GOVERNOR_COST_LIMIT option in SQL Server Books Online.


--
Darren Green
http://www.sqldts.com


"Sharon L." <sharonlockhart (AT) hotmail (DOT) com> wrote

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Putting in the overrode on the query governor just give an invalid
transformation error. I think its because the select command is for
sybase and the set for governor is sqlserver. It thinks the set needs to
be transformed.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

If it is the destination that is SQL Server and hence it is governed, then
obviously you ill need to ensure the command is issued against the same
connection. Try adding an Exec SQL Task with the command in before the
DataPump. Alternatively just turn off the governor all together.

--
Darren Green
http://www.sqldts.com

"Sharon Lockhart" <sharonlockhart (AT) hotmail (DOT) com> wrote