I added in package guid and version guide, no dice there.

DTSRun: Loading...

Error: -2147217900 (80040E14); Provider Error: 14262 (37B6)

Error string: The specified DTS Package...

Steve Jones - Editor (10/30/2008)

---

Is the file fragmented now on disk? If so, this might help clean some of that up.

you can shrink to some xx level, you'd have to...

I did some searching on sqlservercentral.com and came across various links that point to MS KBs as well as forum messages saying just change it to sa account. Sure...

While dreaming this past weekend, I thought about looking at profiler. Sure enough, I can see that SSIS step being run as the user that connects to the user...

I need to run it in a SSIS package, but to prove that it is...

Yes dbmail is enabled. I can run a sp_send_dbmail in a regular SQL Agent job step, but when it runs inside a SSIS, that's when it gets the permission...

Also on SQL Agent properties

Connection option: alias is empty

SQL Server Connection: Windows Auth selected.

I have a dev system that the sp send db mail works ok with. ...

I have a user "servername\SQLServer2005SQLAgentUser$servername$MSSQLSERVER"

It is mapped to sysadmin role by default. Both boxes are like this.

On properties

Connection option: alias is empty

SQL Server Connection: Windows Auth selected.

I...

yep, will do a dts to an archive db which go onto a dvd, then truncate away!

search Luke search yielded http://www.sqlservercentral.com/Forums/Topic416687-5-2.aspx

🙂

Very good question, here's how I did it on WAS 6.0.

Login to admin console

Click on Resources

Click on JDBC Providers

Step 1: select user defined

step 2 and 3 should all...

How timely, 10 worst jobs:

http://valleywag.com/390182/

hhhmmm, I don't see anything under Mgmt -> Legacy -> DTS. I tried again and double checked that I saved it to right server. I also checked another...

I have only one end user database on that system now.

The shrink script seems to work pretty good. Thanks!