Grant Fritchey (10/20/2011)

---

Phil Parkin (10/20/2011)

---

Grant Fritchey (10/20/2011)

---

What about building a drug name mapping table. You run through the data once, nightly, after a load, something, and map the names supplied...

I would setup linked servers on Security_Server to the prod servers and "pull" the data to the Security_Server. Since they are all SQL Server you can just set them...

Seems like a simple OUTER JOIN or EXCEPT to me, if I understand the problem correctly. Something like:

Select

I.*

From

Inventory AS I LEFT JOIN

...

If you want to disable access to the SQL Server for specific protocols then you want to SQL Server Network Configuration, not the SQL Server Native Client Configuration. The...

You need to use a script task to update the value of a variable. Well, you could do an Execute SQL Task too, but you don't need a connection...

It looks like you could do a RUNAS administrator and it will fix itself based on the error msg you posted. Or you'll need to repair the SSMS installation...

Sorry. I don't believe there is a setting anywhere for this. If you are doing this regularly why not do an SSRS report which will treat NULL as...

I don't see you accessing a data source in this script. Are you getting an error?

Sounds like permissions. What account is being used to run the SSIS package? How is the linked server security setup?

I have to disagree Remi. Full Text would probably work, but doing the parse Peter mentioned at the end of his original post would probably be faster than the...

Can you post the definition of the view?

Clearly, if the table definitions you have posted are correct the issue has to be in the view.

Based on what you are showing here, TransactionNumber in one of the objects has to be VARCHAR and has non-integer data in it.

Or since you mention a view, there has...

I think it really does depend. As has been mentioned, sometimes when troubleshooting an issue you need to have an exact copy of production to be sure you are...

Are you feeling lucky, Pants?

Well, figures I'd get to the dead thread.