bumpity bump.  bump.

Sorry I was unclear, I meant that was the interface I was using.  Yes, it is checked to run 32-bit Runtime.

The latter, right-clicking the package where it resides in the Integration Services Catalogs\SSISDB in Object Explorer.  The above screenshot is exactly what I'm using.  No point in setting up an...

Thank you Sue.  The Compatibility level for the SSISDB on the server running the package is 130.  Compatibility level of the destination database (on another server) is 100.  The latter...

I'm not sure what you mean by "Is your database not on the 2016 compatibility level?"  The database is SQL Server 2016, the package is built for TargetServerVersion SQL Server...

Lowell,

I've tried both option available to me, same result. No Bueno.

The implicit CAST was The Ugly. I changed my #temp structures to use VARCHAR() rather than NVARCHAR() and voila, things started moving along. While performance isn't down into...

If you're already bringing back 12 datasets, then this will add minimal overhead, even if you do it 12 times. With the exception of string manipulation, almost anything you...

Try using a SWITCH rather than an IIF. That will eliminate any simple divide/0 errors from the IIF behavior.

Actually, it looks like you've got no NULL handling in your...

gajayku (11/4/2014)

---

Hello

I have a stored procedure which generates data from some X table(this table is an input to the stored procedure at runtime) with some columns(this columns are decided at...

In your dataset, return a field that identifies the "DayGroup". Then group on that.

Here's the formula to use on the SQL side: round((MyDaysCountValue - 1)/5, 0) as [DayGroup]

You...

You CAN do it at the dataset level. What you need to do is identify the RANGE of values that your Top X (10 in this case) encompasses. ...

Mkrish (10/12/2014)

---

i have an ssrs report......where i have to calculate percentage

iam able to calculate percentage

but my problem iam getting infinity and #error values

i tried to eliminate 'infinity' i got success

but...

vecerda (10/16/2014)

---

Hello everybody,

I am trying to create a calendar style report will have 12 months (as columns) and store opening listing in rows. I have created a matrix, but the...

hoseam (10/17/2014)

---

Hi

Have this expression down here in one of my column;

But the problem with this is that All the "Y" are cut short, it is not the complete y (y...