Hi Mike, yes I can load to a pre staging table with these constraints already in place then output the errors to a file. I was wondering if there was...

I haven’t ever published packages to 2008 in this way. I deploy them with the manifest file and then set them up as an agent job in SSMS (database engine).

When...

Hello,
After a load of googling, I have found the cause and the solution.

Cause:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e3d1f733-ed60-41ec-87f3-cbbafb7d1656/ssis2012-runid-variable-quotfailed-to-lockquot-at-runtime-bombs-0xc0010001?forum=sqlintegrationservices

Solution that worked for me was to open all packages that...

Hi Phil, thanks for the reply.
It turns out our DBA is less used to using SSIS than I thought.
He was attempting to deploy the solution through VS....

I agree with Phil, not pretty and slow.
Another not pretty and slow idea you might try is to use a for each loop to import the files into...

Perfect - thanks for clarifying.

Dave

Hi Thom,
Thanks for the reply.
Max(booking_new) is  the row number calculated for previously entered records in the same trip/company.
I am not sure what you mean by DDL and...

ignore me - I forgot it always fails the syntax checker in 2008 r2 - only been using xml.nodes for about 5 years so still a beginner really!!

Dave

UPDATE:-
I was running the function in a view.
I forgot to repoint my SSIS OLEDB source from the underlying table to the view.....rookie mistake towards the end of...

Hi Phil, worked great thanks. Only issue now is that the select * for each table will return a variable number of columns. I know from past experience that SSIS...

All valid points for consideration however in this instance, the LOBS calculates the duration prior to the extract so I am absolved of responsibility for how it is calculated.

Cheers

Dave

Hi, thanks for the reply, I have them in both formats, decimal and time. I am trying to cater for end users who aren’t really sure what they want.

Kind Regards...