Browse by Tags

Moving DTS packages to a SQL Server 2005 Server

One of my AD teams asked for DTS packages to be moved from a SQL Server 2000 server to a SQL Server 2005 Server. These packages are stored in the msdb database. I created an SSIS package per the instructions at the following link to copy packages from a SQL Server 2000 server to a SQL Server 2005 server...

Posted to DTS Conversion Support (Forum) by rdameron on 08-20-2008
Launch Remote SSIS Package Programmatically

It can be a pain to launch an SSIS package remotely. So I developed a vb.net standalone application to remotely launch a package. It does require the host computer to have SSIS installed. This is just a beginning program. I am going to be adding other features like variables and config files. Eventually...

Posted to Mike Davis (Weblog) by Mike Davis on 08-20-2008
GACUtil.exe missing from Windows 2008

I was trying to deploy a custom assembly today using Windows 2008 and SQL Server 2008 and found a bit of differences in Windows 2008. The GACUtil.exe utility has now moved first and foremost and is not installed by default until you install the .NET and Windows 2008 SDK. After that, you'll be able...

Posted to Brian Knight (Weblog) by Brian Knight on 08-14-2008
SSIS for the DBA Sample Files

Thanks to all who came to today's session on Introduction to SSIS. Tomorrow's session is on SSIS for the DBA. If you have not registered, I'm afraid we've maxed out the conference system at this point with 3200 people spread across Wednesday's sessions and we're expecting the...

Posted to Brian Knight (Weblog) by Brian Knight on 07-15-2008
Files from Introduction to SSIS Webinar

Thanks to the 1500 + people who attended today's webinars. The recording will be posted on PragmaticWorks.com or SQLServerCentral.com next week. In case you're following along with the example I had on the webinar, you can download the code below. Download : IntroSSISWebinarSample.zip

Posted to Brian Knight (Weblog) by Brian Knight on 07-15-2008
Making the SSIS Data Reader Source Query Dynamic

I was recently working with FoxPro for Unix as a data source using ODBC in SSIS (story for another day) and found some interesting scenarios inside of it. We wanted to pull the table name dynamically, thus changing the SELECT statement inside the SSIS Data Reader Source. Whilst this is quite easy in...

Posted to Brian Knight (Weblog) by Brian Knight on 07-02-2008
Webinar Summer Series Extended - 5 Days, 11 Hours of Free BI Training

Due to popular demand, many of the webinars have reached the capacity of more than 1500 registered guests. To make sure everyone could participate, we have added an additional hour each day for those who missed the first session. You must register in order to attend and the second session is expected...

Posted to Brian Knight (Weblog) by Brian Knight on 07-01-2008
Another SSIS Webinar: Administering, Deploying and Configuring SQL Server Integration Services (SSIS) Packages

In this session by SQL Server MVP, Brian Knight, you’ll learn how to make a package that needs zero configuration as you migrate from development to production. He will then show you how to deploy your packages and administer the SSIS service. You’ll also learn how to: -Create configuration...

Posted to Brian Knight (Weblog) by Brian Knight on 06-26-2008
5 Hours of Free Training - The BI Series

Nothing gives me more pleasure than teaching and getting the "aha" moment out of a student when the student gets over the learning curve of a potentially difficult product. That feeling on a larger scale is what is exciting me most to announce a free business intelligence webinar series during...

Posted to Brian Knight (Weblog) by Brian Knight on 06-25-2008
Using RegEx in SSIS to Remove Given Characters

In SSIS, we recently were engaged by a customer who had a fairly simple request. They wished to remove non-numeric items from a column in the data flow. They were doing this in a stored procedure by using a T-SQL replace function row-by-row and we wanted to make this a data flow instead due to speed...

Posted to Brian Knight (Weblog) by Brian Knight on 06-03-2008

Page 1 of 5 (41 items) 1 2 3 4 5 Next >