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

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

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

SQL Server 2008 Import/Export Wizard - DTSWizard.exe
SQLUSA 14 minutes ago - 445

The AcquireConnection method call failed with error code 0xC0202009
collie12 7 hours 57 minutes ago - 3133

Error while migrating the SSIS solution file
Anthu Saturday, November 14, 2009 5:26 AM - 025

Importing text files via DTS with large record lengths
BrendanDowns 1 hour 40 minutes ago - 254612

URGENT: Insert and Update in a transaction is getting blocked
Jamie ThomsonMVPFriday, December 02, 2005 11:40 AM - 151

convert epoch timestamp to datetime field when importing using ssis into sql server... how?
Cavall Saturday, November 21, 2009 7:16 PM - 148

Fail container - two tasks run in parallelism
Tzur Turkenitz 11 hours 44 minutes ago - 376

Treat output from data source as original data source
Naquer Saturday, November 21, 2009 2:36 PM - 060

how to send message to external message queue in a trigger of sql server ?
kkdhf 23 hours 2 minutes ago - 9181

exporting all sql 2005 express tables at once to excel
egger29 Thursday, November 19, 2009 11:29 PM - 574

update records in DATA FLOW tab?
Kumar03 Saturday, November 21, 2009 12:38 AM - 11165

Export to excel from SSIS 2005
collie12 Thursday, November 19, 2009 11:45 AM - 5457

convert data type in SSIS design time
hommer Tuesday, October 02, 2007 1:31 PM - 053

Whats wrong with this SSIS Script component?
Maccaman Saturday, November 21, 2009 6:43 PM - 2268

Install procedure to Add SSIS to a SQL 2008 clustered node
eastbr Tuesday, March 17, 2009 10:04 PM - 588

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

How to check if a column is mapped in a destination component?
dced Friday, April 03, 2009 11:03 AM - 152

Cannot open my invoice programme
Deeding Saturday, November 21, 2009 12:40 PM


