Browse by Tags

SQL Server Auditing and Logging - SSIS Audit Transformation comes handy for you in database platform

Published 21 August 8 3:40 AM | SSQA.net

If you work in Financial based Enterprise then Sarbanes-Oxley is not a new concept for you as per American law that regulates the accountability of publicly owned companies. Just to talk about t he main purpose of the law it to make sure the financial...

Filed under: SOX, sql server, performance, ssis, audit, bids, pack, authentication, transact sql, transformation

SQL Server Business Intelligence - adopt sustainable practices on ETL processes with SSIS

Published 24 April 8 6:14 AM | SSQA.net

Making best use of SQL Server Integration Services within your ETL processes is a flexible choice, which has a huge share within the Business Intelligence application platform. You may be aware that SSIS introduces several new and enhanced features and...

Filed under: sql server, ssis, ssas, ssrs, machine, bids, etl, administrator, biztalk, business intelligence, adapter

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

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

FIX: You experience problems when you use SQL Server Business Intelligence Development Studio to create an SSIS package after you install SQL Server 2005 Service Pack 2

Published 28 June 7 12:41 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications FIX: You experience problems when you use SQL Server Business Intelligence Development Studio to create an SSIS package after...

Filed under: sql server, ssis, kba, bids