[dba-SQLServer] SSIS, SQL Server Integration Services, DTS

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




More information about the dba-SQLServer mailing list