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 |
|
varalakshmi
Yak Posting Veteran
98 Posts |
 Posted - 2008-01-03 : 01:55:59
|
| Hi,I created a package that loads more than 9 crore records in to the destination table. It takes hours to complete a single dataflow.Is there any way to increase the performance of the package? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-03 : 04:25:05
|
| You can try using fast load option in OLEDB destination or even use SQL Server Destination connection. |
 |
|
|
varalakshmi
Yak Posting Veteran
98 Posts |
Posted - 2008-01-03 : 05:03:33
|
| I used the fast load option already.I tried using SQL Server Destionation connection.But i'm getting the following error.[SQL Server Destination [15909]] Error:The thread for the SSIS Bulk Insert task failed initialization. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-04 : 08:59:42
|
| Is this the only error you are getting? Whats your source? |
|
|
|
varalakshmi
Yak Posting Veteran
98 Posts |
Posted - 2008-01-07 : 07:15:23
|
| Yes. It is the only error.The source table is from a remote sql server database.The package is also developed in another remote machine using citrix metaframe connectivity.... |
|
|
|
|
|
|
package performance