I am averaging about 1000 records loaded an hour. My software is:
Windows Server 2008 R2 Standard x64
SQL Server 2008 R2 standard x64
The Windows Server is a Quad Core and has 16 Gig of Ram. This process used to take 4 hours longer, until we moved to this new server, which the 1000 records per hour still stinks. I am not a newby, but am somewhat to SSIS. This is a SQL Server to SQL Server and I feel that If I had done all this with stored procedures and server cursors I would have been better off. Are there any known performance gotchas that I should be aware of. This load time is so rediculous that I must be doing something wrong?