Have I been doing it wrong?

Not necessarily, in my last job we used T-SQL exclusively to do transformations.  Except we called SP's using the Execute SQL Task.  It worked well for...

Here's a few DBA books for you:

Portable DBA SQL Server by Bersinic, Giles - a small book, just the basics to get you started.  Not a "Dummies" book, no fluff.

SQL...

Here is one way to do it:

http://www.sqldts.com/default.aspx?246

Another way is the way I've done it in my last job.  Create a parent package, create a ActiveX script to loop through...

You might have problems, so its best to change the ownership of the objects.  For the stored procedures, if they are owned by the developers login and not 'dbo', use the...

Take a look at Professional SQL Server 2000 DTS:

http://www.amazon.com/exec/obidos/tg/detail/-/0764543687/qid=1120679330/sr=1-1/ref=sr_1_1/102-2634227-9118521?v=glance&s=books

My copy is well used

Diane

Here is another article on this subject:

http://www.joesack.com/SQLServer_Email_Reports.htm

Note to all:  The Send Mail task only works in a Outlook/Exchange environment.  The SQL Server must already be set up to send...

A good article but your points got lost in the wordiness. A little brevity please.

The default data access technology when moving from one SQL Server to another is OLE-DB for SQL Server.  When you create a connection object in DTS the drop down for "Data Source"...

Microsoft did not put out a replacement for the MS SQL Server 7.0 data warehousing exam. So you will have to find a another exam to take. 

I think getting...

Would these be packages that are running as part of a job or packages that someone is currently running manually?

Diane

Their is an excellent book out called "Real-World SQL-DMO for SQL Server" by Allan Michell and Mark Allison. It has all the code you are looking for.

Diane

You can use the DTS object model within a ActiveX script task. Use the following code to put the Name and ID's into Global Variable's

Dim objCurrentPackage

Set objCurrentPackage = DTSGlobalVariables.Parent

DTSGlobalVariables("PackageName")...

That's what we use just DTS and sp's for the transformations. Works well for us. Their is a learning curve with DTS, and DTS does have it's quirks,...

Put your delete code inside a stored procedure and call the sp from the Execute SQL Task, passing in the date value as a parameter.

Diane

To get the quarter to return as Q1, Q2, and so on, use the following for the quarter column:

'Q' + cast(DATEPART(qq, INDEX_DAT) as varchar(2)) AS TheQuarter

Happy coding,

Diane