Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dabooj
Starting Member
7 Posts |
 Posted - 2009-09-24 : 06:37:12
|
| Hi guys, i have a simple task where i want to transfer data from a sql server 2005 view to a sql server 2005 table. The view and table are on the same server.The sql for the view is not too complicated. It is a select statement with a few joins to other tables on the server. The big issue is that there are around 14 million records to transfer. I have created an ssis package which uses an ole db source control & an ole db destination control to transfer the data. This worked but took around an hour to complete the task. I need it to run a lot faster.Does anyone know how to get the SSIS package to to run faster? Is there a different control/object i could use which improves the effeciency of a straight data transfer? Regards,ShujaShuja AhmadSystems Developer |
|
|
coorgun
Starting Member
10 Posts |
Posted - 2009-10-07 : 09:35:16
|
| hi,may be rewriting the view as a stored procedure?best regards,coorgun |
 |
|
|
|
|
|
Transfer data from view to table - fastest method?