Can we create DTS Package in DTS package in SQL Server 2005 or higher version?

 Posted by Lakhangarg on 2/3/2010 | Category: Sql Server Interview questions | Views: 12417
Select from following answers:
  1. Yes
  2. No
  3. Don't know
  4. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Puneet20884 on: 2/4/2010
http://social.msdn.microsoft.com/Forums/en/sqlgetstarted/thread/e4729205-87cf-4816-8dea-5c5289c592af
Posted by: Lakhangarg on: 2/4/2010
the functionality of SSIS is similar to DTS. but SSIS Package is not a DTS Package.
As if it will be same as of SSIS then why we need to migrate DTS Package to SSIS in 2005. Some times it can be achieved with tool (Migration) but for some cases we need to manually change the DTS Package to run it as SSIS.

Login to post response