Interesting I didn't know this, but now I think about it makes sense I suppose...

Learn something new every day! 😉

Very difficult to say without much more information, however it sounds like you have multiple steps in your job and the step that calls your package is not set to...

Your Welcome 🙂

Do the ID columns all have the same name or are they different?

If so this would work I think

CREATE TABLE #temp (TableName VARCHAR(200),TableCount BIGINT)

INSERT #temp

EXEC sp_MSForEachtable 'select ''?'',Max(ID) from ?'

...

Hi

Difficult to say without seeing much more info like DLL's and Data.

However taking a shot in the dark would the undocumented procedure msforeachtable be of use to you

Your welcome - Glad to be of help 🙂

Its because the query is doing exactly what you are telling it to do and only returning records WHERE IsNull(App_FK_EventID, 1382) = 1382

This should work for you

I haven't tested this...

Welsh Corgi (2/23/2012)

---

You could also disable and then enable the FK's but if you get a record(s) that violates the FK constraint exception that violates the FK Constraint then you...

Or you could just drop all of the Keys as part of your load and then re-build them once the tables have loaded - this way you can load the...

Your User field I'm making the assumption that its a string data type and is a name that you need to order A - Z (or Z - A) and...

Hi

Have you tried putting an ORDER BY in the query?

Andy

thanks for posting your solution 🙂

No Worrirs Peter glad to have been of help 🙂

Hi Peter

Does this help?

=IIF((Fields!IsSales.Value) = 1 OR (Fields!NEWBOSS.Value)= 0,True,False)

Although your logic will show as visible if either Sales = 1 OR NEWBOSS = 0, not necessarily both

Andy

Hi

Right click on the column that you want to hide Column Visibility>Show or Hide based on an expression the expression you want is:

=IIF(Fields!IsSales.Value = "1",TRUE,FALSE)

If you want to do this...