+1

I've found the wrox press books to be good in the past, they offer beginner, professional and 'recipe' variations

I agree about the quality of the book, but it certainly isn't free when...

Hi,

If you change + to & this should work. & is used in ssrs expressions for combining strings

Because, presumably the data entering the SSIS pipeline from the oledb source is non-unicode.

Excel requires the data be unicode prior to loading to the worksheet, hence the need for a...

Hi,

You're joining on ColA rather than N (the rownr).

Try;

;WITH T1 AS

(SELECT Row_Number() OVER(ORDER BY colA) N,

colA from dird)

SELECT a.colA, a.N, a.colA-b.colA FROM T1 a

left JOIN T1 AS b

ON a.N-1...

The other time consuming build activity in SSIS is when you're building a deployment utility on every build. Depending on how many packages in your solution this could potentially...

Hi,

Try the switching the order of substring/cast i.e.

SELECT CAST(SUBSTRING(ID,3,LEN(ID)) AS bigint) AS ID FROM table

Hi,

How about;

Hi,

How about something like the following as the format expression;

=iif(Fields!YourField.Value=0,"N2,"N6")

Hi,

You could do this by having a textbox on the report containing your validation message, and toggling the visibility of the main report components (e.g. table, matrix etc) and the...

Hi,

This can be done by using an expression on the format property for each of the 3 fields required.

The expression for the format property would be something like;

=iif(Fields!State_Province.Value="Arizona","N1","N0")

This would fix...

Hi,

If you're currently using =join(Parameter,",") to split the parameter into the horizontal list, you could try changing this to =join(Parameter,vbcrlf) to specify the multivalue parameter list should be delimited by...

Hi,

Try changing your clause for the inner join to

ON loc.Parent_Location = loh.LocationID