SSIS
Get flash to fully experience Pearltrees
www.solidq.com/sqj/JournalDocuments/2011-July-Issue/Building-an-SSIS-Management-Framework-Part-1.pdf
Here are the 10 SSIS best practices that would be good to follow during any SSIS package development § The most desired feature in SSIS packages development is re-usability. In other ways, we can call them as standard packages that can be re-used during different ETL component development.
SQL Server Integration Services (SSIS) 10 Quick Best Practices - SQL Server - The One Stop Shop
SSIS Junkie : SSIS: Suggested Best Practices and naming conventions
I thought it would be worth publishing a list of guidelines that I see as SSIS development best practices. These are my own opinions and are based upon my experience of using SSIS over the past 18 months. I am not saying you should take them as gospel but these are generally tried and tested methods and if nothing else should serve as a basis for you developing your own SSIS best practices. One thing I really would like to see getting adopted is a common naming convention for tasks and components and to that end I have published some suggestions at the bottom of this post.
In the first step of my SSIS package I need to get files from FTP and dump it/them in a local directory, but it's more than that, the logic is like this: 1. If no file(s) found, stop executing and send email saying no file(s) found;
Script task: how to compare files on FTP with existing files in local folder before transfer!
Code Plex Project Hosting for Open Source Software SSIS Community Tasks and Components Home SpatialGrid
SSIS Community Tasks and Components
Code Plex Project Hosting for Open Source Software SSIS Community Tasks and Components Home
SSIS Community Tasks and Components
Ensuring consistency of the data stored in Active Directory should be one of the top priorities in achieving the overall security of an enterprise. By consistency in this context I imply how well the organization structure of a company is represented inside Active Directory, i.e. how accurately group memberships are mapped to the business tasks assigned to the employees. This task could only be accomplished by instituting regular and vigorous data analysis procedures.
Active Directory Data from Extract Load and Transform (ETL) perspective - Alex Tcherniakhovski - Security
SSIS Community Tasks and Components
This Script appeared originally on MSDN's Integration Services Forum courtesy Matthew Qualls: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/2b7cf6b5-d16d-44cd-954d-68e9ba98ee91/ ' Microsoft SQL Server Integration Services Script Task ' Write scripts using Microsoft Visual Basic ' The ScriptMain class is the entry point of the Script Task.
SSIS Community Tasks and Components
Code Plex Project Hosting for Open Source Software SSIS Community Tasks and Components Home
Parallel execution improves the performance on the computers that have multiple physical or logical processors. To support parallel execution of different tasks in the package, SSIS uses two properties: MaxConcurrentExecutables and EngineThreads. In my next article on SSIS Parallel processing I will cover how you can utilize the parallel processing capabilities of SSIS.
SSIS Parallel Processing
Published: January 16, 2006 Writers: Elizabeth Vitt, Intellimentum and Hitachi Corporation Contributors: Donald Farmer, Microsoft Corporation; Ashvini Sharma, Microsoft Corporation; Stacia Misner, Hitachi Consulting Applies To: SQL Server 2005 Summary: This white paper describes common performance-tuning techniques that you can apply to your SQL Server Integration Services (SSIS) data integration solutions. On This Page