Viewing 15 posts - 7,846 through 7,860 (of 9,715 total)
So many potential solutions. I like Steve's solution stuffed in a sub-query and broken out into separate columns. Then just do a count in the outer query and group by...
July 12, 2010 at 11:19 am
Alan G-436699 (7/12/2010)
As my loop is generic code, I really don't want to define a column list (I am copying 600 tables).
Column List in the SELECT part of the...
July 12, 2010 at 11:09 am
Do a search on phrase "Dynamic Pivot". See if that helps you out. Then post back on this thread with further questions about it.
July 12, 2010 at 11:05 am
Glad I could help. Let me know if you have any more questions regarding this issue.
July 12, 2010 at 5:47 am
Well that depends on where the .exe file is located. If it's on a UNC or Share drive, you just need to add the proxy account to that path's Security...
July 12, 2010 at 5:43 am
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...
July 9, 2010 at 10:53 am
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...
July 9, 2010 at 9:14 am
will s (7/8/2010)
The "new alert" wizard doesn't have a "when this job fails" option, which is what I really want.
Maybe I'm misunderstanding, but failed jobs can send out Notifications which...
July 9, 2010 at 8:43 am
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....
July 9, 2010 at 4:00 am
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...
July 8, 2010 at 11:09 am
What's the package protection level set at? Does the Developer have permissions in the SQL Server that he's running the package against?
July 8, 2010 at 9:17 am
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...
July 8, 2010 at 9:15 am
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,...
July 8, 2010 at 9:11 am
What kind of login / permissions are your connection managers using?
July 8, 2010 at 9:09 am
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...
July 8, 2010 at 9:08 am
Viewing 15 posts - 7,846 through 7,860 (of 9,715 total)