select name, is_rpc_out_enabled
from sys.servers
where is_linked = 1

if is_linked = 0 that is the instance itself

not with standard SSIS methods

Depending on the file you can however use a C# script to parse the file and create the table yourself.
With bulk insert (T-SQL)...

I've seen this happen before - on 2008 R2.
It was possible to generate the table and the index, but the filter definition would not be generated depending on the...

Was correct in assuming that what you asking for was not really the real requirement.

Changing the delimiter alone is not the solution if you have to parse the...

yes assuming that the file is a correctly formed delimited file

read file using old delimiter - split columns - write to new file using new delimiter.

dead...

there are a few options - https://www.techradar.com/news/best-virtual-machine-software - some of these would be mainly for presenters out of premises as it allows all in a single computer.

Not mentioned...

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...