Firstly, I wish everyone were as explicative as you 🙂

I think the common view at this point is we've had enough of being chiselled by this vendor for consultancy on...

"Unfortunately the ORM will often construct a bloated sub-optimal SQL query - specially if just using the ORM default setttings."

This is what I suspect to be a contributing factor to...

• This reply was modified 3 years, 1 month ago by  JaybeeSQL.

The result is quite correct, cheers Phil !

Sum IIF....very nifty 🙂

No, he's importing package by package, as I myself had been shown.  I could show him the link you provided me but he'd have even less chance of understanding it...

• This reply was modified 5 years, 4 months ago by  JaybeeSQL.

Forget it people, I've got someone to do it manually.  No offence taken.

Any ideas people?

Probably better I fess up, I'm pretty new to SSDT I did't even know how to add packages to a project 😉

Ok I've clicked 'Add existing package', now window asks...

Thanks for your help, I had a quick read of the link, and unless my tired old eyes are deceiving me the method won't port parameters - and the packages...

Afraid I'm very new to Admin of SSIS, so not sure what's required to get them into project form.

I haven't seen the estate yet, presumably a mixture of in-place and new build.  Nothing older than 2K8.  Unlikely (but not impossible) they have partitioned tables.

• This reply was modified 5 years, 6 months ago by  JaybeeSQL.