How can I make a DTS in MSSQL Server Management Studio Express
I know how to do that in SQL Server Enterprise Manager.
Is this restricted in the express
Thanks.
Data Transformation Services
Hot Topic
- Dummy dimension for passing parameters
- Transaction Log does not truncate and shrink using a SQL Server 2005 Maintenance Plan
- Stumped...JOIN with a DatePart on a field name...
- Clearing Single User Mode/lock
- embed office document
- DB Owner & SqlDependency Problem
- SSIS COLOur Settings
- Solution Explorer in SQL Server Management Studio
- SQl Server Management Studio Express problem
- any known problems SQL 05 with sharepoint 2.0 SP1 and .NET framework 2.0
SQL Server
- Restore Database from file
- Problems installing SQL Server 2005 SP 1
- Error Handling with Execute Package Task
- Transform data to excel sheet or xml
- Deploy/Database Connection error
- Display a report in fullscreenmode
- SSIS instead of raw T-SQL
- re-establishing mirror
- Control Flow design question
- Dyanamic Parameters
Data Transformation Services
Julian Heal
SSIS (aka, DTS) is only available with SQL Server 2005 Standard Edition and above. With Standard Edition, you can use Business Intelligence Studio to make SSIS packages.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
mbauman
I'm not fully certain, but the original poster likely wasn't talking about SSIS. Most people no longer mistakenly call SSIS by the name DTS. The question is "How can I make a DTS in MSSQL Server Management Studio Express " I took this to mean - "How do I make a DTS package for SQL 2000 using SQL 2005's Managment Studio Express "
Microsoft has released the Feature Pack for SQL 2005. In it, there is an item called Microsoft SQL Server 2000 DTS Designer Components.
http://www.microsoft.com/downloads/details.aspx familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
It is unclear whether or not this runs in the Expess studio, but I haven't gotten it to work. I believe it will likley run in the full version of Managment Studio, but I haven't tried. Anyone have any success with DTS Designer Components and the Express edition