Have you used Global Variables set from a Configuration table or prompted from the DTS package/ActiveX and declare the parameters

Hi Sarah,

Here's a link that describes what you / how you need to proceed. 

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

hth

Hi Steve and all users of the QOD forum.

This QOD site is a tremendous help to me, and I'm sure for others too.  Why was the forum created?  For just that...

The transaction is managed within the Workflow Properties/Options.  Look at the section labeled 'Transaction'

Presumption being the mother of all screw-ups, it seemed clear to me that this was written for the PUBS database, so I ran it there without error.  It is obvious...

As you say - they are tough to read.  I usually create a system activity table and use a stored procedure called from the DTS package to record the activity.  Here's...

DTS has such logging built into it.  Just enable it through DTS Package Properties

I evaluate my control and set a variable that is used to enable or disable the 'next' DTS step.  This particular example is used for looping a set of files,...

In addition, you will need to declare the Global Variable(GV), either in your code or at the DTS package level.  I would suggest declaring it at the package level. 

Open...

Description, is a word known to SQL Server, hence the coloring of the word to blue which is the clue that the program is treating it as an embedded term...

Are you looking to total some value(Sales) by year?  You may want to consider using something like:

Select Total(Sales) Group By Year(SalesDate)

For example:

SELECT PaidDate, sum(AmountPaid) FROM Payments Group By PaidDate...

It sounds like you want to import a *.DTS file.  If that's the case then:

1) Open SQL Server

2) Click on Data Transformation Services

3) Click on Action on the Menu Bar

4)...

DTS is the way to go and it is very powerful.  There is an excellent book called SQL Server 2000 DTS(Wrox) with lots of examples and code, and @850 pages of...

Thank you Calvin - it sounds relatively easy.  I was missing the Dynamic Properties Task part.  It sounds like a loader/variable manager applet.  Will see what I can come up...

That was exactly what I needed!  I'm having some teething problems with SQL Server but what I've seen so far is very impressive and you have helped me greatly -...