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%

Or you could forget the hassle of setting up the profiles and use xp_smtp_sendmail from http://www.sqldev.net

DTS = Data Transformation Services. Basically given an known datasource, DTS can extract and transform data very easily.

There are different methods of calling BCP, xp_cmdshell is one of them,...