A SQL re-start is probably the cleanest way to do this but if this isn't possible then shrinking is your next option. I can't think of how else you would...

Sorted... nothing wrong with SSIS, was just me being stupid! 😛

Look up precedence constraints and expressions.

Thanks Michael, I will try your suggestion and let you know.

First day back at work after a two weeks break... :w00t:

Happy new year all!

Happy new year! 😀

So one contract can have multiple aged balances?

How about the below:

Select b.dbPatID, a.dbPatFirstName, a.dbPatLastName, b.dbStaffLastName, SUM(a.TotTot) AS TotTot

from EPSAgedBalances AS a

inner join EPSAllContracts AS b

on b.dbPatID =...

You sure the database is not being backed up?! Normally it shows as None in the Last Database Backup field if the database has never been backed up!

Are there...

Not sure if I'm over-simplifying your problem but how about the below?!

INSERT INTO #TempTable (GroupName, NumberOfCases)

SELECT 'Total', SUM(NumberOfCases)

FROM #TempTable

LOL... you think that was quick? You should see me chatting up the ladies 😀

kapil_kk (12/18/2013)

---

Abu Dina (12/18/2013)

---

+1 to Koens's suggestion.

I like to keep things simple so I would link the Data Flow Task to an Execute SQL Task (with On Success precedence constraint)...

You don't really have to transfer the IDs into a staging table if you don't want. As I said above, you can have an On Success precence constraint from your...

+1 to Koens's suggestion.

I like to keep things simple so I would link the Data Flow Task to an Execute SQL Task (with On Success precedence constraint) that contains your...

If your source data comes from a SQL Server table then why not use SQL command as your Data Access mode (in the OLEDB Data Source component) and have a...

iSqlWebprog - Sql Server Client

Ooohh, Splashtop on an iphone?! Don't know but I got pretty fat fingers... I'd end up shutting down the server instead of logging off! 😀