There are 187 columns in the Excel file I'm trying to import. Am I going to have to do a derived column for every single one of them? They're all...

Todd--I'm trying to use the Derived Column transform with the replacement syntax you mentioned, but it's still failing for non-unicode versus unicode once I try to get it into my...

Yes, that worked brilliantly! Thank you so much! 😀

That worked perfectly. Thank you so much!

I got it! The problem was that I was modifying an existing package in order to use the subfolder name. Originally, I needed only the filename & extension. When I...

I'm not getting the full UNC path. I'm just getting the name & extension. I've got the radio button checked that says "Fully qualified" but it's not bringing it back....

I hesitate to ask yet another question, but now I'm able to actually see the Report Manager home page without any errors. However, when I publish things, I cannot see...

Ok, I'm an idiot. I've just been looking at it so hard that I didn't read this article carefully enough. This fixed my problem:

http://support.microsoft.com/kb/922656

I had to change the...

Hi gift,

I followed the instructions in the Microsoft article for putting the fully-qualified name in the config file. It did not change anything. The site has been added to my...

Ok, so I completely un-installed Reporting Services and started from scratch. This time I installed it as a default instance. However, since SQL Server & SSIS already existed under default,...

I installed it as a named instance because that is what the so-called Microsoft instructor told us to do. It became apparent as the course progressed that he hadn't used...

I got it to work! Thank you so much!

I didn't read your post closely enough. I was trying to set an output variable rather than using the "Results Set" area....

J.D.--Thank you so much. I'm so close now!!! Ok, I understand how to do the precedent constraint, but it doesn't like the way I'm trying to set the @IsTrue from...

Yes, that is exactly what I want to do. I think I'm close, but not totally sure how to proceed. I have it set up to read the file name...

Thank you both so much!