I have a question on the performance of the SSIS compare to normal load..
its a direct load but when i am doing using an SSIS Package its taking lot of time to load compare to direct load using sql.
the total records in a table is 4M when i load using a sql query to another table it took some 5 mins but when i try doing using ssis it took 5 mins to load 20k records....
can somebody tel me why is this? I am very new to IS!!
View Complete Post