Hi, I am importing an excel file in a table thru Import Data Task, but the trigger on the table doesn't fire :( Is there a way I can tell SQL Server Exp. Edition 2008 R2, to fire the trigger on the destination table with the Import Data Task? Or is there any other way to import the excel file into a table so that the trigger on the table fires? Thanks. Neeraj
Thanks Sri, but "Use Fast Load" option still doesn't fire the trigger. I am looking into the Integration Service Project! Is that the place I am supposed to check or is there any other place which has "Use Fast load" option.