Upgrade form DTS to SSIS
Dear All
can i upgrade from DTS on sql Server 2000 to SSIS on SQL Server 2008 and what is about compatability?
thanks
ahmed mosa
[160 byte] By [ahmedmosa] at [2008-3-1] 
«« 2 important questions
»» How to get a Remote Connection to SQL Server Express from VB 2005 Express in a Network PC that i
»» How to get a Remote Connection to SQL Server Express from VB 2005 Express in a Network PC that i
Sure, but your DTS packages won't get "converted." You'll have to use the Execute DTS 2000 Package task in the control flow, or there's a migration wizard, I believe that will build that for you.
Just know that your best option is to rebuild your DTS packages in SSIS.
PhilBrammer at 2007-10-2 >
SQL Server Katmai Hot Topic
- Code Insight?
- Optimizing Data Warehouse Query Performance Through Bitmap Filtering...
- Seperate Process
- Support for nested tables?
- Cannot install Workstation components, fails on report server upgrade
- SQL Server automatic encryption
- Optimizing Data Warehouse Query Performance Through Bitmap Filtering...
- 2005 vs 2008 NOEXPAND hint behavior
SQL Server Katmai New Topic
- ActiveX script task issues in SQL 2008
- Microsoft.SqlServer.Management.Smo.PercentCompleteEventHandler?
- SQL Server Setup CTP July Build after Visual Studio 2008 B2 doesn''t work on Vista 64 bit
- SSIS enhancements for Data Cleansing?
- "query must be a string literal" - does Katmai remove this restriction ?
- SQL Litespeed not installing
- Settings on server 2003 and SQL Server
- Data SQL Server
SQL Server Katmai
- .NET Framework inside SQL Server Katmai
- Data Mining for SQL Server Katmai
- SQL Server Katmai Analysis Services
- SQL Server Katmai Data Access
- SQL Server Katmai Data Warehousing
- SQL Server Katmai Database Engine
- SQL Server Katmai Disaster Recovery and Availability
- SQL Server Katmai Documentation
- SQL Server Katmai Express
- SQL Server Katmai Integration Services
- SQL Server Katmai Replication
- SQL Server Katmai Reporting Services
- SQL Server Katmai Search
- SQL Server Katmai Security
- SQL Server Katmai Setup & Upgrade
- SQL Server Katmai SMO/DMO
- SQL server Katmai Spatial
- SQL Server Katmai Manageability & Tools
- SQL Server Katmai XML
- SQL Server Katmai Service Broker
- Transact-SQL for SQL Server Katmai
Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech
Site Classified
- SQL Server
- Windows Forms
- .NET Development
- Visual Basic
- Visual Studio
- Visual Studio Team System
- Visual Studio Orcas
- Visual Studio Express Editions
- Software Development for Windows Vista
- Visual C#
- Visual C++
- Smart Device Development
- SharePoint Products and Technologies
- Feedback for forums and MSDN websites
- Game Technologies: DirectX, XNA, XACT, etc.
- Visual Studio Tools for Office
- Windows Live Developer Forums
- Microsoft ISV Community Center Forums
- Internet Explorer Development
- Visual FoxPro
- Windows Search Technologies
- Audio and Video Development
- Architecture
- Commerce Server
- Gadgets
- Microsoft Robotics Studio
- Community Chat
- BizTalk Server
- Visual J#
- Windows Networking Development
- Silverlight (formerly WPF/E)
- Popfly
- SQL Server Katmai
- Connected Services Framework
- Office Live Development
- Customer Care Framework
- Incubation Technologies
- Software Engineering Discussion
- System Center
- Software Licensing and Protection Services
- Visual Studio Rosario
- Small Business Application Development
- Office
- Windows Server 2008
- JScript
- Storage Platform – Core
- Misc