Martin W Reid
Mwp.Reid at qub.ac.uk
Mon Jan 21 10:25:53 CST 2008
In my VS 2005 if I select File New Project right at the top of the list is Business Development Project. This is mainly to do with reporting services. 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 16:21 To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] SSIS, SQL Server Integration Services, DTS 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com