How about:

WITH cteUsersAndSoftware(UserName, Software)

AS

(

SELECT DISTINCT s.User_Domain0 + '\' + s.User_Name0 AS 'UserName',

(CASE

WHEN p.DisplayName0 LIKE 'Microsoft Visual Studio% %Ultimate% %2013%' OR ... THEN 'Microsoft Visual Studio Ultimate 2013'

WHEN p.DisplayName0 LIKE 'Microsoft...

Check out Jamie Thomson's blog post:

jameslauf (2/11/2014)

---

I have two different packages I am trying to run. One imports from an excel file the other a .csv file. The files are downloaded every 2 weeks and...

I think that the variables cannot contain nulls.

You could replace your configurations with some value that you aren't going to use (-1, -100000, or some such).

Are the default values that the configuration gives you ones that you could ever picture using? Would you ever use 0, or the date in 1899? If not,...

What does the command line look like in the SQL Server Agent task? Specifically, what is the syntax for the Set values part for the variable?

You are going to need to use a script task, if only to get the date last modified.

There was one key phrase in the request for the change that I would like to focus on: "small change." There are rarely any small changes. To...

I am going to assume that all "M"s from the Excel source needs to be changed to "F" in the target and all "F"s need to be changed to "M."

My...

Do you want to remove the comma when moving the data from Oracle to SQL Server or in SQL Server?

Can you list some of the blogs you have found for a start?

See if this helps: http://www.mssqltips.com/tip.asp?tip=1417

I'm not sure that you are going to get much help here. This sounds like an Ubantu OS issue not a Reporting Services issue.

In order to pass in variables to the Execute Package as arguments for the bcp command, you are going to have an expression in which you build the entire command...

Did you try:

declare @action varchar(10);

set @action = ?

if @action = 'INSERT'