Sure.

SELECT 'Nothing' FROM myTable;

Et voila, the row still has the value A.

Ah ok, so you want to update a value to a new value and then back to it's old value.

It seems rather pointless, are you sure that's what the interviewer...

UPDATE myTable

SET City = CASE WHEN City = A THEN B

...

There's no built-in task in SSIS that can do this for you, so you probably need to resort to .NET scripting.

You need to specify a new folder yourself.

You can log into the SSIS service and create it there.

The "/" is the root folder of the SSIS service.

Are you sure you have SSIS installed, and if yes, which version?

Configure Available Memory for Report Server Applications

Is this a homework question?

Also, please provide table DDLs and sample data please.

Very interesting question. Never used a CTE with a DELETE statement before.

Shaun2012 (9/24/2013)

---

Hi Andrew,

I'm using SQL 2008 r2, both in prod and dev.

I am using XML config file.

My project has 5 packages.

I updated all the passwords but when I reopen, I...

Maybe you should try an UPDATE statement instead?

Also make sure ColA is a varchar column, otherwise you won't be able to store the string values.

(and convert ColA to int before...

I believe it will still create it anyway.

If the empty file is such a problem, you can always delete it right after the data flow. Add a row count component...

AndrewSQLDBA (9/24/2013)

---

Sounds like you have some hard coded items in the package. Are you using an XML config file, or a SQL Table to store the config items that need...

Maybe the integrated logging and event handling was used?

Or the previous guy liked the graphical approach of SSIS?

Which version of SSIS?

There are a lot of different options on how to deploy packages.

These two articles give an overview:

SSIS Deployments[/url]

SSIS Deployments with SQL Server 2012[/url]

Which errors do you get?