Why ADO.NET for a SQL Server Destination? I normally use OLE DB Destination with Fast Load option.

Is the destination database in simple recovery model?

Are the database files correctly sized?

Any transformations in the data flows?

Did you try out different buffer sizes in the data flows?

About how much data are we talking here?