I've just played around with this and there does not appear to be a way to do it without writing a bit of code, as you've already anticipated.

I think I'd...

After reading this, I am...

Did you install Native Client 10 before running that?

touchmeknot (1/4/2011)

---

Hello everyone,

I agree with Craig and disagree with Phil.

I succeeded in loading the file. Yes, it seems impossible but I succeeded in loading the file dynamically without using any...

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