Browse by Tags

How to migrate parameterized DTS packages to SSIS (i.e. Parameters passed using command line from SQL Server Job)?

Many times we get this question "How do we handle parameterized packages using DTS xChange?" Parameterized package means package executed from command line with parameters passed to it. Most common parameters are global variable initial value. Since this is an issue related to command line...

Posted to Nayan Patel (Weblog) by Nayan Patel on 11-13-2008
How can DTS xChange save time and money?

DTS xChnage is developed by a team of experienced developers/DBAs who have great experience with DTS to SSIS migration and they have migrated thousands of packages. So they understand the pain of migration process and they have already faced all challenges which you going to face or you already facing...

Posted to Nayan Patel (Weblog) by Nayan Patel on 11-13-2008
Is there any 3rd party tool available in the market other than DTS xChange to help with DTS to SSIS migration?

No - Only available option is DTS xChange or inbuilt MS DTS Migration Wizard But study suggests that MS Migration Wizard Success Rate is very low. DTS xChange has several enhancements and new features compared to MS DTS Migration Wizard which saves significant amount of time and money. Visit the following...

Posted to Nayan Patel (Weblog) by Nayan Patel on 11-13-2008
Text Qualifier in Column Names

If you have a flat file with quotes around the data as text qualifiers you may have seen the issue where the headers has the quotes even after you put the quote in as the text qualifier. This is a simple issue to resolve. If you check the box “Columns names in the first data row” SSIS sets the first...

Posted to Mike Davis (Weblog) by Mike Davis on 10-31-2008
Sql Server 2008 Launch Jacksonville

I will be speaking at the SQL server 2008 Launch in Jacksonville, FL. My sessions are: Converting DTS to SSIS : 11-Noon Reporting Services : 1-2pm http://www.sqlsaturday.com/eventhome.aspx?eventid=10 Join us on Friday, September 12, 2008, for a one day look at the new features of SQL Server 2008 as we...

Posted to Mike Davis (Weblog) by Mike Davis on 09-11-2008
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
SSIS Lab: Runtime Performance Differences Between DTS and SSIS

Even though you can indeed run DTS packages from within SSIS the solution is only partially complete. In Management Studio, you can manage your DTS packages under Managment --> Legacy --> Data Transformation Services. From here, you can open packages, import new ones but you cannot create a new...

Posted to Brian Knight (Weblog) by Brian Knight on 03-12-2008
SQL Server 2005 with SSIS must be installed before installing DTSxChange

I've downloaded DTSxChange v1.6, but I'm running into a problem... I get the message "SQL Server 2005 with SSIS must be installed before installing DTSxChange" when attempting to install, even though I have SQL Server 2k5 and SSIS installed. I am, however, running 64bit Vista... is...

Posted to DTS xChange (Forum) by ddarden42 on 11-14-2007
Private Beta for DTS xChange Open

Have a load of DTS packages to convert? DTS xChange will convert them in a flash and allow you to utilize all the SSIS features. Tasks that don't convert normally into SSIS convert in a snap with DTS xChange. We're looking for a few customers to beta test the product to ensure that our years...

Posted to DTS xChange (Forum) by Brian Knight on 09-05-2007
Migrating From DTS to SSIS

In this Powerpoint from a SSIS road show, you can see this presentation from Brian Knight on converting DTS packages to SSIS.

Posted to Business Intelligence (FileGallery) by pragmaticworks on 08-10-2007

Page 1 of 1 (10 items)