Can anyone else explain how I can achieve this within SSIS? (other than Dan Humphries)

Unfortunately, I can't find anything on the net to help.

Hi,

I managed to find a fix on the web. Basically, I changed the connection manager type to ADO.Net and it worked.

See link:

http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-ssis/1954/SSIS-Any-Experience-With-SQL-Task-Returning-XML

Hi,

Firstly, thanks for your time and effort.

The problem still seems to be in the Execute SQL Task. I again tested at breakpoint at OnPostExecute and found that..

If I include the...

I'm not entirely sure I understand the requirement, but here goes..

You are using student_no is your 'pointer' and you wish to output values greater than the value specified.

You could use...

Thanks,

I tried adding ‘SET NOCOUNT ON;’ to the Execute SQL Task 'Direct Input' but I’m still getting the same error. I have added some code, as you requested:

Mileage table

--DDL...

Mark, many thanks. I appreciate your efforts.

I did try changing the '@Mileage to dbo.Mileage before my last post. The only fields that reside in the Mielage table are the ZIPCODEFROM and ZIPCODETO columns. The others (i.e....

Hi Mark,

Thanks - Firstly, the structure is perfect.

However, the 'Postcode' values aren't being pulled from the Mileage table though. The output contains the values that I gave in my...

Hi Leo,

Thanks for your help. I realise that my original posting may have been mis-leading as to the xml requirement.

I need a process to transform the 'NEW' record into an...

Hi Tyson,

Thanks for the tip. The INSERT table/method is VERY useful - but wouldn't I still require a TRIGGER to run it though?

Using this method I would still need to...

Many thanks Ken

Brilliant!! I'll try this out.

Thanks a million

Thanks for the help. It is used within a SProc btw.

I eventually used the following which seemed to work..

...

Thanks guys.

I tried all variations and ended up using andrew's 3rd option with cte.

Much appreciated.

Thanks guys.

I appreciate your efforts and responses