I love using this method for things like this.

Open the Disconnected Edit dialog.  Locate the Execute SQL task and get the exact name. It's ususally something like "DTSTask_DTSExecuteSQLTask_1"...

To better understand what's going on, consider the following:

The main package has basically two different types of tasks; an Execute Process task and an ActiveX Script Task described...

T-SQL will implicitly convert the value from a string to a float.  DTS isn't so forgiving.

In the transformation, delete the connection from the source column to the destination,...

I don't have SQL Mail installed, nor will my IT admins allow me to install and configure it.  Here is my work around in an ActiveX Script Task.  You...

Forgot one thing...

If the @noErr variable is 0, you may want to set @out_contents as

'ERROR - Handle: ' + @hr + '; Method: ' + @errMethod + ';...

Here's a procedure that may solve the problem.  I suppose it all depends on where you need to actually execute the "Read File" from.  This proc takes in the...

I had to come up with a way to back them up rather than saving to an external file, and then to load them into VSS.

It was a...

My post must have executed the same time as your followup.

If you're using TSQL as your source of the data pump task, you can still follow the examples above.  Dig...

This should do it...

' Assuming GV1 is formatted as YYYYMMDD
Dim sz_month, sz_dest, o_task
sz_month = Left(DTSGlobalVariables("GV1"), 6)
sz_dest = "[Database].[Owner].[Table_Prefix_" & sz_month & "]"

' If you don't know the...

I don't understand all the requirements, but have a look at this...

In your DTS, add an ActiveX object and a Source file object

Use a Scripting.FileScripting object to walk your source...

Whoops -- I added my post without going to page two, and now I see that TnJMoseley posted the exact same thing...

FYI - when I need to counts by date on a DateTime field where the time value is populated, I just zero out the time value with

SELECT CAST(Convert(VarChar(8), GetDate(), 112)...

AJ is absolutely correct.  Plus, you'll gain the advantage of logging (if you choose to do so) user activity -- ie, add LASTMOD_NM, LASTMOD_DT columns to your tables, add some...

Simple solution -- I do this all the time.

DELETE a

 FROM t_table a

 INNER JOIN t_table b

 ON (

  a.donor_id = b.donor_id AND

  a.id > b.id)

also check to make sure that the service account properties does not have password expiration. our domain has that policy and when the account was set up, by default, the...