The Trash Destination and this article came from early experiences of using SSIS and community feedback at the time. When developing a package it is very useful to have a destination adapter that does nothing but consume rows with no setup requirement. You often want run a package part way through development, or just add a path so you can set a Data Viewer.
2008-05-29
1,183 reads
This component needs little explanation. It generates random integer (DT_I4) and string (DT_WSTR) data and places them in the pipeline. You specify how many columns of each you would like and for any string columns you pass a fixed length value. You then need to specify how many rows in total you require to be generated.
2008-05-28
2,077 reads
You can manage SSAS objects using AMO and SSIS which enables you to have detailed control of SSAS Administrative tasks.
2008-05-02
6,616 reads
Using Script Task in SSIS to resolve problem of NULL values loaded from Excel.
2008-04-28
27,950 reads
Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.
2010-09-03 (first published: 2008-04-23)
59,064 reads
New author Jack Corbett brings us a look at a way of finding out what caused your error in Integration Services.
2009-04-03 (first published: 2008-04-21)
44,756 reads
An article that speaks about some of the issues faced by the Author, during his Data Integration Project using SSIS. Shared with you in this article are the issues he was faced with and the solutions applied.
2008-04-02
3,879 reads
Integration Services, which replaces Data Transformation Services (DTS) in SQL Server 2005, is a tool for extracting, transforming, and loading data.
2008-03-27
4,921 reads
Construct event handlers in SQL Server Integration Services (SSIS) for executables. Get the flexibility of Control Flow and Data Flow tabs in Event Handler.
2008-03-21
3,443 reads
This paper describes the Fuzzy Lookup and Fuzzy Grouping transformations that are part of SQL Server 2005 Integration Services (SSIS). These SSIS transformations are useful for improving the data quality of existing data as well as new data that is being loaded into your database.
2008-03-14
1,809 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Comments posted to this topic are about the item Risk Vs Reward, The never...
Comments posted to this topic are about the item Hyperscale Replicas IV
Comments posted to this topic are about the item The SQL Server Date Magic:...
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers