You can't assign a return a value from a stored procedure to a global variable this way. The global variable settings in the parameter screen only work with resultsets returned...

Steve

I must admit I've only had 1 or 2 adventures with the scripting, and each them was a horrible disaster.

If you don't want to publish all reports in the project...

I struggled along with the single level folders in Visual Studio for a while. I now have one report project with one folder for reports and one for datasources. The...

In the transformations, exclude the identity column, and on the Options tab make sure "Enable Identity Insert" isn't checked. Then the sequence numbers will be automatically incremented.

Alerts are not bound to MAPI mail, and if you're just using xp_smtp_sendmail in DTS then you're under utilising it. We use xp_smtp_sendmail for ALL emails that originate from SQL...

Try xp_smtp_sendmail from http://www.sqldev.net

Where did you want to run the stored procedure, in an ExecuteSQL task, or a Datapump task?

Either way, it's basically the same, EXEC stored_proc_name @param1=?, @param2=?, etc...

Then click the parameters button...

Cool

Can I make one suggestion? How about adding an option for quoting identifiers? eg: in SQL 2000 you have square brackets, in Progress you...

You mean you want to find out what server the SQL connection in the DTS package is pointed to? You can't do this in T-SQL because the package is stored...

You'll need a bit of T-SQL coding

First you'll need to record the previous run duration. Maybe store an average value for past executions.

Record...

The Net Send doesn't have anything to do with SQL Mail. It uses the messenger service which is disabled in Sp2. If you have to have the alerts sent via...

Maybe if you provided a bit more info, like server version and error message, we might have an idea to give you

Take a look at the examples at http://www.sqldts.com to test for file existence.

Or you could use one of the many string splitting functions that are floating around.

Here's one,

CREATE FUNCTION dbo.udf_SplitChar (@vcrStrAry varchar(8000), @chrDelim char(1))
RETURNS @Results TABLE ( Items varchar(8000) )
AS
BEGIN
 DECLARE @intPos int
 DECLARE...

"Keep in mind, you can't take PDF file from the outpput. It supports either Txt or CSV for export."

Ok, I'm confused, I must be using a special version of Reporting...