Select just the columns you need, and if you need them all, "select *" has shown to be faster than simply selecting the table from the drop-down box.Īre your data flow tasks hooked sequentially to each other, or are you running as many as you can in parallel? If you're running them in parallel, try completing one first before moving on to the next one.|||okkk.let me tell a bit more. Whitepaper on Performance Tuning Techniques ()īe sure you are using a SQL select statement in your OLE DB Source. There is a webcast on performance tuning that you may wish to watch:Īnd info here about a performance tuning whitepaper: There are so many "it depends" answers to this that its hardly worth replying. When I have to do this kind of work, I usually just transfer the entire target to a new database and then do my work on my server.|||Īnd way to make it faster.source db in not in my control.so i cant get indexes on it.:( You might need to do a "SELECT * INTO temptable FROM REMOTE.table" and then do your transforms into the real target table on your server. The best performance you will get would be a "Execute SQL Task" and not a Data Task.
It could be your server, their server, network, etc. I need to fetch data into multiple tables from a remote server (ss 2005).so inside a sequence container, i have placed various data flow task.each task in turn gets data from oledb source to oledb destination.there is minimal transformation involved.but the data is huge.and its taking unexpectably long.(im gettin only fresh data.identified by datetime fields of source tables.thats the only check.),Īnd way to make it faster.source db in not in my control.so i cant get indexes on it.:( There are way to many reasons for it to be slow.