Implemeting DTA in SSIS

• Diyas

  SSCarpal Tunnel

  Points: 4851

  More actions

  June 13, 2012 at 10:14 pm

  #259767

  Hi,

  Can we implement database tuning advisor on SSIS task.like i am planing go through automation task.

  any one provide the details for this

• Robert Davis

  One Orange Chip

  Points: 28027

  More actions

  June 15, 2012 at 7:39 am

  #1501650

  No. Database Engine Tuning Advisor tunes the database engine. SSIS is a different engine.

  ---

  My blog: SQL Soldier[/url]
  SQL Server Best Practices: SQL Server Best Practices
  Twitter: @SQLSoldier
  My book: Pro SQL Server 2008 Mirroring[/url]
  Microsoft Certified Master: SQL Server, Data Platform MVP
  Database Engineer at BlueMountain Capital Management[/url]