Post reply

SSIS or SP

  • October 28, 2009 at 12:36 am

    #206075

    Hi

    Which is faster in execution SSIS or SP when I need to transfer data from Db1 to Db2 (Both on same SQL Server and processing nearly million of records).

    For my try and testing I have been seeing that my SSIS package takes about 30 minutes to transfer 10000 records while Sp takes much lesser time.

    Any thoughts!!!

    Thanks

    K

  • October 28, 2009 at 1:54 am

    #1071573

    Can you be more specific about the data transfer - do you just copy the data, or do you perform any operations on that data? Any other details are welcome...

  • October 28, 2009 at 2:00 am

    #1071574

    There are some operation being performed like conversion of datetime, datatype, substring, trim , concatenation etc.

  • October 28, 2009 at 2:28 am

    #1071584

    Sp will be faster as they are on same computer so all precompile and other things for ssis can be avoided.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply