Cant try it at the moment but in any case a word of advise.

ACE driver with its SP1 is the most complete at the moment if not using...

I would try out the following
on dataflow properties

• set defaultbuffersize to 100000000 (nearly max)
• set defaultbuffermaxrows to 100
• set blobtempstoragepath to a folder on a drive with enough space
• set buffertempstoragepath to a...

create another master SP
parameter sp_level int

this requires that SP2 and SP3 do not call the previous sp, but rather depend on it having been executed previously and...

why 32 bit? all newer servers are 64 bit and unless you have a particular need for a driver for which there isn't any 64bit version I do not see...

assuming that you have a VM then look at your host cpu sharing stats and disk IO quota
other things that do affect performance are power saving settings. for SQL...

I may be wrong, but all attempts I made at executing a cmdexec step only the first line on the command works.

e.g. no multiple lines are possible so...

and what have you tried so far?

This subject has been discussed over and over and there is plenty of info both here on this forum and on the...

works with any sql database. does not require azure/cloud

should be able to do any T-SQL required - no designers like SSMS but those do not prevent doing the work.. just makes it that people need to know what...

https://www.macsqlclient.com/
never used it, don't know if it is any good

or  https://docs.microsoft.com/en-us/sql/azure-data-studio/download?view=sql-server-2017 - forgot that this new thing existed

Should not be to hard to format the sql but...

This gives the desire result for the supplied data - as no rules were defined I assumed the following

have a look at http://blog.bittersweetryan.com/2012/01/using-oracles-free-sql-developer-as.html?m=1

you will also need jTDS https://sourceforge.net/projects/jtds/ (mentioned on the link above) and follow a few steps

care must be taken with the exact...

theres a connection string setting for that. and another JAR that may be required as far as I remember.

Going to try and find it out as I did...