The Trash Destination is now available for SQL Server 2005 and SQL Server 2008. 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.
2008-03-10
1,272 reads
Expressions can be used to dynamically build an output file. Here we will show you another way to do this using the script task.
2008-03-05
2,879 reads
This article explains how to import text files using SSIS in those cases where the text files have different formatted data on different rows. The solution recommended involves minimal coding and is highly maintainable.
2008-03-05
8,848 reads
In this article Dinesh Asanka demonstrates how you can use your own data sources in SQL Server Integration Services.
2008-03-04
1,650 reads
Longtime author Paul Ibison brings us a short look at a common problem in Integration Services: your source has no column names.
2008-02-27
7,413 reads
In this article Dinesh Priyankara explains how Checkpoint files can be used in a SSIS package so that the package can be restarted from the point of failure.
2008-02-25
1,528 reads
Describes different uses of the SSIS Foreach Loop container in one practical scenario.
2011-04-04 (first published: 2008-02-25)
39,840 reads
Integration Services allows you to import all kinds of data easily into SQL Server as well as transform is along the way. Longtime author Paul Ibison brings us a look at how you should set your transformations to deal with NULL values.
2008-02-13
14,124 reads
Use the power of regular expressions to cleanse your data right there inside the Data Flow. This transformation includes a full user interface for simple configuration, as well as advanced features such as error output configuration.
2008-02-11
1,704 reads
Microsoft MVP Andy Leonard brings us a great introduction to a common task for all DBAs: importing data. (from Feb 2008)
2009-08-14 (first published: 2008-02-11)
36,398 reads
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Comments posted to this topic are about the item Your Value from a Conference
Comments posted to this topic are about the item UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers