Nearly New Year = nearly new name? 🙂

namratha.vangara (12/23/2010)

---

Hi,

This is the information which we can get from the SQL Server Books Online.

Indicates whether the specified SQL statement to be run is a stored procedure. This property is...

That is much much better, but not quite complete

Now please provide the DDL for DHL_TEMP & a sample of what you would like to see in there, based on your...

Yes - possible in a data flow task without too much bother - but sounds like it would be relatively slow in terms of performance as it's doing row-by-row processing.

I'd...

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.