Couple of SSIS questions

• tripower

  SSCrazy

  Points: 2035

  More actions

  July 10, 2009 at 5:01 am

  #208111

  If I have a multi-table migration is it best to divide each table into it's own Data Flow Task or should I put all of the tables being migrated into the same Data Flow Task?

  Also, I am using a website to call an SSIS package. I wanted to know what kind of feedback I can receive back from the SSIS call and display it on the ASPX page? I am assuming there would be an asynchronous call with some sort of progress indicator. Has anyone done this?

• Hari.Sharma

  SSCertifiable

  Points: 6904

  More actions

  July 13, 2009 at 3:35 am

  #1023747

  AS long as there is no dependencies between those tables, you can use same Data Flow Task and apply Parallel Transformation.

  But if the tables are dependent, we should avoid this practice.

  I am sorry for your next question as I am not much aware about ASP.NET

  Cheers,
  Hari
  Tips & Tricks for SQL BI Developers