SQLServerCentral / Discuss Content Posted by Kristian Wedberg / Article Discussions / Article Discussions by Author / Generating Test Data with Integration Services / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 10:14:28 GMT20RE: Generating Test Data with Integration Serviceshttp://www.sqlservercentral.com/Forums/Topic207717-245-1.aspx<P>Whoops! "<SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">necessitated"</SPAN></P><P><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">Don't you just HATE that ?</SPAN></P><P><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"></SPAN> </P>Tue, 11 Oct 2005 17:02:00 GMTdavid russell-253790RE: Generating Test Data with Integration Serviceshttp://www.sqlservercentral.com/Forums/Topic207717-245-1.aspx<P>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.</P><P>You made reference to "Add two Execute SQL Task components and " and they just are not there to be added.</P><P>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.</P><P>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.</P>Tue, 11 Oct 2005 17:00:00 GMTdavid russell-253790RE: Generating Test Data with Integration Serviceshttp://www.sqlservercentral.com/Forums/Topic207717-245-1.aspxnice article.Mon, 29 Aug 2005 17:17:00 GMTAmit LohiaGenerating Test Data with Integration Serviceshttp://www.sqlservercentral.com/Forums/Topic207717-245-1.aspxComments posted to this topic are about the content posted at <A HREF="http://www.sqlservercentral.com/columnists/kwedberg/generatingtestdatawithintegrationservices.asp">http://www.sqlservercentral.com/columnists/kwedberg/generatingtestdatawithintegrationservices.asp</A>Thu, 04 Aug 2005 18:21:00 GMTKristian Wedberg