SQLBits IV Session Submission now open.

by Allan Mitchell 27 Dec 2008 13:40

 

The next installment of the increasingly popular community conference (FREE) is going to take place in Manchester on 28.03.2009 (Saturday).  This is an excellent place for you to get some experience in speaking and telling a couple of hundred people something about SQL Server which really rocks your world and you want to let people know or to learn something new yourself.

We will be there as we have been for all the SQLBits events.  We really enjoy the day and love to meet the people who visit our blog so…

Submit a session here

We also would love to hear from anyone that wants to sponsor the event.  Without sponsorship this event cannot happen.

Sponsor the event

 

Hope to see you there!

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

RecentComments

Comment RSS
SQLIS | Data Generator Source Adapter

Data Generator Source Adapter

by Darren Green 5 Jun 2012 14:19

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

Data Generator Editor 2005
SQL Server 2005 Integration Services
Data Generator Editor 2008/2012
SQL Server 2008/2012 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 SQL Server 2005, SQL Server 2008 (includes R2) and SQL Server 2012. Please choose the version to match your SQL Server version, or you can install multiple versions and use them side by side if you have more than one version of SQL Server installed.

Data Generator Source Adapter for SQL Server 2005

Data Generator Source Adapter for SQL Server 2008

Data Generator Source Adapter for SQL Server 2012

Version History

SQL Server 2012

Version 3.0.0.30 - SQL Server 2012 release. Includes upgrade support for both 2005 and 2008 packages to 2012.
(5 Jun 2012)

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)

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

RecentComments

Comment RSS