Arthur Fuller
fuller.artful at gmail.com
Fri Jan 18 09:21:16 CST 2008
Gustav, You can still run DTS pkgs in SQL 2005 but yes, DTS has been deprecated. MS bought DTS from a third party way back when (1998) and rolled it into SQL 2000, but then rewrote it from the ground up for SQL 2005. There is still DTSRun in 2005 and also a migration wizard to get you from A to B, but DTS is, as they say, deprecated. (That's kind of like decapitated but more graceful.) For your immediate client's needs, you have a few alternatives. Stick with DTS and do the imports there; create ODBC links and do a classic Access-style import. For starters. More if required. hth, A. On 1/18/08, Gustav Brock <Gustav at cactus.dk> wrote: > > Hi all > > I'm new to DTS and thought I had a job for this for a scheduled job for > importing/exporting some data. > Then this page: > > http://msdn2.microsoft.com/en-us/library/ms141026.aspx > > tells that: > > Integration Services replaces Data Transformation Services (DTS), which > was first introduced as a component of SQL Server 7.0. > > Is that so? > And even worse, this page: > > http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx > > indicates that SSIS is not available with the SQL Server Express edition. > So our client will have to purchase a SQL Server Standard Edition? > > Or would there be another simple method to run a scheduled job? It's only > about retrieving data from some Access tables and writing some others to > another database without user intervention. > > /gustav > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >