This may point you in the right direction:

First the stored procedure I created for testing this which accepts @MyParameter as nvarchar(max) type.

IF OBJECT_ID('MH_TEST') IS NOT NULL

...

Could you not run this as a job and in the job steps advanced tab select "Output File" and specify that way?

Also the Begin is missing after AS at the start 🙂

and this

http://www.slideshare.net/idigdata/excel-sql-server-data-mining-overview

What have you tried so far? What version of SQL Server are you using?

A quick google search threw up this

http://www.microsoft.com/en-us/sqlserver/solutions-technologies/business-intelligence/predictive-analytics.aspx

Would something like the below do the trick

UPDATE dbo.Table2

SET found = 'OK'

FROM dbo.Table2 t2

INNER...

See attached image for how we do it (1):

Script task to create the actual commands we want to run. (2)

Output the content of variable to a text file (3)

Run your...

Probably not the most elegant of solutions however when we used BCP to export data with leading and trailing zeros we converted depending on which way we were going.

DECLARE @something...

Can you not re-create the folder and then re-deploy the relevant reports?

Failing that, whilst I have never tried this I did come across this from Google

http://stackoverflow.com/questions/914370/where-does-a-published-rdl-file-sit

It may be...

[schema_name] is too small to handle what you are trying to put into it. I increased to size to 128 and it worked.

http://technet.microsoft.com/en-us/library/ms191240(v=sql.105).aspx

(Sysname datatype)

This is by far not the best bit of coding as I broke to problem down into stages to build the final result. I did have to change your...

Cheers Sean. Will have a look 🙂

You could also create a function to do it:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE FUNCTION [dbo].[fnSplitList]

(

@sInputList VARCHAR(8000),

...

could really do with some sample data to fully understand how it comes through

What does your data look like coming into the report as this will depend on how it can be done