Generating Test Data with Integration Services

  • Kristian Wedberg

    SSC Veteran

    Points: 297

    Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/kwedberg/generatingtestdatawithintegrationservices.asp

  • Amit Lohia

    SSCertifiable

    Points: 6104

    nice article.


    Kindest Regards,

    Amit Lohia

  • david russell-253790

    SSCarpal Tunnel

    Points: 4042

    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

  • david russell-253790

    SSCarpal Tunnel

    Points: 4042

    Whoops!  "necessitated"

    Don't you just HATE that ?

     


    Cheers,

    david russell

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

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