flat2f2 (12/22/2010)

---

Hi

I am a newbie and this is my first package and would like to know

whether my project could be feasible in SQL 2005.

I would like to use an excel...

An ExecuteSQL task should be used to assign the table rows to an SSIS package-level variable of type object and a FEL should be used to shred the variable, processing...

Please study this [/url]link. It should help you understand why we cannot understand what you want and how to rectify that.

pwalter83 (12/21/2010)

---

Hi,

If its possible, could you please tell me whether it is possible to use '%' as wild character with the CASE statement as in the code I have mentioned...

Yep, I've read through a few times and I'm baffled by this one ...

As well as providing sample input data, can you provide your desired output please? No need...

But I don't understand why you are even referring to country if you are not filtering on it?

select * from country where trade = 'euro med' and country = [anything]

is...

Saying that something "doesn't work" is not very helpful. What pattern are you trying to match?

I'm afraid that such functionality is not available in this forum.

Some background information would help: why are you doing this? Please give an example of the layout you want to create. What are the inputs/variables?

da-zero (12/16/2010)

---

Oh allright, it is for an interview. Why didn't you mention this in the beginning?

Your answer should definately be:

first yellow boxes. If you're lucky, green boxes. If not, red...

Please be more specific. At the moment, my answer would be

1) Job starts

2) Job executes

3) Job completes

which I doubt is the answer you require.

This might help you.

Your description is a little terse, but I get the gist. No matter how many times you have to map the columns of the table you are...

Dan Guzman - Not the MVP (12/10/2010)

---

Phil Parkin (12/10/2010)

---

Is there any reason why you cannot engineer the entire process, from picking up a row of data from your source, to...

I agree with Craig: that post was much clearer.

I think perhaps you are thinking of SSIS in the wrong terms: SSIS gives you access to pipelines of data, rather than...

I've read through this thread three or four times and I still do not understand what you are trying to do.

A data flow takes data from one place, processes it...