InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 00:57:16 GMT20http://www.sqlservercentral.com/Forums/Topic7651-95-1.aspx:DFri, 08 Aug 2008 17:51:20 GMTmcajanarthhttp://www.sqlservercentral.com/Forums/Topic7651-95-1.aspx"Data Driven Query Task" suck, if you ask me. Other than that, it's a pretty good overview of what you can do with DTS. Personally, I put business rules in SQL code, preferably making it data driven so users can modify the imports in simple ways without changing code.clTue, 16 Aug 2005 17:40:00 GMTCalvin Lawsonhttp://www.sqlservercentral.com/Forums/Topic7651-95-1.aspx<P>Why don't you provide database ?</P>Mon, 15 Aug 2005 10:09:00 GMTMarco Esquivelhttp://www.sqlservercentral.com/Forums/Topic7651-95-1.aspx<P>As the article is over two years old and the author has not been active on the website since posting the article, I'd say the download is no longer available.</P><P> </P>Wed, 02 Mar 2005 01:17:00 GMTphilcarthttp://www.sqlservercentral.com/Forums/Topic7651-95-1.aspx<P>Hi,</P><P>Could you please let me know the URL, where i can find the Sample Code for this.</P><P>Thank You</P>Tue, 01 Mar 2005 23:55:00 GMTDhanunjay Kumar Vootadahttp://www.sqlservercentral.com/Forums/Topic7651-95-1.aspxI'm brand new to the whole DTS scene, and I found the article very helpful. However, my task involves some conditional processing. Could you help me by providing some examples of conditional logic for determining whether the current row is existing or not (ins vs upd)? I know very little VBscript/ActiceX, but I can extrapolate from examples.I really appreciate it.Thu, 17 Jun 2004 18:36:00 GMTOblio Leitchhttp://www.sqlservercentral.com/Forums/Topic7651-95-1.aspxThis is a very useful article, and should help get us started on our project. But I can't find the "download" scripts anywhere. Are they on this website?Iain Mon, 22 Sep 2003 06:24:00 GMTirhmhttp://www.sqlservercentral.com/Forums/Topic7651-95-1.aspxOne option to maintain the clean modularity of your notification task is to use two packages to organize or "scope" your code. The added "controller" package contains an <b>Execute Package Task</b> for the existing package of ETL tasks. The <b>Send Mail Task</b> is moved to the controller package with an <b>On Failure</b> constraint from the <b>Execute Package Task</b>. Pass the path of the ETL package's log file back to the controller package as a global variable. Set the <i>FileAttachments</i> property of the <b>Send Mail Task</b> to the global variable value so that the log file can conveniently be read as an attachment to the failure notification email.This would avoid the development burden of building a custom task or ActiveX script to avoid redundancy. (Of course, a custom task is the direction to go when you need powerful auditing or, especially, an error handler...but throwing COM or Visual Studio into the mix probably won't meet the spec for simplicity of maintenance.) Wed, 30 Oct 2002 18:24:00 GMTlaynehttp://www.sqlservercentral.com/Forums/Topic7651-95-1.aspxPaul,You are 100% right. This is very good point. Sample code I supplied uses this approach but failure notification is never sent if process fails initially in any of the tasks. I guess best approach in this case is to have separate failure notification task in each case. Thanks for your valuable comments.Jay Thu, 24 Oct 2002 21:38:00 GMTtjayramhttp://www.sqlservercentral.com/Forums/Topic7651-95-1.aspxComments posted to this topic are about the content posted at <A HREF=http://www.sqlservercentral.com/columnists/JTallamraju/data_import_functionality_using.asp>http://www.sqlservercentral.com/columnists/JTallamraju/data_import_functionality_using.asp</A>Wed, 23 Oct 2002 00:00:00 GMTtjayram