Gustav Brock
Gustav at cactus.dk
Mon Jan 21 10:21:38 CST 2008
Hi Martin Yes, all the usual (default) stuff. /gustav >>> Mwp.Reid at qub.ac.uk 21-01-2008 16:56:57 >>> Is there anything available when you go to create a new project?? Martin Martin WP Reid Information Services Queen's University Riddel Hall 185 Stranmillis Road Belfast BT9 5EE Tel : 02890974465 Email : mwp.reid at qub.ac.uk ________________________________________ From: dba-sqlserver-bounces at databaseadvisors.com [dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Gustav Brock [Gustav at cactus.dk] Sent: 21 January 2008 15:48 To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] SSIS, SQL Server Integration Services, DTS Hi all How do you use SSIS with Visual Studio 2005? I understand that VS is the "new" environment for creating SSIS packages, and that "SQL Server Business Intelligence Development Studio" should be the tool for this. That's fine - I do have that menu entry under the menu "Microsoft SQL Server 2005". However, when I click that, Visual Studio launches - and that's it. No special tools, no wizards, no SSIS-something. Just plain VS. What to do? /gustav >>> Gustav at cactus.dk 18-01-2008 15:40:43 >>> 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