Viewing 15 posts - 1 through 15 (of 19 total)
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...
May 2, 2019 at 1:02 pm
Close enough. He had defined a variable for ServerName and that was overriding my changes.
Thanks for the help.
May 5, 2016 at 10:06 am
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...
March 20, 2014 at 7:45 am
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...
July 12, 2013 at 9:07 am
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...
July 11, 2013 at 10:45 am
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...
July 11, 2013 at 7:36 am
Sure thing. I added this statement:
select Suser_Sname() as [login], USER_NAME() as
and the result was:
July 10, 2013 at 7:16 pm
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...
July 10, 2013 at 3:33 pm
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...
July 10, 2013 at 2:44 pm
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?
October 6, 2011 at 10:04 am
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.
August 30, 2010 at 11:34 pm
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...
August 30, 2010 at 11:03 pm
Please refer to this link for the lock pages in memory issue
For memory usage, have you tried the report "Memory Consumption" ?
One of my servers (the heaviest on...
March 2, 2010 at 2:47 pm
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...
March 2, 2010 at 2:18 pm
Yes, moved PK and cluster to natural key column, and no, this is not a sequence table.
March 1, 2010 at 6:35 am