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

Data Import Functionality Using SQL Server Expand / Collapse
Author
Message
Posted Wednesday, October 23, 2002 12:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 20, 2002 12:00 AM
Points: 2, Visits: 1
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/JTallamraju/data_import_functionality_using.asp


Post #7651
Posted Thursday, October 24, 2002 9:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 20, 2002 12:00 AM
Points: 2, Visits: 1
Paul,

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





Post #44589
Posted Wednesday, October 30, 2002 6:24 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 28, 2003 12:00 AM
Points: 2, Visits: 1
One 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 Execute Package Task for the existing package of ETL tasks. The Send Mail Task is moved to the controller package with an On Failure constraint from the Execute Package Task. Pass the path of the ETL package's log file back to the controller package as a global variable. Set the FileAttachments property of the Send Mail Task 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.)




Post #44590
Posted Monday, September 22, 2003 6:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 19, 2008 1:52 AM
Points: 2, Visits: 5
This 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




Post #44591
Posted Thursday, June 17, 2004 6:36 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, January 5, 2011 10:15 AM
Points: 175, Visits: 74
I'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.



Post #121738
Posted Tuesday, March 1, 2005 11:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 27, 2005 5:17 AM
Points: 1, Visits: 1

Hi,

Could you please let me know the URL, where i can find the Sample Code for this.

Thank You

Post #164891
Posted Wednesday, March 2, 2005 1:17 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, December 15, 2014 7:14 PM
Points: 2,693, Visits: 1,223

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.

 



Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface

Australian SQL Server User Groups - My profile
Phills Philosophies
Murrumbeena Cricket Club
Post #164906
Posted Monday, August 15, 2005 10:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 17, 2005 5:58 PM
Points: 1, Visits: 1

Why don't you provide database ?

Post #210533
Posted Tuesday, August 16, 2005 5:40 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, June 21, 2011 10:03 AM
Points: 577, Visits: 102
"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.

cl


Signature is NULL
Post #211059
Posted Friday, August 8, 2008 5:51 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 12, 2008 1:26 PM
Points: 1, Visits: 2
:D
Post #549660
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse