Take the 2-minute tour ×  this is my first question, I've
searched a lot of info from different sites but none of them
where conslusive.  Problem: Daily I'm loading a flat file with
an SSIS Package executed in a scheduled job in SQL Server 2005
but it's taking TOO MUCH TIME(like 2 1/2 hours) and the file
just has like 300 rows and its a 50 MB file aprox. This is
driving me crazy, because is affecting the performance of my
server.  This is the Scenario: -My package is just a Data Flow
Task that has a Flat File Source and an OLE DB Destination,
thats all!!! -The Data Access Mode is set to FAST LOAD. -Just
have 3 indexes in the table and are nonclustered. -My
destination table has 366,964,096 records so far and 32 columns
-I haven't set FastParse in any of the Output columns yet.(want
to try something else first)  So I've just started to make some
tests:  -Rebuild/Reorganize the indexes in the destination
table(they where way too fragmented), but this didn't help me
much -Created another table with the same stru