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.
- 1722374

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

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

Dynamically ExecuteSQLTask in SSIS
rajesh20k 3 hours 0 minutes ago - 023

How to read blob in SSIS.
Kanhaiya2 53 minutes ago - 552

C# or VB in the scritp task
Ells 4 hours 32 minutes ago - 023

SSIS package not running dll reference error
pauli1975 1 hour 37 minutes ago - 5107

Pros/Cons/Best Practises for running 2005 and 2008 SSIS on same box
SteJo1977 Tuesday, February 09, 2010 9:40 AM - 5112

how to read the configruations from script task when running
kingchenghisoft Sunday, February 07, 2010 9:34 AM - 135

XML to Database-Urgent
Baazigar. 3 hours 19 minutes ago - 255

SSIS Appropriate Usage
barkingdog 12 hours 5 minutes ago - 140

How to convert oracle blob data to sqlserver image type in SSIS
Murty A 5 hours 51 minutes ago - 4110

Connection manager, test connection button creates an error
tiptoed Saturday, February 06, 2010 6:06 PM - 875

Checking wheather Select Query returns any value or not
A2H1986 7 hours 42 minutes ago - 267

installing BIDS on a remote pc
Qwool 20 hours 41 minutes ago - 11178

Exporting Data from Oracle Tables into Text Files
Umair Ahmad Tuesday, February 02, 2010 7:28 AM - 481

use the file name in foreach block in a script task
Prasanna Ganapayya 13 hours 49 minutes ago - 366

Import/Export Wizard Question - SQL 2008
Westside2008 7 hours 13 minutes ago - 1117

How to import Notes data in SQL 2005
RaymondXie Wednesday, January 20, 2010 8:18 PM - 473

Test on DataBase
MSGupta 15 hours 13 minutes ago - 6108

Job executes but package doesn't work
AllenN Monday, February 08, 2010 5:34 AM

