In SQL Server 2008, Integration Services uses Visual Studio Tools for Applications (VSTA) as its script environment. In earlier versions, the script environment was Visual Studio for Applications (VSA). Script tasks and Script components are automatically upgraded from VSA to VSTA when you open or upgrade packages in SQL Server 2008.
In SQL Server 2005, with some exceptions, table hints are supported in the FROM clause of a query only when the hints are ...
In SQL Server 2008, connection strings require a different value for some provider names. The value for the SQL Server Native ...
In SQL Server 2008, global trace flags set by a session take effect in other sessions immediately. Also, some trace flags ...
In SQL Server 2008, Integration Services has changed its application programming interfaces (APIs). To be compatible with ...
In SQL Server 2008, Integration Services uses Visual Studio Tools for Applications (VSTA) as its script environment. In earlier ...
In SQL Server 2008, SQL Server Agent supports multiple proxies. You define these proxies by using a new set of stored procedures. ...
In SQL Server 2008, the Lookup transformation includes additional capabilities, such as the ability to persist and share ...
In SQL Server 2008, xml is a reserved system type. Rename your user-defined xml type either before or after upgrading to ...
In SQL Server Enterprise Manager, choose to have the agent update the subscription "on demand only" in the Pull Subscription ...