Data Generator Source Adapter

by Allan Mitchell 11 Oct 2008 02:21

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. 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.

This component is used by us to do testing of the pipeline and components downstream. Previously we would have used a script component (as a source) to generate the rows but found ourselves rewriting the code too often so created this component.

Screenshots

SQL Server 2005 Integration Services

SQL Server 2008 Integration Services

The component is provided as an MSI file, however to complete the installation, you will have to add the transformation to the Visual Studio toolbox manually. Right-click the toolbox, and select Choose Items.... Select the SSIS Data Flow Items tab, and then check the Data Generator Source from the list.

Downloads

The Data Generator Source Adapter is available for both SQL Server 2005 and SQL Server 2008, and now supports seamless upgrades. Please choose the version to match your SQL Server version, or you can install both versions and use them side by side if you have both SQL Server 2005 and SQL Server 2008 installed.

Data Generator Source Adapter for SQL Server 2005

Data Generator Source Adapter for SQL Server 2008

Version History

SQL Server 2008

Version 2.0.0.29 - SQL Server 2008 February 2008 CTP. Includes support for upgrade of 2005 packages. Simplified user interface.
(4 Mar 2008)

Version 2.0.0.27 - SQL Server 2008 November 2007 CTP. String columns will now use the default system code page. Previously string columns always used 1252.
(15 Feb 2008)

SQL Server 2005

Version 1.1.0.23 - SQL Server 2005 RTM Refresh. SP1 Compatibility Testing.
(12 Jun 2006)

Version 1.0.0.0 - SQL Server 2005 IDW 16 Sept CTP. Public release.
(6 Oct 2005)

Currently rated 5.0 by 1 people

Currently 5/5 Stars.
1
2
3
4
5

Tags component, custom components, download

Categories Component Downloads | Sources

Creating packages in code - Flat File Source to OLE-DB Destination (SQL Server)This code sample programmatically creates a package that imports a text file into SQL Server, with a...Creating packages in code - OLE-DB Source to Flat File File DestinationThis code sample programmatically creates a package with an OLE-DB Source and a Flat File Destinatio...Trace File Source AdapterThe Trace File Source adapter is a useful addition to your SSIS toolbox. It allows you to read...

Add comment

Name*
E-mail*
Website
Country

* Required fields. Your email address will not shown, check the preview for what you see. We use it to send you notifications on new comments if you ask us to below. b i u quote

Comment
Preview

Notify me when new comments are added

Popular this month

Posts	Hits
The Execute SQL Task	1266
Looping over files with the Foreach Loop	829
File Watcher Task	560
For Loop Container Samples	496
Get all from Table A that isn't in Table B	473
Easy Package Configuration	424
Row Number Transformation	414
Change Data Capture Webinar	315
Checksum Transformation	298

RecentComments

SSIS and SQL Server Instances (1)
Raleigh Painting Services wrote: Hi nice site design James [More]
File Watcher Task (40)
Mohammed Mohsin wrote: Hi, Could you please let me know if you would b… [More]
The Execute SQL Task (31)
Fabien Lonardi wrote: Very good document. But how to call an Oracle st… [More]
Checksum Transformation (27)
c34miller wrote: Related to this error: System.ArgumentException: I… [More]
File Watcher Task (40)
Odalys wrote: Thank you for making this available. I plan to use… [More]
Checksum Transformation (27)
Kazi Islam wrote: I also have the same intermittent error: System.A… [More]
Checksum Transformation (27)
Ellen Russell wrote: I also get the intermittent error: System.Argumen… [More]
Row Count Plus Transformation (12)
Tobias Müller wrote: Hi! Thanks for developing Row count plus. It helps… [More]
Looping over files with the Foreach Loop (35)
Mike wrote: Thanks man! That was really helpful! [More]
Where is my app.config for SSIS? (5)
Jyotin Shah wrote: Darren, Thanks a bunch for this post. What'… [More]
Creating packages in code - Flat File Source to OLE-DB Destination (SQL Server) (6)
umair wrote: Hi, This is code working perfectly for me. I j… [More]
Creating packages in code - OLE-DB Source to Flat File File Destination (6)
umair wrote: Hi, This is code working perfectly for me. I j… [More]
Downloading a file over HTTP the SSIS way (8)
Kanthi wrote: Hi Darren, Your Script Works Like a Charm. … [More]
Row Number Transformation (11)
Ellen Russell wrote: Regarding the Int32 error issue: It appears the t… [More]

Comment RSS

SQL Server Integration Services - SSIS

Data Generator Source Adapter

Screenshots

Downloads