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

Hi Martin

Oh, right (or left it is) - I have been starring at the right pane only ... Thanks!

And right, reporting items only - too sad. I have to install the Standard version and I was about to but Office 2007 have eaten up my diskspace.

Have you done any work with SSIS packages?

/gustav

>>> Mwp.Reid at qub.ac.uk 21-01-2008 17:25:53 >>>
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