The reason I raise this is because I did some work for a client that had a DTS solution involving just Excel spreadsheets and no SQL server. MS told them...

Take a look at Microsofts SQL Health and History Tool.

http://www.microsoft.com/downloads/details.aspx?FamilyID=EEDD10D6-75F7-4763-86DE-D2347B8B5F89&displaylang=en

I think you'll run into licensing issues by distributing the necessary DTS runtime files with your MSDE install anyway.

As for the MSDE management GUI, there are quite a few out there....

What sort of WEB applications are we talking about here? ASP.NET, ASP, PHP, etc...

I'm not the most authoritive person to speak on encryption methods. I don't know about other languages, but...

Mark

I'm sure that everyone you talk to knows how "GREAT" your program is, but this doesn't mean that other products will work better in a given environment. In the posters...

For SQL 7 there is a little executable called scriptpkg that saves the packages to VB files. It's usually located in the DTS samples folder.

If you can find it,...

What about writing the T-SQL statement outside of DTS. Are the databases on the same server? If so, then why use DTS?

If not, then use DTS to pump the...

Using Lookups will switch the Datapump into row-by-row processing. This will significantly degrade the throughput of the datapump.

How much data are you loading? If it's not a lot then using...

Best method is to handle the encryption at the client end. That way you're not passing un-encrypted data which can be intercepted before it gets to the server.

If you...

How about an easy alternative that doesn't require calling a application external to SQL Server? Try xp_smtp_sendmail from http://www.sqldev.net

Take a look at Bill Wunder's series of articles for replacing...

"Set oDataPump = oPkg.Tasks("DTSStep_DTSDataPumpTask_1").CustomTask"

You'll want the task name here, not the step name. Check disconnected edit to get the right name.

"abort a script from within a script"

Is this to abort a T-SQL script or, the script that's calling OSQL? If you do a raiserror in the script that's executing...

Are you sure you're reading that right? Books Online says

Database size
1,048,516 TB3
Databases per instance of SQL Server
32,767
Filegroups per database
256
Files per database
32,767
File...

How about using OSQL to run the scripts?

Mike

I use a central error reporting package that is called via script in all of the On Error paths. There doesn't seem to be any performance issues and I have 8-10...