SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Data Import Functionality Using SQL Server


Data Import Functionality Using SQL Server

Author
Message
tjayram
tjayram
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 1
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/JTallamraju/data_import_functionality_using.asp



tjayram
tjayram
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 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



layne
layne
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 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.)



irhm
irhm
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 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



Oblio Leitch
Oblio Leitch
SSC Veteran
SSC Veteran (275 reputation)SSC Veteran (275 reputation)SSC Veteran (275 reputation)SSC Veteran (275 reputation)SSC Veteran (275 reputation)SSC Veteran (275 reputation)SSC Veteran (275 reputation)SSC Veteran (275 reputation)

Group: General Forum Members
Points: 275 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.



Dhanunjay Kumar Vootada
Dhanunjay Kumar Vootada
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 1

Hi,

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

Thank You


philcart
philcart
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4390 Visits: 1436

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
Marco Esquivel
Marco Esquivel
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 1

Why don't you provide database ?


Calvin Lawson
Calvin Lawson
SSC Eights!
SSC Eights! (934 reputation)SSC Eights! (934 reputation)SSC Eights! (934 reputation)SSC Eights! (934 reputation)SSC Eights! (934 reputation)SSC Eights! (934 reputation)SSC Eights! (934 reputation)SSC Eights! (934 reputation)

Group: General Forum Members
Points: 934 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
mcajanarth
mcajanarth
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 2
BigGrin
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search