What is the ResultSet property for the task set to?

Perhaps you could post your SQL.

If there were no errors, the chances are that the data was not even hitting the database - so perhaps you have WHERE conditions which...

You say it 'fails' - so I am guessing that you get an error of some sort. Please post the text of this error message.

An alternative is to create a mapping table in SQL Server and use a LOOKUP to get the result you need. Much easier to maintain and handles easily the addition...

Are you issuing a command or asking a question?

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