Not the Base Table, the Child Table needs an index on the columnthat...

Nice work. Happy you found a way forward. Thanks for posting back.

SQL Server actually will not use the page file unless the server is under duress. Page file access is very slow compared to RAM access, so SQL Server aims to...

What has happened to the venerable CASE expression? I am surprised no one has mentioned it thus far but there is no such thing as a CASE statement in SQL...

The one I attached to this thread does not write anything, it just selects and then pops a message box. I looked at the one you attached and the Execute...

The service account should not need to be a local admin, and I agree with you, I think it's a bad idea.

Here is the description of the SQLServerSQLAgentUser$MYCOMPUTERNAME$MSSQLSERVER group...

When you changed the service account for the service did you use the Services MMC (e.g. from Control Panel>Administrative Tools) or did you use the SQL Server Configuration Manager?

Just confirming,...

Frank Cazabon (2/19/2013)

---

opc.three (2/19/2013)

---

I do not think you need to add anyone to the sysadmin Role for this. Per the article you just need to add the service account you...

I can duplicate what you're seeing with your audit query...it shows public still has GRANT S on sys.check_constraints for me but again in practice users that are only in public...

aaron.reese (2/19/2013)

---

FWIW I don't like script tasks as I think that they obfuscate what is happening (and VB.net scares me!) . I would prefer to use an alternative where...

Shawn Smith (2/19/2013)

---

Great ideas but unfortunately they did not resolve my particular issue. After running with your initial advice with no luck I tried extending your DENY commands to...

Sounds like you already did all the difficult parts of the processing you need to get done. A File System Task should be all you need to move the file...

I use Script Tasks so I can have access to .NET to do things that are not built into SSIS (e.g. FileSystemWatcher class) or maybe are built into SSIS but...

Define "does not work." Error message? Empty resultset? Remember, I cannot see what you see 🙂

Need any assistance on this piece or have you found what you needed?