Case x when 'y' then 'z' end

You need the 'then' and you need the 'end'.

Get the file name into a variable.

Use Token to break the file name into the components you need and assign these components to other variables.

Add an ExecuteSQL task to execute...

sej2008 (8/3/2015)

---

Hi everyone,

I am using ssis 2012 to import data from excel 2007 in to sql server using oledb destination and for transformation using Data conversion as some dates in...

I don't think that this is correct!

Tim Mitchell (8/2/2015)

---

Do you even need the table variable? Seems to me that you are creating the table variable strictly for the purpose of performing a relatively trivial update on...

If you read the original post, you'll see this:

...so the qualifier is there.

This is a...

sgmunson (7/31/2015)

---

Another alternative:

DECLARE @testing AS TABLE (

DepDate datetime,

val int

);

INSERT INTO @testing VALUES ('2014-01-10 00:00:00.000', 1);

INSERT INTO...

I'm not sure what could cause this. If it were me, I'd be thinking about doing a reinstall / repair.

Is this a new script task, or are you trying...

vipin_jha123 (7/30/2015)

---

Hi Becouse As I explained earlier I am having 2 source connection for US .

Out of 3 DFT 2 DFT have sourceA and Last DFT have difrent source.

For each...

Don't CTEs have to begin with the keyword 'WITH'?

Welsh Corgi (7/29/2015)

---

I have a situation where I have to Join a table that has Credit Score from a value of 0 to to a Lookup table that I...

vipin_jha123 (7/29/2015)

---

Ya that's correct for each loop wil work,

But my question is that within US zone I have 2 different source

out of 3 DFT 2 DFT have same source and...

A brief Google search will show you how to determine a package's version without opening it in anything more than a text editor.

The link between an environment and a project should be created only once. Why do...