Sending Mail In SSIS Using Script Task- Simpler and Flexible Approach
Script Task in SSIS can provide simpler implementation of complex mail functionality in comparison to Send Mail task.
2009-05-06
23,513 reads
Send Mail Task
Comparing Dates - using DateADD features
I have a data integration process that moves alot of data around on servers. Accordinlgy, I keep 5 days worth of local table copies for two of our most pressing tables. One PROC in my process is giving me trouble - most definitely because I have limited experience with manipulating dates.My current proc works perfectly, EXCEPT […]
2005-02-01
17 reads
RE: help with a sql query
When you're dealing with outer joins, it becomes very important where you place your criteria - in the ON clause or in the WHERE clause. Depending on placement, the actual query answers entirely different questions.For your question, I think you want to look for Billie in the WHERE clause.. Try this out:select t1.id, t2.first_name, t3.first_name […]
2005-02-01
RE: Trace all the transactions applied to a table
quote: I am looking for a way to capture all the transactions applied to a single table in a database for audit purposes. I do not want to use triggers if at all possible. Can I get this level of granularity using Profiler trace? Crosspost?!? Cheers, Frank
2003-06-17
2 reads
RE: doh
Ritch, First thing I'd follow up on is the "this has happened a number of times at various sites" bit. I've worked with SQL2000 quite a bit and seen a real corruption about twice. One needed a point in time recovery from a backup, an another I got lucky and only need to recreate an […]
2003-06-13
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers