SQL Server Integration Services
All questions related to SSIS, transforms/data flow, control flow, and other related topics.
Announcements
SQL Server 2008 SP1 released
Ed LehmanMSFTWednesday, April 08, 2009 3:44 PMService Pack 1 for SQL Server 2008 will be available today for customers. The Service pack is available via download at http://www.microsoft.com/downloads/en/default.aspx and is primarily a roll-up of previous cumulative updates, quick fix engineering updates and minor fixes made in response to requests reported through the SQL Server community. While there are no new features in this service pack, customers running SQL Server 2008 should download and install SP1 to take advantage of the fixes which increase supportability and stability of SQL Server 2008.
Customers have no reason to wait to upgrade to SQL Server 2008 and many are already taking advantage of SQL Server 2008 as a smart IT investment. In fact, there have been over 3 million downloads of SQL Server 2008 since the RTM in August. With this Service pack, Microsoft is introducing 80% fewer changes to customer configurations compared to previous SQL Server Service Pack releases. This remarkable decrease is a testament to a revised product development process and updated servicing strategy that is focused on ease of deployment while keeping customer environments stable.
With this service pack, Microsoft has made investments to ease deployment and make management of service packs more efficient. Key improvements in SP1 include Slipstream, Service Pack Uninstall and Report Builder 2.0 click-once deployment.
o Slipstream allows administrators to install SQL Server 2008 and Service Pack 1 in a single instance. This decreases the total time for an installation, including a fewer number of reboots thereby increasing productivity and deployment availability.
o Service Pack Uninstall allows administrators to uninstall the service pack separately from the database release. This feature also improves DBA productivity, reduces the cost of deployment and improves overall supportability
o Report Builder 2.0 Click Once improves the existing SQL Server end-user report authoring application by easing deployment to business users
To download the SQL Server 2008 Service Pack 1, please click here.
For more information on SQL Server 2008, please click here.
Filtering and SortingUse these options to narrow down the question and discussion list.
- 1019664

FAQ - SSIS Information, Webcasts, Tools, Add-ons, etc...
Phil BrammerMVPMonday, November 26, 2007 5:55 PM - 0794

POSTING TIPS - source code, screen images, details within...
Phil BrammerMVPFriday, October 16, 2009 9:43 PM - 628

Join and Group By on table fields of different databases (Merge Join)
VULonestar 38 minutes ago - 376

how to create excel file?
collie12 Saturday, November 21, 2009 9:07 AM - 328

Update table from different database
VULonestar 33 minutes ago - 334

Oracle to MS SQL Server 2005 migration using SSIS
nkshah 2 hours 21 minutes ago - 017

SQL Server 2000 DTS ActiveX Script Step
North2Alaska 46 minutes ago - 248

Best way to denormalize two tables using SSIS 2005?
alicorn2 Wednesday, November 25, 2009 12:32 AM - 39338

SSIS kill throughput to SQL 08, causing Network & Buffer I/O waits, slow disk writes on powerful server
Greg Fricke Thursday, November 19, 2009 2:09 AM - 237

SQL Server agent not allowed access to file
rinish 4 hours 44 minutes ago - 130

Integration Services "choice" under Microsoft SQL Server 2005
usassh 3 hours 40 minutes ago - 453

Number of steps / transformation in a package - what is best practice? (newbie question)
Steve_Fox 6 hours 33 minutes ago - 654

A user request from the session with SPID 61 generated a fatal exception. SQL Server is terminating this session.
collie12 Tuesday, November 24, 2009 5:58 PM - 667

Text import with text qualifier and delimiter appearing inside fields
cameron_eldridge Wednesday, November 25, 2009 2:29 AM - 1068

Help: Making disable property of a task dynamic
saurabh180407 7 hours 10 minutes ago - 769

How To Map A GUID Variable And Use It In An OLE DB Source Data Flow Select Query
Delamater 9 hours 5 minutes ago - 959

I have a Query to run in an Oracle Source System where I need to pass a date variable looked up from another SQL Server Source
Mr Pro Tools 14 hours 46 minutes ago - 18450

Enable / Disable SSIS execute process task from Script task
Ramana Cheripally Wednesday, July 22, 2009 4:33 PM - 349

Log Extract And Load Row Counts
Necati ARSLAN 10 hours 34 minutes ago - 8116

Determine Columns to update and updated columns
John Daly Saturday, November 21, 2009 4:31 AM

