SQL Server 2005 SP1 – CTP | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Server 2005 SP1 – CTP

http://www.sql-server-performance.com/absolutenm/templates/?a=716&z=1 Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
I have 2005 CTP. Complete in my server and only tools in my laptop.
When I try to install sp1, the message is: You cannot install this service pack to a pre-release version of SQL 2005. Sound like I have to have no CTP version. I missing something? Nothing?
Luis Martin
Moderator
SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS” with no warranties for accuracy.
Try with SQL 2005 Evaluation edition RTM version to apply and I do get the same message with CTP installed. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Ok. Thanks.
Luis Martin
Moderator
SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS” with no warranties for accuracy.
Went RTM yesterday…<br /><br />Get `em while thier hot, kiddies. <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br /><br /><br /<a target="_blank" href=http://www.microsoft.com/downloads/details.aspx?FamilyID=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&DisplayLang=en>http://www.microsoft.com/downloads/details.aspx?FamilyID=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&DisplayLang=en</a>
Yee haw
Anyone having problems with the install of SP1?
So far so good… Developers complaining bit glitches on SSIS & DTS arena. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
I’m having the same types of issues with SSIS on a clean install. I’m gonna wait for a SP-1a. <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />
As per the fix list on SQL Server 2005 Integration Services (SSIS)
• Usability of the Import/Export Wizard has been improved in multiple-table scenarios.
• The IDtsPipelineEnvironmentService service lets custom data flow components have programmatic access to the parent Data Flow task.
• Interoperability with Analysis Services has been improved. The DataReader source in SSIS supports the System.Object data type by converting columns that have this data type to the DT_NTEXT ssISnoversion data type. To change the data type to a type that is more appropriate for your data, you can add a Data Conversion transformation.
• Performance has been improved for many transformations, such as the Sort transformation.
• Designer usability has been improved. For example, you can now right-click Dataflow and then click Execute Task to execute only the Dataflow task. You do not have to switch to the control flow to execute only the Dataflow task.
• The Expression Builder dialog box now has a public and documented API. This increased access to expression-related objects will benefit task developers because expressions are important to the way that tasks are interrelated.
• We have added a registry-based policy for handling SSIS package signatures as a package is executed. For example, administrators can disable loading of unsigned packages and untrusted packages. Because these settings are in the registry, administrators can propagate these settings in the domain by using Microsoft Windows Group Policy policy settings.
• In the Advanced Editor dialog box, the Flat File source has the new property UseBinaryFormat. This property supports loading packed decimal data into the pipeline for processing by a script or by a custom transformation.
• In the Advanced Editor dialog box, the DataReader source has the new property CommandTimeout. You can use this property to modify the time-out period to allow for long-running operations.
• To create or to modify the property expressions of variables, you can now open the Expression Builder dialog box from the Properties window.
• You can now add annotations to precedence constraints.
***********
None of them seems to be a bug fixed option, it sounds more of cosmetic changes. Related blogs for reference:
http://blogs.conchango.com/jamiethomson/archive/2006/04/26/3870.aspx
http://blogs.conchango.com/jamiethomson/archive/2006/04/26/3877.aspx Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>