Cannot use OleDB as the SQL we use have named parameters.

When I change the data source to OleDB O get the error

The data extension OLE DB does not support named parameters.

Use unnamed parameters instead.

Now this is a problem. So I...

For BIDS it is Data Source= ;Network Library=dbmssocn;Packet Size=4096

For SSMS it is Network protocol TCP/IP and Packet Size 4096 bytes.

If there is any other way to get the connection string...

Both BIDS and SSMS are on the same machine connecting to a remote db server.

I explicitly set the connection network protocol to TCP/IP for both.

The duration difference is still there.