Monday, January 22, 2007

New SQL Server Integration Services Video Tutorial: Pt. 5 - Adding Custom Assemblies to the GAC

Pt. 5 - Adding Custom Assemblies to the GAC - view details
Almost there... Not too long now and you'll be able to actually use your assemblies!
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: gac, global assembly cache

posted by Scott Whigham @ 6:39 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 3 - An Overview of Importing .NET Assemblies into SSIS

Pt. 3 - An Overview of Importing .NET Assemblies into SSIS - view details
It is quite difficult for newbies to use C# or Visual Basic code in their SSIS packages due to the number of steps required to acutally get your assembly to even show up inside of SSIS. This helpful walk-through shows you the common pitfalls that most people fall into when working with assemblies in SSIS and gets you started on the right path to setting up assemblies in 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: gac, global assembly cache

posted by Scott Whigham @ 6:38 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 4 - Adding Custom Assemblies Correctly

Pt. 4 - Adding Custom Assemblies Correctly - view details
In order to add assemblies so that you can use them in SSIS, you have two choices (and they're both about the same in terms of complexity/dignity-loss):
  1. Do a special dance while holding a 1963 US nickel in your left hand and wearing a fedora once owned by Charles Mingus.
  2. Follow the cryptic, hard to find way to add assemblies to the right place
Your call...
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: gac, global assembly cache

posted by Scott Whigham @ 6:38 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 1 - Installing Visual Studio 2005 Express Editions

Pt. 1 - Installing Visual Studio 2005 Express Editions - view details
This video, the first in our series on using .NET assemblies in SSIS tasks, walks you the installation of your Visual Studio environment. This particular video talks about using Visual Studio Express Editions as a free way to develop your own custom assemblies that you can use in your SSIS packages.

Highlights from this video series:
  • Setting up Visual C# Express Edition (or Visual Basic Express Edition)
  • Writing assemblies (class libraries) using C# and Visual Basic
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: install, beginner, b eginning, setup, installation

posted by Scott Whigham @ 6:38 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 2 - Writing .NET Assemblies and an Overview of Assembly Use

Pt. 2 - Writing .NET Assemblies and an Overview of Assembly Use - view details
This video walks you through creating your first properties and methods, talks about security of your assembly classes and methods/properties and walks you through creating your first .DLL to use in later SSIS 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: classes, objects, properties

posted by Scott Whigham @ 6:38 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 6 - Using Custom Assemblies in the Script Component Task

Pt. 6 - Using Custom Assemblies in the Script Component Task - view details
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.

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

Keywords Associated with this video: data flow, transform data task

posted by Scott Whigham @ 6:38 AM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 7 - Versioning Assemblies and Redeploying For Use in SSIS Packages

Pt. 7 - Versioning Assemblies and Redeploying For Use in SSIS Packages - view details
Our last video in this series is on updating and maintaining your assembly code; i.e., how to deploy new versions of your assembly so that you can use them in 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: gac, global assembly cache

posted by Scott Whigham @ 6:38 AM   0 comments  

Thursday, January 18, 2007

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 @ 12:03 PM   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 @ 12:03 PM   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 @ 12:03 PM   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 @ 12:03 PM   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 @ 12:03 PM   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 @ 12:03 PM   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 @ 12:03 PM   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 @ 12:03 PM   0 comments  

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 @ 12:03 PM   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 @ 12:03 PM   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 @ 12:03 PM   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 @ 12:03 PM   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 @ 12:03 PM   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 @ 12:03 PM   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 @ 12:02 PM   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 @ 12:02 PM   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!
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 ins talled to view this video

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

posted by Scott Whigham @ 12:02 PM   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 @ 12:02 PM   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 @ 12:02 PM   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 @ 12:02 PM   0 comments  

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

Pt. 1 - An In-Depth Case Study of Migrating a DTS Package to SSIS - view details
This is the first video in our series on migrating a DTS package to SSIS package. If you're looking for an exhaustive treatment of how to migrate a complex DTS package to SSIS, then you definitely will want to watch this series. This series takes an interesting DTS package - iterating through each file returned from a result set, downloading that file via FTP, and then inserting that text file's data in a SQL Server table - and lets you see exactly how to migrate this package to SSIS.

Highlights from this video:
  • Using the Package Migration Wizard (PMW)
  • Limitations of the PMW
  • What to Do When the PMW Reports Success But Your SSIS Packages Fail< br />
  • Should You Rewrite Your DTS Package or Use the PMW?
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-on ly 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 @ 12:02 PM   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 @ 12:02 PM   0 comments