Browse by Tags

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

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