Friday, December 22, 2006

New SQL Server Integration Services Video Tutorial: Pt. 3d- An Overview of Using SSIS for Newbies and Beginners - Using BIDS

Pt. 3d- An Overview of Using SSIS for Newbies and Beginners - Using BIDS - view details
Finally! Our last video on using BIDS for Beginners
To download this video, l og in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: Business Intelligence Projects, Visual Studio, 2005, VS2005, Visual Studio 2005

posted by Scott Whigham @ 4:46 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 3c - An Overview of Using SSIS for Newbies and Beginners - Using BIDS

Pt. 3c - An Overview of Using SSIS for Newbies and Beginners - Using BIDS - view details
Even more on BIDS
To download this video, log in, then visit the video 's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: Business Intelligence Projects, Visual Studio, 2005, VS2005, Visual Studio 2005

posted by Scott Whigham @ 4:45 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 3b - An Overview of Using SSIS for Newbies and Beginners - Using BIDS

Pt. 3b - An Overview of Using SSIS for Newbies and Beginners - Using BIDS - view details
More on working inside the Business Intelligence Development Studio (BIDS)
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: Business Intelligence Projects, Visual Studio, 2005, VS2005, Visual Studio 2005

posted by Scott Whigham @ 4:45 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 3a - An Overview of Using SSIS for Newbies and Beginners - Using BIDS

Pt. 3a - An Overview of Using SSIS for Newbies and Beginners - Using BIDS - view details
Our video tutorials in using the Business Intelligence Development Studio (BIDS) spans multiple videos simply due to the complexities of BIDS. This video introduces you to what BIDS is and does and what Projects and Solutions are.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: Business Intelligence Projects, Visual Studio, 2005, VS2005, Visual Studio 2005

posted by Scott Whigham @ 4:45 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 2 - An Overview of Using SSIS - Using SQL Server Management Studio

