none
ssis help RRS feed

  • Question

  • Hi I have one doubt in ssis
    how to give performance while loading data from sql serve to postgres

    sql server table : emp have 20 lakhs records with 20 fields

    postgres server : emp  

    I want load data from sql serve to postgres using ssis 
    here no business logics  and no data conversion.its 
    tasking more than  20 hours 

    system ram is : 8 gb
    odbc batch size : 1000


    could you please tell me how to improve performance while loading data from sql serve to postgres using ssis package
    Friday, May 22, 2020 5:28 PM

All replies