JustMarie (1/3/2011)

---

I'm looking to do something similar without using a third party solution.

We've got files coming in that are all in different formats but need to go to the same...

I think you may be over complicating this a little.

When the SSIS package runs, it will need to access the CSV files to bring in the data. This access can...

hxkresl (1/2/2011)

---

SSIS 2008 is assigning a "date" data type for several columns in the source excel file and mapping it to "date time stamp" data type in the destination SQL...

Koen (da-zero) (12/29/2010)

---

Always the same with those British people 😉

On-topic: such a check normally requires regular expressions, unless your checking for example...

JustMarie (12/29/2010)

---

OK - I'm going to put my (extremely simple) suggestion here. Obviously it's looking for the basics of an email address - @ and .XXX. Yes, addresses...

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...