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

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

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

Interveiw question : how you approach SSIS packages desing and development ?
nkshah 6 hours 8 minutes ago - 131

Conditions in SSIS
collie12 4 hours 56 minutes ago - 8133

Set variable value
collie12 Wednesday, October 28, 2009 10:47 AM - 141549

Cannot transfer/copy database in one step like I could with 2000.
mpavlik Saturday, December 02, 2006 6:23 AM - 18152

SSIS Server+Database For Each Loop
SFL234 Tuesday, November 03, 2009 3:26 PM - 148

How to grab time stamp for all the data cells in Excel 2007 as source file and generating a mail for that data using SSIS 2005
mahendra poola 12 hours 23 minutes ago - 581

Join two files into one?
Zachter Friday, November 06, 2009 4:56 PM - 244

Blocking: Wait Type lck_m_sch_s
algkep Friday, November 06, 2009 10:22 AM - 458

SSIS - 2005 - Overcome String Limitation of 4000 characters for sqlcommand
Harris001 Wednesday, November 04, 2009 7:32 PM - 268

SSIS 2005 Production support
James1411 18 hours 6 minutes ago - 878

Looking for Microsoft.SqlServer.ManagedDTS version 10
Eric Day Friday, November 06, 2009 9:27 PM - 454

Flat File Creation-Script Task----Flatfile Destination [85]: The process cannot access the file because it is being used by another process
Manikandan S Friday, November 06, 2009 1:24 PM - 4938528

Checking to see if a record exists and if so update else insert
Phil BrammerMVPFriday, February 09, 2007 8:40 PM - 23319

Cant open dtsx project when the data source is Excel
AddinGanteng Friday, October 30, 2009 8:26 AM - 572

Modifying Rows From a Flat File Source
knovak Wednesday, November 04, 2009 10:26 PM - 7102

Package hangs at Script component
jj3k2009 Thursday, November 05, 2009 10:59 PM - 035

Top 10 Answerers
Bharani 3010 19 hours 7 minutes ago - 572

Best way to process rows in batches from a raw file?
ckbkyne Friday, November 06, 2009 8:49 PM


