OK, Kerstin.  Check in your package for an ActiveX script containting the inputBox function.  This will prompt for input from the user.  You could change this prompt to only prompt...

You cannot prompt for user input in stored procedures either.  The only way I see to prompt the user for input is to do as you plan and create a...

I don't consider myself a DTS guru, but I have worked with it a great deal and have created some pretty complicated packages.  I have never seen or heard of a...

I'm a bit confused.  So you did or did not get my example to work?  Also, isn't the point of this so that you can pass in your global variable...

Did you try my example?

The KB article that you posted earlier states that the fix for that problem is in SP2.  If you client has not applied SP2 as of yet, you should strongly...

It looks like you've got some redundant references to your package in your DTSRUN command string.  I can't say if this is your problem or not, but consider this example:

Set...

It's hard to give you more guidence on this without knowing more about the process.  Can you walk us through the logic of how you get a file, how you...

Yep, that works too.  Russel's solution will be simpler to write.  If all you need to do is send the SP results to a file and that file name can...

Carl's solution will work quite nicely if you can swing it.  Instead of moving all of your data, you change the view to point to the current data.  I know...

I think the best way to grasp what this is doing would be to set up some mock data and break the query down into parts to see what it...

DTS does have the ability to read in a text file.  If the file name is dynamic, you'll just have to get creative in designing your DTS tasks.  You could either read...

Yes, Sergiy is correct in saying that a SP will not stop the ability to insert more than 50 rows.  I was assuming that the SP would be used for...

I guess you could say they are Constants in the way that the article uses them as you would need to change the job to change the values.  I meant...

You've got a couple of options here.  Either create a stored procedure to 1. check the current row count; 2. delete oldest row if needed; 3. insert new row, or...