Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server Training Videos · SSIS Video Tutorials
     
DTS Training Videos             * SQL Server Training Videos
* SSIS Video Tutorials
* More Videobooks...
Email
Password
Register
LearnDTS.com Subscriber Videos
SQL Server DTS Videos By Category Home  Subscriber Videos  
Creating Dynamic DTS Packages with Global Variables and Dynamic Properties - Video Category (all video categories)
Video Image Global Variables are the greatest thing in DTS since... well, the Transform Data Task! Global Variables and the Dynamic Properties Task are just so pervasive today that it's hard to imagine designing robust, dynamic packages without them. This category helps you understand how to make and manage your own dynamic DTS packages and tasks.

Videos in this Category: orange = video series 
blue = individual video 
Click "Download" to download the video or click the video title for more information
TitleSkillView / DownloadLength
Series (3 videos) - Global Variables - How to Use Them to Create Dynamic and Dat...   200 (Click for Videos) 27 mins.
< Return to list of all videos
Miscellaneous Bits & Pieces:
There is a version of the "Adventure Works" sample database available for SQL Server 2000. Go to any search engine and search for "AdventureWorks2000" and locate the download file. AdventureWorks2000 is a more robust sample database than Northwind and pubs
Helpful Tools for your SQL Server: Check out Microsoft's Best Practices Analyzer Tool - a free download from microsoft.com/sql
You can use the table hint "WITH (NOLOCK)" to minimize the locks you place on resources during a SELECT statement - SELECT * FROM MyTable WITH (NOLOCK) places no "Shared" locks on MyTable
Video search
Company News
SSIS Training
     
Home | About Us | Advertising | Become an Author | Contact Us | Privacy | System Req's | Terms | Testimonials | Work for Us! | Blogs | Site Map Refer a Friend and Get a Free Subscription!
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners.
This site is not affiliated in any way with the Microsoft Corporation.
7/23/2008 6:45:39 PM