Pt. 2 - An Overview of Using SSIS - Using SQL Server Management Studio - view details
What do you use SSMS for (with respect to SSIS) - do you know? Is it possible that you can edit DTS packages? (that's a trick question, by the way). This video helps you understand when and where to use SSMS with Integration Services.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: ssms, schedule job, scheduling job, how to schedule job, security, roles, package roles

posted by Scott Whigham @ 4:45 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 1 - An Overview of Using SSIS for Newbies and Beginners

Pt. 1 - An Overview of Using SSIS for Newbies and Beginners - view details
If you are just getting started with Integration Services, then you need to START HERE. This video, part one of a whole series on SSIS for beginners, starts you out with an introduction of what SSIS will be used for and the different tools that you'll be using. This video is more of an overview and is designed to give you the view of SSIS from 50,000 feet, if you will. The remaining videos in this series will dig down in to the topics posed in this video and help you get started with SSIS the right way.

Highlights from this video:
  • Which tools do you use to schedule and execute SSIS packages?
  • What tool(s) do you use to edit and develop SSIS packages?
    • What can you do within SSMS (SQL Server Management Studio)?
  • What can you do within BIDS (Business Intelligence Development Studio)?
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: intro, introduction, beginning, newbs, newbies, starters, first time, overview, technology overview

posted by Scott Whigham @ 4:44 AM   0 comments  

Wednesday, December 20, 2006

New SQL Server Integration Services Video Tutorial: Pt. 4b - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS

Pt. 4b - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS - view details
Yikes! While migrating from SQL 2000 to 2005 and using the DTS Designer Components (downloaded from MSFT), Scott Whigham, our author, had a little unexpected visit from the Demo Gods. This video is somewhat funny in terms of silly the issues are that you may experience and, if for nothing else other than having a laugh, you'll want to watch this video!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: comedy, error, errors, failures

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Upgrading from DTS to SSIS: Running the SQL Server 2005 Upgrade Advisor

Upgrading from DTS to SSIS: Running the SQL Server 2005 Upgrade Advisor - view details
The first thing you'll want to do before migrating to SSIS/SQL 2005 is to run the SQL Server 2005 Upgrade Advisor. However, don't expect great things from it with respect to DTS/SSIS; it only has certain generalities that it will provide you.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: SSUA, migrate, migrating, upgrading

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 1 - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS

Pt. 1 - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS - view details
This series of videos (eight in all) walks you through migrating an entire SQL Server 2000 instance to SQL Server 2005's SSIS. You'll cover everything from the install/setup of SQL 2005 to moving individual packages.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: upgrading, upgrade, migrating, data transformation services, migrate, inplace, in-place

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 3 - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS

Pt. 3 - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS - view details
This video covers how to edit your Legacy packages inside the BIDS (Business Intelligence Development Studio). You'll need to watch this to get the full picture of working with SSIS.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: upgrading, upgrade, migrating, data transformation services, migrate

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 3b - An Overview of Using SSIS for Newbies and Beginners - Using BIDS

Pt. 3b - An Overview of Using SSIS for Newbies and Beginners - Using BIDS - view details
More on working inside the Business Intelligence Development Studio (BIDS)
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: Business Intelligence Projects, Visual Studio, 2005, VS2005, Visual Studio 2005

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 3 - An In-Depth Case Study of Migrating a DTS Package to SSIS

Pt. 3 - An In-Depth Case Study of Migrating a DTS Package to SSIS - view details
Modifying the Wizard-generated package
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: migrate, migrating, upgrade, upgrading, fails, failure

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 6 - An In-Depth Case Study of Migrating a DTS Package to SSIS

Pt. 6 - An In-Depth Case Study of Migrating a DTS Package to SSIS - view details
More. More SSIS. More Package Migration Wizard things to fix. More.
To downloa d this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: upgrading, upgrade, migrating, data transformation services, migrate

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 3d- An Overview of Using SSIS for Newbies and Beginners - Using BIDS

Pt. 3d- An Overview of Using SSIS for Newbies and Beginners - Using BIDS - view details
Finally! Our last video on using BIDS for Beginners
To download this video, l og in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: Business Intelligence Projects, Visual Studio, 2005, VS2005, Visual Studio 2005

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Options for Migrating from SQL Server 2000 DTS to SSIS in SQL Server 2005

Options for Migrating from SQL Server 2000 DTS to SSIS in SQL Server 2005 - view details
This video is an excellent technology-overview of what options exist for moving from SQL Server 2000's DTS to SQL Server 2005's SSIS. Do you want to just migrate one package or all packages? Are you moving your entire server or just one package? What is legacy mode?

Highlights from this video:
  • Choices you have to make when moving from SQL 2000 to SQL 2005
  • Package Migration Wizard vs. an In-Place Upgrade
  • Using Legacy Mode/compatibility in SSMS (SQL Server Management Studio)
  • Issues with migrating DTS packages to SSIS
  • Benefits of in-place upgrades
  • Using the DTS Designer Components
  • H ow to Edit DTS Packages After Moving to SSIS
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video s o a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: upgrading, upgrade, migrating, data transformation services, migrate

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Variables in SSIS

Variables in SSIS - view details
Of course you can use variables in SSIS - was it really ever a question? SSIS variables are far more robust, typed, and extensible in SSIS than they ever were in DTS. You can create multiple namespaces, have variables with the same names (crazy, eh?), and work with scoped variables.

Highlights from this video:
  • How namespaces work in SSIS variables
  • Modifying variable values
  • Using Expressions for variable values
  • An overview of the datatypes used by variables
  • System variables and User variables
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: global variables, variable assignment, set value, system.object, system.string, int32, int64, int16, uint16, uint32, uint64, cha

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 4 - An In-Depth Case Study of Migrating a DTS Package to SSIS

Pt. 4 - An In-Depth Case Study of Migrating a DTS Package to SSIS - view details
Further discussions of our SSIS super hero await you in this video. Okay, not really. More specifically, you'll learn about variable assignment and how to modify certain tasks.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: upgrading, upgrade, migrating, data transformation services, migrate

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 2 - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS

Pt. 2 - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS - view details
Further discussions of migrating from SQL 2000 to 2005 including using the DTS Designer Components to edit recently-upgraded SQL Sevrer 2000 DTS packages inside SQL 2005.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: upgrading, upgrade, migrating, data transformation services, migrate, inplace, in-place

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 3 - Expressions - Datatypes and Functions

Pt. 3 - Expressions - Datatypes and Functions - view details
The data types in the Expressions-syntax are cryptically named. What datatype does DT_R4 represent? DT_CY? Does DT_DBDATE hold the time as well? Difficult questions indeed!

HIghlights from this video include:
  • Discussions of every datatype including:
    • DT_I1, DT_I2, DT_I4, DT_I8, DT_UI1, DT_UI2, DT_UI4, DT_UI8
    • DT_R4, DT_R8 (for float/real)
    • DT_STR and DT_WSTR - very, very important to understand!
    • Differences between DB_DATE, DB_TIMESTAMP, DB_DBDATE, and DB_TIME
    • How to store images/files/binary
    • Currency and money data types as well as decimals and precision/scale
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: dt_bytes, dt_decimal, dt_numeric, dt_text, dt_ntext

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 5b - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS

Pt. 5b - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS - view details
This video finishes out our migration from SQL Server 2000 DTS to SQL Server 2005 SSIS by editing our Package Migration Wizard-generated package
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: migrate, migrating, upgrade, upgrading, fails, failure

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 2 of Working with the Container Tasks - the For Loop Container

Pt. 2 of Working with the Container Tasks - the For Loop Container - view details
The For Loop Container is akin to working with a programming language like C/C#/VB/Java in this respect:

for (int i = 0; i < 10; i++ )
{
���� // do something here
}

or, in a SQL language:

DECLARE @i INT
SET @i = 0
WHILE @i < 10
������ BEGIN
������ ���� -- do something here
������ ���� SET @i = @i + 1
������ END

These types of loops/iterations are very commonly needed in programming languages and, if you need to do them in SSIS, you can - BUT you have to know the expression syntax to do so!

Highlights from this video:
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: expression builder, expressions, @counter, variables, iteration, iterate, recursion

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 5a - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS

Pt. 5a - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS - view details
This video continues our example of migrating a complex data migration package to SSIS. This is part a of a two part series on migrating this package.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: upgrading, upgrade, migrating, data transformation services, migrate

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 7 - An In-Depth Case Study of Migrating a DTS Package to SSIS

Pt. 7 - An In-Depth Case Study of Migrating a DTS Package to SSIS - view details
The final chapter. The End. No mas. El Fin. That's all folks! Stop reading and just watch. There's nothing to read here, folks.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: migrate, migrating, upgrade, upgrading, fails, failure

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 5 - An In-Depth Case Study of Migrating a DTS Package to SSIS

Pt. 5 - An In-Depth Case Study of Migrating a DTS Package to SSIS - view details
More, more, more! Fixing common problems with the Package Migration Wizard's packages

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 4 - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS

Pt. 4 - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS - view details
This video goes a little bit deeper and shows you how to migrate a complex DTS package to SSIS using the Package Migration Wizard.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: upgrading, upgrade, migrating, data transformation services, migrate

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 6 - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS

Pt. 6 - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS - view details
Our last video in this series covers cleaning up and some final thoughts on using the Package Migration Wizard as well as a few Best Practices on migrating from SQL 2000 to SQL 2005.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: SSUA, migrate, migrating, upgrading

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 3c - An Overview of Using SSIS for Newbies and Beginners - Using BIDS

Pt. 3c - An Overview of Using SSIS for Newbies and Beginners - Using BIDS - view details
Even more on BIDS
To download this video, log in, then visit the video 's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: Business Intelligence Projects, Visual Studio, 2005, VS2005, Visual Studio 2005

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 2 - An In-Depth Case Study of Migrating a DTS Package to SSIS

Pt. 2 - An In-Depth Case Study of Migrating a DTS Package to SSIS - view details
Part two covers the Package Migration Wizard in detail
To download this video , log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: package migration wizard

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 3 of Working with the Container Tasks - the Foreach Loop Container

Pt. 3 of Working with the Container Tasks - the Foreach Loop Container - view details
Want to know how to iterate through every file in a folder and upload it into a SQL Server table? Want to know how to upload every XML-based element's attributes in SQL Server? The Foreach Loop Container Task is the professional's choice!��
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: iterating, recursively, recursion, looping, loops, FileSystemObject, FSO, objFSO, MoveNext, VBScript

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 3a - An Overview of Using SSIS for Newbies and Beginners - Using BIDS

Pt. 3a - An Overview of Using SSIS for Newbies and Beginners - Using BIDS - view details
Our video tutorials in using the Business Intelligence Development Studio (BIDS) spans multiple videos simply due to the complexities of BIDS. This video introduces you to what BIDS is and does and what Projects and Solutions are.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: Business Intelligence Projects, Visual Studio, 2005, VS2005, Visual Studio 2005

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 2 - Expressions - Using Expressions In SSIS Tasks

Pt. 2 - Expressions - Using Expressions In SSIS Tasks - view details
This video continues our series on using Expressions by focusing on using Expressions in SSIS tasks and using the Expression Builder. Also, Best Practices for Expressions and more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: expression builder, expressions, @counter, variables, iteration, iterate, recursion, tasks, F4

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 1 - An Overview of Using SSIS for Newbies and Beginners

Pt. 1 - An Overview of Using SSIS for Newbies and Beginners - view details
If you are just getting started with Integration Services, then you need to START HERE. This video, part one of a whole series on SSIS for beginners, starts you out with an introduction of what SSIS will be used for and the different tools that you'll be using. This video is more of an overview and is designed to give you the view of SSIS from 50,000 feet, if you will. The remaining videos in this series will dig down in to the topics posed in this video and help you get started with SSIS the right way.

Highlights from this video:
  • Which tools do you use to schedule and execute SSIS packages?
  • What tool(s) do you use to edit and develop SSIS packages?
    • What can you do within SSMS (SQL Server Management Studio)?
  • What can you do within BIDS (Business Intelligence Development Studio)?
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: intro, introduction, beginning, newbs, newbies, starters, first time, overview, technology overview

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 2 - An Overview of Using SSIS - Using SQL Server Management Studio

Pt. 2 - An Overview of Using SSIS - Using SQL Server Management Studio - view details
What do you use SSMS for (with respect to SSIS) - do you know? Is it possible that you can edit DTS packages? (that's a trick question, by the way). This video helps you understand when and where to use SSMS with Integration Services.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: ssms, schedule job, scheduling job, how to schedule job, security, roles, package roles

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Using the Package Migration Wizard to Upgrade Your DTS Packages to SSIS

Using the Package Migration Wizard to Upgrade Your DTS Packages to SSIS - view details
This video is an excellent overview of what to expect when running SQL Server 2005's Package Migration Wizard, the tool that migrates/upgrades your DTS packages to SSIS packages. If you are running SQL Server 2000 currently and want to know what challenges you face when moving to SSIS (as if you don't already know), then this video can help you spot common issues and recommend alternative techniques.

Highlights from this video:
  • What options you have for migrating from SQL Server 2000 to SQL Server 2005 (with respect to Data Tranformation Services)
  • Migrating one package or multiple packages (such as all packages)
  • Launching the Package M igration Wizard (PMW) from the command line (DOS prompt)
  • Common failures/challenges/issues with the PMW
  • Migrating the Dynamic Properties Task
  • Migrating Variables and the Execute SQL Task
  • Upgrading ActiveX Script Tasks
  • Migraitng FTP Tasks
  • Moving Transform Data Tasks and the common choices/options the PMW will use
and much more.

In the end, you have to decide whether to rewrite/redesign/rearchitect your DTS packages when you move to SSIS or you can use the Package Migration Wizard. This video (and the rest of the videos on the PMW) will help you make this choice.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: Execute DTS 2000 Package task, upgrade, upgrading, migration, migrat e, legacy

posted by Scott Whigham @ 3:48 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt.1 of Working with the Container Tasks in SSIS - An Overview of Each Container Task

Pt.1 of Working with the Container Tasks in SSIS - An Overview of Each Container Task - view details
Some of the greatest time savers in all of SSIS involve using the container tasks, the For Loop Container, the Foreach Loop Container, and (to a lesser degree) the Sequence Container. If you find yourself needing to iterate through a set of data (i.e., loop through a recordset) or loop through all files in a folder, then you'll need a solid understanding of the Container tasks. The BIDS environment (Business Intelligence Development Studio) does not do the best job at explaining what these tasks do and the documentation (the Books Online) are often quite difficult to work with thus making these container objects difficult to work with initially for many people.
< br />This video is part 1 in our series and it's purpose is to explain the different types of container tasks, walk through their likely uses, and explain the use of the Sequence Container Task. The other videos in this series will go in-depth into the other container tasks in detail.

Highlights from this video:
  • Formatting the containers
  • How containers work
  • Comparing the containers to structure programming and languages like C, C#, and Java
  • Discussions of when you use the Container tasks
  • Best practices for using the Sequence Container
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: foreach, for each, for(int i, collections, arrays

posted by Scott Whigham @ 3:48 AM   0 comments