Maintenance plans are great for those who can't customize something better.

I prefer scripts, because they can be customized to your specific DR needs. For example, I've set up scripts...

Not sure it's relevant, but I plugged that error into Google and got this as the top result: http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/8a3558df-221a-45e6-8e08-c23c987c12a9

Seems to be a similar issue. Since you're going for an...

Actually, SQL Server stores dates in a numeric format, so that part of the question doesn't matter.

Here's how you can do the conversion in T-SQL, after pulling the data into...

As written, they'll do the same thing. Check the execution plans, you'll see what they're doing.

Of course, another thing to keep in mind, that I didn't remember to mention in my first reply, is that some applications may be sensitive to the patch-level of either...

rburko (9/25/2012)

---

No, it is preceded by a multicast transformation. One leg of the data flow goes into an OLE DB destination and receives 1,210 rows. The...

I'd go straight to Microsoft on this one, if Bing/Google/whatever doesn't pull something useful up straight off the error message.

Right. A new step would start it over again. If it's made any data changes by the time it fails, whether those will exist or not depends on...

That won't be a memory allocation problem, unless the server you're running it on is already all the way at the limits of the swap file. You'd know that,...

Sounds like a good way to end up in an infinite loop.

How are you running the package? SQL Agent job? If in SQL Agent, you can create an...

Just to clarify what you mean:

SELECT *

FROM (VALUES (1),(2),(3)) AS TVC(Col)

FOR XML RAW, TYPE;

That query will produce data that does not have carriage-returns in it, but when you open it...

I don't know, but it's easy enough for you to find out, if you can run a trace (Profiler or server-side) on the database where your query runs. That'll...

I too have been working on the "pick 2" rule mentioned by others here, for most of my adult life. Can't remember where/when I first ran into that rule....

It depends on why you have a different machine per vendor. If it's for security isolation, separate instances (one license) should be adequate. If it's for DR/BC, it's...

I'm not sure I follow you.

A View is just a saved Select statement. It can't be dynamic, really.

You can sort of do a dynamic view with an inline-table UDF,...