The Data Generator Source is now available for SQL Server 2005 and SQL Server 2008. This component needs little explanation. It generates random integer (DT_I4) and string (DT_WSTR) data and places them in the pipeline.
2008-03-12
1,502 reads
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,912 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,490 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.
2009-11-13 (first published: 2008-02-25)
39,945 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,269 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
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Comments posted to this topic are about the item Reserved Words I