A brief Google search turned this up.

Maybe the instance is not running in 'mixed' authentication mode?

The best way to do this, IMO, is to move processed files/folders to an Archive folder somewhere.

Then your FEL can remain as it is, picking up everything when it runs...

If something is non-deterministic, then it's very possible for the re-evaluations of the object test to miss all of the WHEN's and produce a NULL if there is no...

Thanks for posting back and I'm glad it worked out.

Sounds like the dev might have hard-coded something into the package which is not being overridden by the config.

I'd spend a few minutes editing the package to see whether you...

Imagine if the table were normalised. Something like this:

(Id, Mode, StartDate, EndDate)

I think you'd need a query like:

select id

from table

where Mode = 1

except

select id

from table

where

(Mode = 2 and Enddate...

Nice one Jeff 😎

Have you considered setting the columns to NOT NULL?

(After fixing existing NULLs, of course)

Just played around with this a bit and it seems that the CHOOSE function does not deal well using functions directly in the 'index' argument.

This is not just a consequence...

batgirl (1/5/2015)

---

I have a grand plan for 2015!

1. Downgrading my "job" - this is my last week of a full time high pressure job (on call 24 x 7) and...

Ah, now I understand.

Go to Tools/Options in SSMS. Select SQL Server Object Explorer / Scripting.

Set 'Check for object existence' to False.

'Scripting' is how stored procedures are modified – it is the only way.

m_swetz (1/4/2015)

---

We have recently started using SQL Server 2012. Given that we have multiple servers running 2008, we continued using our custom SSIS logging reporting process to monitor the...

You cannot configure the connection directly like that.

Please read through this [/url]article and see whether it helps you.