Via what? REST? SOAP? FTP?

They're two ways to do the same task. SSIS OLE DB Destination with Fast load uses OPENROWSET to leverage the BULK INSERT interface. OPENROWSET when used from T-SQL with a...

I do not think you can delete Excel data using an OLE DB connection but I read you can use the DROP TABLE followed by CREATE TABLE syntax to accomplish...

inHouseDBA (6/4/2012)

---

Greeting All:

Using SQL Server 2005 (9.00.5000.00), but moving to SQL Server 2008 in 4 months.

I am in the process of updating my Weekend Maint scripts..

Currently I Reindex Clustered and...

Please do not enable OLE Automation procs unless absolutely necessary...which is only if a third-party vendor requires it in my opinion.

May I recommend using PowerShell for this task? This...

Try something like this. Running it with the -WhatIf will only report what would be deleted by this command. Remove the -WhatIf when you're ready for it to do work.

#################################################

#init...

dbdmora (6/5/2012)

---

Hello opc.three, I apologize for not replying sooner. I been putting out a lot of fires out.

We have run sp_validatelogins on all our servers and found a few orphan...

I am not sure you can do that when storing packages in msdb, I would need to test it. However, if you are storing your packages as files and executing...

Fly Girl (6/4/2012)

---

Every project has its own considerations. As a contractor I'm here for a limited amount of time. Training someone to take over this process at a 'very small...

You do not need to drop and recreate the index. You can use ALTER INDEX to specify the new NORECOMPUTE value.

ALTER INDEX [index_name]

ON [schema]....

If your target workplace is in a corporate environment, which it...

You can export them from SQL 2005 to disk using dtutil (2005 version) if having them as files as a middle-step makes more sense for your migration. You could then...

I recently saw this on another post...

You can use PowerShell from within SSIS using this[/url] (works well). Or you can call an SSIS package from PowerShell by invoking DTExec (no...

Doubtful.

Can I use SQL Server Partitioning to Optimize Fulltext Searches?