Browse by Tags

DTS Packages migration webinar - get tips and tricks from a MVP

Published 15 July 8 10:44 AM | SSQA.net

Brian Kinight is well known SQL Server Professional in the community, every user will know about SQL Server Central website which was founded by him. Join Brian to discuss the strategies of upgrading DTS packages to SQL Server Integration Services (SSIS...

Filed under: sql server, webcast, mvp, dts, best practices, migration, webinar

SQL Server Integration Services (SSIS) - learning materials and web resources for beginners

Published 7 April 8 5:38 AM | SSQA.net

Recently when I had a task to identify the learning materials (free) and web resources for SQL Server Integration Services (SSIS), then first place I have used is MVP private newsgroups. You will appreciate the immediate help I received from fellow MVPs...

Filed under: sql server, package, ssis, search, BOL, dts, learning, source, web resource, beginner

Installing SQL Server Integration Services on 64-bit Computers

Published 19 November 7 8:29 AM | SSQA.net

I had tough time working with Integration Services (SSIS) on one of the 64 bit machine that will be used for a 24/7 based application. So here goes my ranting and things you need to take care when having installation of SQL Server 2005 on 64 bit platform...

Filed under: sql server, microsoft, ssis, download, dts, database mirroring, x64, etl, integration services, compatability, backward

Best option to choose when importing data from a text file where heavy inserts and updates are involved!

Published 8 November 7 1:49 AM | SSQA.net

A specific task of importing data from a text file or any data source where heave inserts and updates are involved is quite common scenario in any SQL Server platform. So when you need to perform such actions on regular basis you need what's the best...

Filed under: sql server, ssis, dts, best practices, etl, bcp, data files, integration services

FIX: You cannot run some SQL Server 2005 Integration Services packages in Business Intelligence Development Studio if you also run the same packages by using the Dtexec.exe utility

Published 29 October 7 1:22 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: You cannot run some SQL Server 2005...

Filed under: sql server, package, ssis, kba, dts, bids, integration services, dtexec

SQL Server DTS: Dynamically Change Source and Destination in Transform Data Task

Published 10 October 7 3:24 PM | SSQA.net

I found this useful blog SQL Server DTS: Dynamically Change Source and Destination in Transform Data Task that I would like to share the users that are sub-merged with DTS tasks....( read more ) Read More...

Filed under: sql server, ssis, database, dts, connections, dynamic

How to determine the version of SQL Server 2005 Integration Services

Published 8 October 7 2:46 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, ssis, kba, version, dts, integration services

DTS to SSIS package migration, unable to find migrated package?

Published 2 October 7 5:10 AM | SSQA.net

Yikes, I can't see the DTS package that has been migrated from DTS to SSIS. This was the expression by one of the database user at our end. As you may be aware using Package Migration wizard you can migrate the DTS packages to SSIS within SQL Server...

Filed under: sql server, package, ssis, technet, dts, bids, wizard, migration

How to set up the Master DTS and OLAP packages to run as a scheduled job in Microsoft SQL Server 2005

Published 22 August 7 3:48 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Analysis Cubes for Microsoft SQL Server 2005 Notification Contents: New and All Modifications How to set up the Master DTS and OLAP packages to run as a scheduled job in Microsoft...

Filed under: sql server, analysis, olap, kba, dts, cubes, scheduled job

Downgrade or revert or restore SQL Server 2005 database to SQL Server 2000 version

Published 20 July 7 3:21 AM | SSQA.net

Can somebody tell me, it is possible to convert a database developed in sql2005 back to sql2000? A common question now a days in the forums and newsgroups, as you are aware UPGRADE process is available to enhance SQL 2000 database to SQL 2005 as per the...

Filed under: sql server, ssms, database, upgrade, dts, management studio, degrade

A Guided Tour to SQL Server Integration Services (SSIS)

Published 16 July 7 8:2 AM | SSQA.net

I have been asked many of our developers and even got through few questions asking about how to understand SQL Server Integration Services which is a traditional extract methods with a transform, and load (or ETL) model of integrating data from standard...

Filed under: sql server, ssis, ssas, ssms, dts, etl, tour

SQL Server 2008 and DTS supportability?

Published 6 July 7 12:13 PM | SSQA.net

They (MS) said DTS will be wiped out after SQL Server 2005 and will not be supported, more and more SSIS is promoted to use. But within SQL Server "Katmai" DTS is included with a provision of management, run-time, and design-time support for...

Filed under: sql server, ssis, katmai, dts, 2008, support, sample