You can't assign parameters for extended stored procedures the same way as normal procedures. I think its something to do with retrieving the metadata.

However you can work around it...

If you're running the eval version, then you can "upgrade" to the licensed version by just installing over the top. If the eval expires, best option is to uninstall before...

Take a look at the T-SQL BULK INSERT command.

This is just the sort of thing I was meaning in my post on your other thread

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=175907#bm176305

Programming something a certain way, because the other system has it that way...

Does you have to have a function that calls the procedure? Can you change your function to a stored procedure instead?

Yes you can do this. Check the topic called 'Reporting Services Programming' in the Reporting Services Books Online. It has all the information you need.

Best bet is to take the path of many before you and roll your own backup and maintenance routine.

Take a browse through the Script Library here and I'm sure you'll...

I recall seeing something about this in the MS KB. There was a hotfix or something for it.

1. You cannot retrieve the password from a DTS connection. This is by design as a security measure.

2. We use SQLH2 for this.

http://www.microsoft.com/downloads/details.aspx?FamilyID=eedd10d6-75f7-4763-86de-d2347b8b5f89&DisplayLang=en

You just have the name of the server by itself

eg: ServerName not \\ServerName\SQLH2PerfCollectorData$

The main reason I like xp_smtp_sendmail is the simplicity. No fiddling with profiles, no restarting SQL Services to reconnect to Exchange. No security holes from running Outlook on the server.

Just...

See my earlier post. You would have everything setup and running by now

The "Invalid class ..." error is covered in the doco as well. You need to install the WMI provider on the machine that you're gathering data from. In Windows Server...

What batch size are you using for the import? You could set it at say 1,000,000 rows and put the database in simple recovery mode. Then for each 1,000,000 rows that...

Rather weird convoluted way of running a package.

I believe that the antiquated way to use parameters in batch files is %1 not %1%