Thursday, March 29, 2007

New SQL Server Integration Services Video Tutorial: Pt. 1 - How You Can Use Custom Log Providers to Log to HTML Web Pages and Email Using the SQL Server 2005 Sample Applications

Pt. 1 - How You Can Use Custom Log Providers to Log to HTML Web Pages and Email Using the SQL Server 2005 Sample Applications - view details
Pt. 1 - How You Can Use Custom Log Providers to Log to HTML Web Pages and Email Using the SQL Server 2005 Sample Applications
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: Pt. 1 - How You Can Use Custom Log Providers to Log to HTML Web Pages and Email Using the SQL Server 2005 Sample Applications

posted by Scott Whigham @ 1:30 PM   0 comments  

New SQL Server Integration Services Video Tutorial: Tips on Documenting and Annotating Your SSIS Packages

Tips on Documenting and Annotating Your SSIS Packages - view details
This video covers the basics of documenting, printing, and annotating (i.e., marking up) your SSIS packages. You'll see more than the basics however, you'll also see a few best practices and common uses.

Highlights from this video:
  • Using the Text Annotations Effectively
  • Arranging and Formatting Your Annotations
  • Printing and Documenting Your Packages and Tasks
  • Formatting Your Text for Clear Documentation
  • Grouping and anchoring text
and much more

*** This is an updated 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: documentation, printing, printer, printed, dictionary, generate, annotate, annotating, documenting

posted by Scott Whigham @ 1:30 PM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 1- Introduction to SQL Server 2005's Integration Services

Pt. 1- Introduction to SQL Server 2005's Integration Services - view details
If you've been confused, mystified, or downright ornery about SQL Server 2005's Integration Services, you're not alone. Everything has changed so drastically from the "old" DTS days that much of our previous knowledge is pass��. This video is a jumping-off point, a first look, at SSIS and some of the basic architectural changes including using the Business Intelligence Design Studio (often referred to as the BI Studio) and how the .dtsx files work within a project/solution. This video doesn't feature any package creation nor talk about the individual tasks; it's really more about how things have changed, what the new tools are, and is really designed to help you get comfortable 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: SSIS intro, integration services first look, ssis basics, integration services architecture

posted by Scott Whigham @ 1:30 PM   0 comments  

New SQL Server Integration Services Video Tutorial: Pt. 3 - Introduction to SSIS Package Deployment

Pt. 3 - Introduction to SSIS Package Deployment - view details
How do you get an SSIS package "into" SQL Server 2005? Give up? It is quite confusing and one of the more common questions people have as they start looking at SSIS for the first time. If you want to schedule an SSIS package, there are several options but perhaps the easiest and most manageable technique is to (1) store the SSIS package in MSDB, and (2) schedule a job to execute the package. This video walks you through creating a "Deployment Utility" which is really just a euphemism for an XML file with a .SSISDeploymentManifest extension. If you double-click on the .SSISDeploymentManifest file, it launches the Package Installation Wizard that allows you to easily deploy an entire project's worth of SSIS packages. This is not the only technique but definitely the easiest way to deploy a series of related 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: SSISDeploymentManifest, deploy ssis package, build SSIS package, schedule ssis package, ssis package job step, deploy .dtsx

posted by Scott Whigham @ 1:30 PM   0 comments  

Tuesday, March 27, 2007

New SQL Server Integration Services Video Tutorial: 3 - How to Install the Office Primary Interop Assemblies for Use in SSIS

3 - How to Install the Office Primary Interop Assemblies for Use in SSIS - view details
To create fancy looking reports for Excel using SSIS, you must access the Excel object model using the Primary Interop Assemblies (PIAs).

Download the Office PIAs:
Make sure you download the above files in order to follow along.

