Are you saying you created one stored proc that handles inserts, updates and deletes for over 100 tables using dynamic sql?

Try shrinking by a very small amount. Can you restore the DB to a test area so you can drop into SINGLE_USER mode and try the shrink, or can you...

A simple chore with PowerShell. Here is a one-line PowerShell command that does the work...

You're welcome. I try to pass along the latest info regarding the System and Catalog Views to keep the ball moving forward so to speak. The newer Views have more...

nzhang6666 (8/28/2012)

---

Thanks for the replies, I was on holiday so didn't come here.

Actually in my first proc (nz_test1) I just want to make sure to turn on 'xp_cmdshell' and 'ad...

bwperrin (8/28/2012)

---

Finally figured out how to get it working. SQL uses the sqlps utility, which is a Windows PowerShell mini-shell, and it has some restrictions such as mentioned above....

You could always switch to a CmdExec step type. Or write a PowerShell script to interact with the file system, which it is more capable of doing than T-SQL.

I have used SSRS report subscriptions to send renderings of reports places on a schedule. This would help satisfy the requirement to send the report to your users on a...

If you can use the SQLCLR here is an option that is a bit more expressive in terms of the syntax:

SELECT p.Prod_Name,

...

Thanks for posting back. As far as I know the validation errors you are seeing are considered non-fatal so SQL Agent carries on as usual. In your package you can...

You didn't answer my question.

No problem. Happy to help. I am learning from this too.

Maybe you could try it with a local login just to see if you can isolate it to being a...

The Bulk Insert Task will work but I prefer using a Flat File Source with an OLE DB Destination setup w/ FastLoad.

The former replaces the need for a format file...

If you want the package to keep going then you cannot fail the Task. I looked up the exceptions that can be thrown by the DownloadFile method and you'll likely...

Execute Process Task