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

Generating Test Data with Integration Services Expand / Collapse
Author
Message
Posted Thursday, August 04, 2005 6:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 12, 2013 12:43 PM
Points: 7, Visits: 52
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/kwedberg/generatingtestdatawithintegrationservices.asp
Post #207717
Posted Monday, August 29, 2005 5:17 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Saturday, January 22, 2011 12:01 PM
Points: 702, Visits: 174
nice article.


Kindest Regards,

Amit Lohia
Post #215112
Posted Tuesday, October 11, 2005 5:00 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 22, 2006 2:23 PM
Points: 254, Visits: 1

Helpful article now that I am actually trying to use the Script Component.  One thing that has baffled me from the beginning - and necessated the use of the Script Component is the lack of an "Execute SQL" capability in any of the toolbars - both those present on the Package Editor page, or elsewhere.

You made reference to "Add two Execute SQL Task components and " and they just are not there to be added.

I presume you developed this from an earlier beta since you referred to "DTS" at one point, and since you also said something about "VBA", since the language used in the Script Component is "VSA"... granted, "based" on VBA; but too new for there to be books out there on it.

Test data is always a problem.  I spent 18 months on a project with Boeing managing a team of five doing nothing but building test data.  It can be painful.  It's nice to have the basis for a tool; but MUCH more interesting to see SSIS in action as I struggle to make it work for me.  Thank you.




Cheers,

david russell

Post #228147
Posted Tuesday, October 11, 2005 5:02 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 22, 2006 2:23 PM
Points: 254, Visits: 1

Whoops!  "necessitated"

Don't you just HATE that ?

 




Cheers,

david russell

Post #228148
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse