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