Home Forums SQL Server 2005 Business Intelligence Data Flow very slow versus Linked Server RE: Data Flow very slow versus Linked Server
gjackson-671398
SSC Veteran
Points: 289
More actions
June 14, 2012 at 2:51 pm
#1501291
Update - I used the ADO data flows and it brought the time down to 2 minutes versus 1 hour. Not sure what the difference is between OLE DB and the ADO data flow but it made a huge difference in elapsed time.
Thanks,
Greg