Reputation
6,150
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 17 46
Newest
 Good Answer
Impact
~345k people reached

Mar
17
comment any advantage or disadvantage to have mysql 5.6 on a linux server over on a window server
Windows uses \ as a directory separator. Linux uses / as a directory separator
Mar
17
comment How can I invoke an SSIS package from SQL Agent, via T-SQL, using a proxy
FWIW, I happen to script out the create_execution procedures and yeah, I'm guessing somewhere with all the impersonation and reverts in there things go poorly. I suspect Agent has a different mechanism, similar to a RunAs that allows it to not get fouled up whereas the TSQL impersonation does. shrug
Mar
13
comment Run SSIS Package as different user
Doesn't this assume that they are using SQL Server Authentication when they specifically mentioned "run as a different windows account and not a SQL account."
Mar
13
answered Run SSIS Package as different user
Mar
13
awarded  Notable Question
Mar
12
comment Efficently Remove 90% of a table's data
Contributing nothing of value except that your 10% reminded me of this comic
Mar
10
revised How do I get the difference in minutes from 2 timestamp columns?
common sense for dummies
Feb
27
reviewed Close SQL CLR in MySQL?
Feb
27
reviewed Close How to reinstall a legacy DB2 Server 7.x for Linux?
Feb
27
reviewed Leave Open SSIS Merge Join Error
Feb
27
reviewed Close Too big database file 90GB
Feb
26
answered One SQL Server. One SSIS. Two versions of DTExec.exe?
Feb
26
comment SSIS Transaction Set to Required giving error
You marked your previous question on the same topic as resolved. I assume it's still going to be a DTC issue.
Feb
25
comment Error while executing SSIS package which contains Script component through SQL Server Agent Job
What does the script do? Smells like it's talking to a web service. Does that service require authentication and if so, does the account that is executing the package have permissions? Does it expect a wsdl at some location there isn't one? Did the devs create a custom DLL that needs installed on the server? Has this ever worked on the machine in question? Does it work anywhere?
Feb
25
awarded  Cleanup
Feb
25
revised Trying to attach a .mdf with missing .ldf
rolled back to a previous revision
Feb
25
revised Trying to attach a .mdf with missing .ldf
Pushing useful commentary into the question
Feb
24
revised When should a primary key be declared non-clustered?
No need to point out that you haven't read the other answers
Feb
24
revised Trying to attach a .mdf with missing .ldf
no thanks needed
Feb
24
revised How do I set up a Derived Column Transformation to get row number in SSIS 2014?
added 9840 characters in body