Yep. The SQL Server Destination can only be used to insert into a local server as it utilises a shared memory connection. It therefore can have a slight performance gain, but for flexibility/portability, I'd stick with an OLEDB fast load.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply