SqlServer-QA.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). As this is a web seminar it is free and will have a definitive ...

I am using ssma to migrate db from oracle 9i to sql server 2000. I successfully migrated oracle tables,views,procedures,functions etc.. But can you please help me on how to migrate packages,triggers and indexes? Here i can able to view the headings like''Triggers'', ''packages'', ''Indexes'' in SSMA. But none of my oracle objects are displaying ...

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 in getting the list swiftly, they are as follows: Books Online (updated) - As the ...

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, specially within ETL processes completion. So at first, when you install SQL Server ...

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 way to import data from text files into SQL Server where a mix of inserts and updates is ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard EditionNotification Contents: New and Major Modifications FIX: You cannot run some SQL Server 2005 Integration Services packages in Business Intelligence Development Studio if you also run the ...

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.

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 EditionNotification Contents: New and Major Modifications How to determine the version of SQL Server 2005 Integration ...

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 2005 version. The migration will be completed if there are issues, as a best practice ...

The following pages were recently modified. Source: Knowledge BaseProduct: Analysis Cubes for Microsoft SQL Server 2005Notification Contents: New and All Modifications How to set up the Master DTS and OLAP packages to run as a scheduled job in Microsoft SQL Server 2005http://support.microsoft.com/kb/930309/en-US