Post reply

ETL tool Requirement

  • May 13, 2009 at 12:16 am

    #130088

    HI All,

    I am new to SSIS, I want to load temporary data (if possible table generation through query also), for

    my QA server on which i can test my cubes and all.

    is it possible to load dummy data through SSIS, how?

    is there any tool available in the market for such ETL requirement?

  • May 13, 2009 at 6:06 am

    #993602

    There are tools available in the market such as Red Gate's "SQL Data Generator" etc. Try googling for it and I am there are many free tools available for it.

    You can also write a query to generate random test data like..

    Thanks to Jeff for the below test code:

    -- Create and populate a 1,000,000 row test table.

    -- Column "RowNum" has a range of 1 to 1,000,000 unique numbers

    -- Column "SomeInt" has a range of 1 to 50,000 non-unique numbers

    -- Column "SomeLetters2" has a range of "AA" to "ZZ" non-unique 2 character strings

    -- Column "SomeMoney has a range of 0.0000 to 99.9999 non-unique numbers

    -- Column "SomeDate" has a range of >=01/01/2000 and <01/01/2010 non-unique date/times

    -- Column "SomeCSV" contains a simple identical 10 part CSV for all rows.

    -- Column "SomeHex12" contains 12 random hex characters (ie, 0-9,A-F)

    SELECT TOP 100

    SomeInt = ABS(CHECKSUM(NEWID()))%50000+1,

    SomeLetters2 = CHAR(ABS(CHECKSUM(NEWID()))%26+65)

    + CHAR(ABS(CHECKSUM(NEWID()))%26+65),

    SomeCSV = CAST('Part01,Part02,Part03,Part04,Part05,Part06,Part07,Part08,Part09,Part10' AS VARCHAR(80)),

    SomeMoney = CAST(ABS(CHECKSUM(NEWID()))%10000 /100.0 AS MONEY),

    SomeDate = CAST(RAND(CHECKSUM(NEWID()))*3653.0+39446.0 AS DATETIME),

    SomeHex12 = RIGHT(NEWID(),12)

    FROMMaster.dbo.SysColumns t1

    CROSS JOIN Master.dbo.SysColumns t2

    --Ramesh

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply