Because you can specify permissions at the database level on things which are outside of role based permissions

Say I have a role and assign it the ability to execute 99...

If an account has SysAdmin fixed server role, they are God and can do what ever they want to do, where ever they want to do it and you cant...

Absolutly yes. One of the last options is to save the package to the MSDB database or the File system.

Appreciate that IIF is new in 2012, just with it being in a 2008 forum, I automatically assumed IIF = SSRS IIF not a SQL IIF.

Hence why it is always...

The stairways section, goes from basic up to detailed information on SSIS http://www.sqlservercentral.com/stairway/72494/

What you want seems pretty basic.

You need 2 connection managers, 1 Excel which points to the xls file,...

CASE Rank WHEN 1 THEN 'Gold' WHEN 2 THEN 'Silver' ELSE 'Bronze' END AS RankColour

So your after something like the above?

IIF wont work in SQL as its not a SQL...

Then I would ask that you post the table definition, some sample data and what the expected outcome should look like on the report.

The same way you would run it via SSMS

SQLCMD -S server -E "EXEC dbo.CreateDatabase @DBName = 'DatabaseName', @DataPath = 'C:\data\Databasename.mdf', @LogPath = 'C:\log\Databasename.ldf'"

Lokesh Vij (1/29/2013)

---

As rightly pointed about Anthony, this is bit tricky as there is no identifier on the rows. Here is another way of deleting duplicate records using CTE:

WITH DelDup

...

In an expression you need to refer to the column as a Field using Fields! then you give it the field name so Fields!Rank then you get the property, in...

Look at cast or convert using a date style http://msdn.microsoft.com/en-us/library/ms187928.aspx, style 100 or 109 may be the ones to go for.

no longer applicable

Expected behaviour of SQL

Read the following article http://msdn.microsoft.com/en-us/library/ms187928.aspx, especially the Truncating and Rounding Results section

Inserting a 4 digit INT into a 3 character length string, returns * detailing result length...

You need to qualify what Rank is, if its a field in a Data Set then you need to do something like the below.

=IIF(Fields!Rank.Value =1,'Gold', IIF(Fields!Rank.Value =2, 'Silver', 'Bronze'))

You may want to look at alternatives like a SMARTboard, or a AcitvBoard by Promethean (disclosure, I work for them) which you can just hook a PC into.