NOTE: This video and the remaining videos in this series require knowledge of:
  • Global Assembly Cache
  • How to Install Assemblies for Use in SSIS
  • Visual Basic .NET
  • Microsoft Excel 2003, Excel 2007, Excel XP
  • A Basic Understanding of COM Interop
  • Working Knowledge of the .NET Framework
  • How to Build Data Flow Tasks
  • How to Create and Assign Values to SSIS variables
  • Creating Basic 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: primary interop assembly, primary interop assemblies, Microsoft.Office, Microsoft.Office.Interop, , Microsoft.Office.Interop.Exc

posted by Scott Whigham @ 3:52 AM   0 comments  

Tuesday, March 13, 2007

New SQL Server Integration Services Video Tutorial: Tips on Documenting and Annotating Your SSIS Packages

Tips on Documenting and Annotating Your SSIS Packages - view details
This video covers the basics of documenting, printing, and annotating (i.e., marking up) your SSIS packages. You'll see more than the basics however, you'll also see a few best practices and common uses.

Highlights from this video:
  • Using the Text Annotations Effectively
  • Arranging and Formatting Your Annotations
  • Printing and Documenting Your Packages and Tasks
  • Formatting Your Text for Clear Documentation
  • Grouping and anchoring text
and much more

*** This is an updated 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: documentation, printing, printer, printed, dictionary, generate, annotate, annotating, documenting

posted by Scott Whigham @ 4:47 AM   0 comments  

Wednesday, March 7, 2007

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 Server 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:54 AM   0 comments  

Thursday, March 1, 2007

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 Mi gration 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
  • Migrating 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, migrate, legacy

posted by Scott Whigham @ 11:34 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 @ 11:34 AM   0 comments  

New SQL Server Integration Services Video Tutorial: 1 - An Overview of Creating High Quality Reports Using Excel and SSIS

1 - An Overview of Creating High Quality Reports Using Excel and SSIS - view details
Periodically, we all get requests to create reports - it's a daily event for some developers and admins. A lot of times, the preferred format is Microsoft Excel. Did you know that you can create high quality (good looking) reports directly in SSIS? We're talking about reports that have pictures/logos, custom font schemes, colors, etc - high quality reports!

Highlights from this video:
  • An overview of the process that you must go through to produce reports using Excel
  • Previewing a complex report generated with SSIS
  • When to use SSIS to build reports as opposed to using SSRS (SQL Server Reporting Services)
and much more

NOTE: This video and the remaining videos in this series require knowlede of:
  • Visual Basic .NET
  • Microsoft Excel 2003, Excel 2007, Excel XP
  • A Basic Understanding of COM Interop
  • Working Knowledge of the .NET Framework
  • How to Build Data Flow Tasks
  • How to Create and Assign Values to SSIS variables
  • Creating Basic 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: primary interop assembly, primary interop assemblies, Microsoft.Office, Microsoft.Office.Interop, , Microsoft.Office.Interop.Exc

posted by Scott Whigham @ 11:34 AM   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 @ 11:34 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 @ 11:34 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 @ 11:34 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 @ 11:34 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 @ 11:34 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 @ 11:34 AM   0 comments  

New SQL Server Integration Services Video Tutorial: 5 - Finishing Our SSIS Package

5 - Finishing Our SSIS Package - view details
The final video in this series shows you the remaining options for working with this complex package example and includes discussions on using SSIS variables as a data source, manipulating the Excel document with Visual Basic.NET code, how to guarantee garbage collection of your objects when using COM interop, and much, much more.

NOTE: This video and the remaining videos in this series require knowlede of:
  • Visual Basic .NET
  • Microsoft Excel 2003, Excel 2007, Excel XP
  • A Basic Understanding of COM Interop
  • Working Knowledge of the .NET Framework
  • How to Build Data Flow Tasks
  • How to Create and Assign Values to SSIS variables
  • Creating Basic 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: primary interop assembly, primary interop assemblies, Microsoft.Office, Microsoft.Office.Interop, , Microsoft.Office.Interop.Exc

