Does the proxy account have permissions on MSDB to execute the dbmail procs? Does it have write permissions on the share where the log file is kept? Does it have...

Nevermind. We have a clustered server and the users in question keep getting shunted to the node that isn't quite working right. When we have them use the literal address...

Maybe I'm misunderstanding, but failed jobs can send out Notifications which...

That's your problem right there. You cannot save the password for that login when using "DontSaveSensitive". The point of that protection level is that the package does not save passwords....

TravisDBA (7/8/2010)

---

So I spend the first week reading up on the database, then find myself receiving troubleshooting emails. So I ask my co-worker (the only other DBA team on the...

What's the package protection level set at? Does the Developer have permissions in the SQL Server that he's running the package against?

You should be able to use an Execute SQL Task to check the fragmentation amounts and then have a conditional precedent to lead up to the reorganization task. But I...

You have to use a data conversion task to change the data from WSTR to STR or vice versa. It's like the difference between unicode and non-unicode characters. In fact,...

What kind of login / permissions are your connection managers using?

What you need to do is define a variable with a Global scope (or within the scope of the container that both tasks are in). Then in the Execute SQL...

PeterG-377490 (7/8/2010)

---

Trying to be proactive.

Sales transaction database. 100's millions of rows. I built an access front end for users to view reporting.

Sounds like if i let the sales columns...

Ah, my probationary period for one job started right in the middle of a major project. There'd been over a hundred scope changes the the project was due the end...

What do you mean summary? And why would someone need to send you their resume?

Good point about the TRUNCATEONLY issue being only data files. Maybe that's what I was working on, I don't remember.

Alen, are you getting a specific error message when you try...

PeterG-377490 (7/7/2010)

---

While i have your attention Brandie - I mentioned the typical query. That query will also return the sales information. Should i use those columns as an included column...