Basic question of SSIS

• dva2007

  SSCertifiable

  Points: 7707

  More actions

  February 27, 2009 at 2:46 am

  #126734

  Hello friends,

  I have worked with DTS (very basic) in SQL Server 2000. I have designed just basic DTS like transferring excel file to sql table or table to excel file etc. It doesnt include anything like activex or code etc.

  I am just wondering what skills should we haev to write complex SSIS in terms of programming. it is including VB script, VBA, .net ???

  I am always working which SSRS which needs skills in TSQL along with Reporting services but hardly work with SSIS.

  We have lots of complex DTS in 2000 and needs to transfer into SSIS packages so just thinking about writing from scratch if it will not migrate easily. (as only simple DTS will transfer into SSIS by wizard).

  Can you please share your views?

  Thanks,

  Vijay

• Jack Corbett

  SSC Guru

  Points: 184393

  More actions

  February 27, 2009 at 7:18 am

  #951151

  If you are doing a lot of scripting in your DTS packages then you will need to rewrite those scripts and to do that you need basic VB.NET skills.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question