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,898 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,471 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,919 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,242 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 Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
Hub Via Wa:628218154374 Alamat Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa...
Hub Via Wa:628218154374 Alamat Bank Bca Kcu Purwakarta, Jl. Jendral Sudirman No.85, Nagri Tengah,...
Hub Via Wa:628218154374 Alamat Jl. Soekarno-Hatta No.240, Kb. Lega, Kec. Bojongloa Kidul, Kota Bandung,...
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers