tooba111 (1/19/2011)

---

I am sorry john to confuse to, that was typo mistake, In last post i asked i only need those fields who don't have null value if there is...

OK, maybe that was a bit harsh on an SSIS newbie.

After looking at this, I must admit that I found myself thinking that it would be easier to get the...

Karan_W (1/19/2011)

---

I want to create a SSIS package which will call the stored procedure and dump the output of the procedure into table.

This stored procedure accept an input parameter e.g....

It looks like you've got the same issue as this guy.

Based on the fact that it does not look like it will be very easy to solve with this approach,...

I bet you've guessed my next question already: please post what the parameters screen contains - perhaps even a screen shot if it's not confidential.

Excuse my speaking plainly, but that is a daft requirement.

What happens if the four source fields all contain different data - you have only one target, so you are going...

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.