| SQL Server Setup Help | |
| Behavior Changes to Integration Services Features in SQL Server 2008 | |
|
|
| Upgrading to SQL Server 2008 > Backward Compatibility > Integration Services Backward Compatibility > |
This topic describes behavior changes in Integration Services. Behavior changes affect how features work or interact in SQL Server 2008 as compared to earlier versions of SQL Server.
Behavior Changes
The following table describes changes in behavior between the version of Integration Services that is included in SQL Server 2008 and the version of Integration Services that is included in earler releases.
| Issue | SQL Server 2005 Integration Services Behavior | SQL Server 2008 Integration Services Behavior |
|---|---|---|
|
Returning a NULL value in a package variable from the Execute SQL task |
Returns the value as 11/30/1999. |
Returns the value as 12/30/1899. |
|
Developing scripts in the Script task and Script component |
Uses Visual Studio for Applications (VSA) as the scripting environment. |
Uses Visual Studio Tools for Applications (VSTA) as the scripting environment. To migrate packages that contain scripts, use the SSIS Package Upgrade Wizard. |
|
Using the Lookup transformation |
Cannot persist the cached reference table or share this table among multiple Lookup transformations. |
Can persist the cached reference table or share this table among multiple Lookup transformations. To use the new features of the Lookup transformation, consider revising your packages. |