Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ETL tool Requirement Expand / Collapse
Author
Message
Posted Wednesday, May 13, 2009 12:16 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 5, 2013 7:41 AM
Points: 1,146, Visits: 230
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?



Post #715686
Posted Wednesday, May 13, 2009 6:06 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, October 21, 2013 12:32 AM
Points: 2,551, Visits: 2,593
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)
FROM Master.dbo.SysColumns t1
CROSS JOIN Master.dbo.SysColumns t2



--Ramesh

Post #715853
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse