Hi, Steve:

Thanks for your response! I tried something like this:

Public Sub Main()

Dts.Variables("fileName").Value = "\\ServerName\FolderName\" + System.IO.Path.GetFileName(Dts.Variables("fileName").Value.ToString())

...

Thanks for your suggestion, Ed! I actually happened upon a solution that seems to work for me, but I had never heard of the impersonation thing, so I'll definitely look...

I know this is months late, but I just wanted to say how incredibly helpful this was to me. It's really hard to find actual step-by-step instructions for this sort...

Thanks so much! That will be perfect! 😀

Hello:

As an update, I found out that Server1 (the one where the linked server won't work) has Windows Server 2008 installed, while the other two have Windows Server 2003. Has...

I suspected as much. 🙂 Thanks so much for your help!

Thanks to you both for responding! Vishal, that worked perfectly--thanks a million! 😀

Just one more formatting question: I have a number of row groups and only one column group. The...

Holy mother, I think I might have gotten it. I changed David Wiseman's proper case function to this:

CREATE FUNCTION [dbo].[fMisspelling](@Value varchar(255), @Exceptions

varchar(255))

returns varchar(5000)

as

begin

declare @sep char(1)

declare @i int

declare...

Hi, Lowell:

Thank you--this will save me a lot of typing! I also enjoyed your use of the word "doink" in your comments. 😛 This is very much appreciated!

Just a last desperate attempt to get some feedback on this issue before I start slogging through all the possible spacing scenarios... :crying:

Thanks to you both! Just what I needed--I was close, but I was doing CASE WHERE instead of CASE WHEN. D'oh!

Thanks again!:-D

Hi, bc:

Thanks for the reply! I was considering that as a last-ditch effort, but here's the problem. We send these addresses out to the post office periodically to be formatted...

Just in case anyone cares, I ended up finding a T-SQL function to proper case

my fields before they're rendered in my report. I used the function created by

David Wiseman at...

Thanks to both of you for your replies! This database is actually stored in some weird proprietary platform and the data is imported into SQL Server every week through an...

Okay, so after wasting an inordinate amount of time on this issue, I finally figured it out:

=Format(CountDistinct(Fields!CardSwipeID.Value)/CountDistinct(Fields!StudentID.Value, "StudentVisits"), "#.###")

...where "StudentVisits" is the name of my dataset. Just in case anyone...