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

Gustav Brock Gustav at cactus.dk
Mon Jan 21 09:48:09 CST 2008


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






More information about the dba-SQLServer mailing list