What are you doing with the records after the UNION?

Sounds to me like a self-nomination for a mini research...

Thanks for posting back - I'd never heard of that.

I am afraid that there is no way of doing this other than manually recreating the packages in 2005.

qur7 (1/11/2011)

---

--

I ran the same script in a package home on sql server 2008 .. works like a charm. when i came to work and did that in ssis 05...

Disappointing! I was waiting for something like this 😛

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