Have you tried Full Text Indexing?

John

If this is an ad hoc query you wish to run against multiple servers, you might consider setting up a Central Management Server.

John

That sounds like a line from a batch file rather than a SQL script.

John

Craig

Don't shrink the logs, but make sure you're backing them up regularly. Search the web for "SQL Server Transaction Log Maintenance" for more information.

John

Roland Alexander STL (1/4/2013)

---

Don't think ALTER is the permission you want, as I think that applies to changes in the table's structure (I'll be corrected if I'm wrong, so stay...

Mark

Fair enough about the staging table - it was just a suggestion. Might still be worth considering on the output table, though.

If I may say so, the thing about...

It might be more efficient to do the update in your staging or output table instead of as part of the transformation. You'll need to test to find out...

If you have the option to clean the data in the database itself, rather than just the extracts, I'd recommend you do that. Use NULL where the value is...

If you've only got the one instance in your cluster, you could evict nodes until you're left with a single-node cluster. Otherwise, you're probably best building a new instance...

Why not? If you put this in...

That's more a VB question than a SQL Server question, and outside my area of expertise. You could try using MsgBox.

John

Looks like it's to do with the way the command string is being built. Perphaps you could put a line in your code to print the command string before...

Phil Parkin (1/3/2013)

---

Integration Services does not sound like the right tool for the job - it's not an always-on, data-drip-feed type solution. Have you considered CDC or replication instead?

Rather than...

Ram

Use the Import/Export wizard. You have the option to run it immediately or save it as an SSIS package.

John

I think you had it right in your previous post. But make sure you test it before it goes anywhere near live.

John