This is not a version issue. This relates to the fact that you saved the package with encrypt sensitive with user key turned on. if you save the package as...

sreenubabu.s (5/12/2015)

---

We have installed recently SSRS 2014 (SQL 2014 RTM) and deployed the reports into the server and all users being accessed. We have done memory configuration in config file...

Something like this?

if object_id('tempdb..#date', 'U') is not null

drop table #date;

create table #date (a int, b int, dte date);

insert #date

(a

...

No ORDER BY clause, I think you may have meant.

RTaylor2208 (5/12/2015)

---

--

The only exception is that when launching the application providing its on a windows machine you use the method of right clicking on the application and selecting "Run As"...

I'm amazed you worked that out, based on the error...

Can you confirm that you have resultset set to none and include a screen shot of your parameter mapping screen?

Are you using the Copy Database wizard?

Why not use backup/restore instead?

Try looking for that text in all objects in the database using SQL Search[/url]

Is there anything special about

dbo.MostOrderedGenerics

?

No problem. Thanks for posting back.

Eric M Russell (5/8/2015)

---

Bradley Deem (5/7/2015)

---

Sorry, Oracle terminology. In SQL Server this would be Snapshot. Regardless, use technology to allow you to rollback to the...

am_mal80 (5/8/2015)

---

Hi Guys,

I need your help how to solve the below error.

Warning: 0x802092A8 at Data Flow Task, OLE DB Source [1]: Truncation may occur due to retrieving data from database...

It was also the first question in the first response!

IIF() is from 2012 only...

Here's a code snippet proving that the iif() method should be fine.

declare @Ordinal int = 0;

declare @First varchar(30) = 'Jimbo';

select CO_OWNER = iif(@Ordinal = 0, null, @First);

set @Ordinal =...