posted by Scott Whigham @ 11:34 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 @ 11:34 AM   0 comments  

New SQL Server Integration Services Video Tutorial: 4 - Writing Script Tasks in SSIS to Use the Office PIAs

4 - Writing Script Tasks in SSIS to Use the Office PIAs - view details
In part 3, you installed the Office Primary Interop Assemblies into the global assembly cache but, unfortunately for us, that's not enough to allow us to use them in SSIS! To use the Interop assemblies in your Script Tasks in SSIS, you have another step to do and this video shows you:
  1. The final step to configure SSIS to work with the Office Interop assemblies
  2. The basics of the Microsoft.Office.Interop.Excel class and how to manipulate your Excel worksheet through code
  3. A walk through of a complex PIA-based package

NOTE: This video and the remaining videos in this series require knowlede of:
  • Visual Basic .NET
  • Microsoft Excel 2003, Excel 2007, Excel XP
  • A Basic Understanding of COM Interop
  • Working Knowledge of the .NET Framework
  • How to Build Data Flow Tasks
  • How to Create and Assign Values to SSIS variables
  • Creating Basic SSIS packages
To download this video, log in, then visit the vide o'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: primary interop assembly, primary interop assemblies, Microsoft.Office, Microsoft.Office.Interop, , Microsoft.Office.Interop.Exc

posted by Scott Whigham @ 11:33 AM   0 comments  

New SQL Server Integration Services Video Tutorial: 2 - Configuring Variables and Setting Up the Data Flow Task

2 - Configuring Variables and Setting Up the Data Flow Task - view details
Now that we have the assignment of our variables, we need to crate and configure a Data Flow Task to move the data from SQL Server to the Excel spreadsheet/worksheet.

Highlights from this video:
  • Using Data Access Mode 'SQL command from variable' in your OLE DB Source Editor
  • How to dynamically create SQL statements ('dynamic SQL') in a Script Task based on SSIS variables
  • Tips and Tricks for working with the OLEDB Source connection manager
  • Tips and tricks for migrating data from SQL Server into Excel using SSIS
    • How to avoid the dreaded "cannot convert from Unicode to non-Unicode" error
  • A preview of the Office PIAs, the Microsoft Office Primary Interop Assemblies
and much more

NOTE: This video and the remaining videos in this series require knowlede of:
  • Visual Basic .NET
  • Microsoft Excel 2003, Excel 2007, Excel XP
  • A Basic Understanding of COM Interop
  • Working Knowledge of the .NET Framework
  • How to Build Data Flow Tasks
  • How to Create and Assign Values to SSIS variables
  • Creating Basic SSIS packages
T o 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: primary interop assembly, primary interop assemblies, Microsoft.Office, Microsoft.Office.Interop, , Microsoft.Office.Interop.Exc

posted by Scott Whigham @ 11:33 AM   0 comments  

New SQL Server Integration Services Video Tutorial: 3 - How to Install the Office Primary Interop Assemblies for Use in SSIS

3 - How to Install the Office Primary Interop Assemblies for Use in SSIS - view details
To create fancy looking reports for Excel using SSIS, you must access the Excel object model using the Primary Interop Assemblies (PIAs).

Download the Office PIAs:
Make sure you download the above files in order to follow along.

NOTE: This video and the remaining videos in this series require knowlede of:
  • Global Assembly Cache
  • How to Install Assemblies for Use in SSIS
  • Visual Basic .NET
  • Microsoft Excel 2003, Excel 2007, Excel XP
  • A Basic Understanding of COM Interop
  • Working Knowledge of the .NET Framework
  • How to Build Data Flow Tasks
  • How to Create and Assign Values to SSIS variables
  • Creating Basic 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: primary interop assembly, primary interop assemblies, Microsoft.Office, Microsoft.Office.Interop, , Microsoft.Office.Interop.Exc

posted by Scott Whigham @ 11:33 AM   0 comments