I've always used the MySQL ODBC drivers to connect to MySQL from SSIS.

Just remember that if you use a 32 bit driver you need to run a 32 bit SSIS...

Close enough. He had defined a variable for ServerName and that was overriding my changes.

Thanks for the help.

I got to see others eat their lunch ( I don't like the food there :-D).

On the corrupt side of the answer, I have seen a snapshot become suspect at...

Very elegant solution, but I have just 2 concerns.

One is that the definition of the string is varchar(8000), but the master table has values only up to 2047.

The other I'm...

I appreciate the help anyway. If there is anything I'm not telling you is because I do not know it.

I'll keep trying to find an explanation or a way to...

Gail - you are correct, and I assumed wrong. It's not running as "sa", I just thought that it was.

So I ran this SQL on that database (to get default...

Sure thing. I added this statement:

select Suser_Sname() as [login], USER_NAME() as

and the result was:

login ...

Good question. There is one SQL Agent Proxy defined, but only for SSIS and OS steps.

The step this is failing on is a regular T-SQL step, calling one stored procedure...

That was what I thought too, but when the job executed (as "sa") it actually accessed the object pointed by the synonym, that is on the RPT schema, not the...

Hi Steve,

I couldn't find where to register to the event you mentioned. I could not find any link to RSVP. Could you send one to me?

Thanks

Filipe

Please don't get me wrong. If SQL finds that either first name or last name with the parameters passed will give you a good plan, it will use that index.

The...

I have to agree that this is a very elegant solution, but can be very bad for performance.

Imagine you have a table with 1 million names in it, and you...

Please refer to this link for the lock pages in memory issue

http://www.sqlservercentral.com/articles/Lock+Pages+in+Memory/67975/

For memory usage, have you tried the report "Memory Consumption" ?

One of my servers (the heaviest on...

One thing you forgot to mention (or I did not see) is the version of SQL. Is it Enterprise or Standard? Standard Edition will not take the lock pages in...

Yes, moved PK and cluster to natural key column, and no, this is not a sequence table.