You could try something similar to the following:

create function [dbo].[Split_Values]

(

@String varchar(4000)

,@Delimiter varchar(1)

)

returns @Split_Values table(String_Value varchar(200))

as

begin

insert into @Split_Values

(

String_Value

)

(

selectsubstring

(

@Delimiter + @String + @Delimiter

,N + 1

,charindex(@Delimiter,@Delimiter + @String...

Without more information about the package I am purely guessing here...but I suspect you are not setting the username and/or password for this connection properly.

Are you using a config file...

Martin Schoombee (11/16/2011)

---

Just one more thing as I'm reviewing your initial posts again.

Have you tried to create a data-driven subscription? That will allow you to specify a query to...

Just one more thing as I'm reviewing your initial posts again.

Have you tried to create a data-driven subscription? That will allow you to specify a query to return the...

No. Create a new...

SQL_Nw (11/16/2011)

---

Thanks for your reply.

I added defaults for @report_start and @report_end as for yesterday 24 hours 00:00 to 23:59, but even If i schedule it every 8 hours, the...

This is probably happening because the values for those parameters are expected in the report.

My suggestion would be to create defaults for the parameters in the report with the necessary...

Have a look at the following: http://sqlblog.com/blogs/kevin_kline/archive/2008/10/09/ssis-packages-need-love-too-er-memory-too.aspx

I think the resources listed there will provide the necessary information.

jean.gelinas (11/8/2011)

---

Using the following in a text box on a local report included in a VS 2010 c# project:

= Switch(

Fields!BeneficiaryType="PERSON","Name:",

Fields!BeneficiaryType = "TRUST","Trust Name:",

Fields!BeneficiaryType = "Charity","Charity/Organization:",

Fields!BeneficiaryType = "ESTATE","Estate Name:")

Getting the following...

Definitely not a SQL Agent issue.

One or two things are coming to mind that may cause this...the first is drivers (32/64 bit). BIDS is a 32-bit environment, and will...

I guess the only possible con is that...

raotor (11/3/2011)

---

OK, Here's the query:

SELECTCOUNT(Price)

FROMTempSales

GROUP BY Price

ORDER BY Price;

I'm afraid as I'm so green with this forum you'll have to tell me the best way to attach the execution plans...

I also think that SSIS is a great tool, if you use it appropriately.

The ease of use is sometimes the product's biggest downfall. I see too many people who...

onlo (11/2/2011)

---

Currently, to create a Analysis Server database role, the only way I know is : create a rolw within the Visual Studio of the Analysis Services Project.

However, I am...

Yes, you do need a "FROM"-clause. The CTE's can be used as tables in your final query.