A carbocation (/ËkÉËrboÊËkÃ¦taÉªÉn/) is an ion with a positively charged carbon atom.
You can run your package using DTEXEC, and change your connection by passing in a /CONNECTION parameter. Probably save it as a batch so next time you don't need to type the whole thing and just change the datasource as required. You can use the SSIS XML package configuration file. Here is a walk through.
You can determine what your OS connection limit is by catting nf_conntrack_max. For example: cat /proc/sys/net/netfilter/nf_conntrack_max. You can use the following script to count the number of tcp connections to a given range of tcp ports.By default 1-65535.here are a couple of variables to set the max number of connections. Most likely, you're running out of file numbers first. Check ulimit-n. After that, there are settings in /proc, but those default to the tens of thousands.