I have tried the Import wizard to import data from a view on a separate SQL server. This took approximately 1 hour to load 168,261 rows.When I used a linked server and a Select into statement it took 10 seconds. This is really baffling to me, I thought SSIS would be at least equal to the linked server or a bit faster. No matter how I adjust DefaultBufferSize or BufferMaxRows the elapsed time is one hour. Can someone kindly explain this or provide a suggestion to improve performance to the SSIS data flow?