Hi there. We experienced a very similar problem you did. Our primary SQL server was a physcial box using multiple LUNs for the database storage (1 LUN for...

You might want to check to see if the .net reportviewer control is installed on the machine you are try to launch the report from the Virtual directory.

Yeah i have run into a similar problem. It does a decent job auto scaling columns down from 50 but it seems to be the normal default. when...

Hey there, i ran across a similar issue. deleting data from excel is real pain, even when you delete it tends to remember where the last row of data...

It is possible to do what you are describing. We use NetApp for our SANS. With SnapManager handling the snapshots. Initially the first snapshot is essentially a...

Hey there!

Several ways to accomplish this. Really just depends how much T-SQL you want to do or if you prefer to work in SSIS.

You could do this all via...

Was actually reading about scenario like this from MS the other day.

First, can you perfom simple select like SELECT * FROM dbo.SomeTable?

What is the security role of the...

One important consideration is uptime and fail over to your old system in case issues pop-up. MS highly recommends using the Database transfer wizard to move db's from 7/2000...

That's quite a SPROC. Have you executed the SPROC thru Mgmt Studio using the same paramaters you are passing from RSS and gotten data back?

One thing to keep in mind with with VB to add a "\" to a string value you actually need to do "\\"

We are using Windows/AD authentication via sharepoint, however we have sharepoint authenticating with the report server using the sharepoint service account. That allows us to maintain the security for...

I would step thru the script in VS and see if it is actually working correctly...although it does look good. Check to see what return value it's giving...

Could you show the SPROC? Is the IDE showing any errors when you execute the procedure?

Also

In the Windows where you put the SPROC Name did you include the schema...

under expression for the Destination Property to...

[User::DestinationPath] & "FileName " & (DT_STR,50,1252) GetDate() & ".txt"

This would create something similary

[User::DestinationPath] = "C:\MyFolder\"

Resulting String would be this...

"C:\MyFolder\FileName 2/29/08 15:00pm.txt

You would probably be better off outputting the file using reporting services. Would make the whole process much simpler. You could script out any custom actions that need...