Glad I could help. Now if you only knew just how little I know about the details of clustering... :hehe:

If I understaood you correctly (not guaranteed), I don't think you mentioned any details on HOW the vendor tool keeps those LUNs in sync. I would choose to...

I'm not completely familiar with how you do it, as tempdb is a "system" database, but have you googled "moving tempdb SQL Server nnnn" where the nnnn is your SQL...

Adi Cohn-120898 (12/18/2013)

---

Actually with a variable the server doesn't know what value will be used. This is one of the differences between variable and parameter. It can...

While I'm not 100% certain, my gut says that declaring the variable allows the optmizer to see that what's being compared to is a constant, whereas the expression appearing directly...

I don't understand what "unstructured" data has to do with needing NTEXT as a data type. NTEXT vs. TEXT is merely a matter of being able to store...

Is there an ODBC driver installed and/or configured? I'm not familiar enough with Oracle's client software to know what connectivity it's natively capable of. Also,...

What is the nature of your destination? Is it an actual database table in an RDBMS, or is it something else, like an Excel spresadsheet?

There wouldn't be a...

Talk to your DBA. That sounds like an actual physical corruption type of problem.

Just curious about the impact of changing the following statement:

SET @someValue = REPLICATE(CAST('a' AS varchar(max)) , 60000)

to:

SET @someValue = CAST(REPLICATE('a' , 60000) AS varchar(max))

It doesn't really matter WHERE the package is located. Running it via xp_cmdshell is the ENTIRE problem. Once the command shell has been invoked, SSIS is...

How about providing the table schema and your query against that source? It may be possible that something data-related is causing an issue based on some other...

Yeah, you definitely need to add more details here. For example, you state that you are trying to find the last "validity" situation for each date in the...

You're quite welcome...

Jim88 (12/13/2013)

---

No, it would not work because it inside the root. This XML has to be outside the root.

Actually the previous idea was good. I could make it...

Jason,

Thanks for the correction. I hadn't really given that much thought, and had made one of those assumptions that can just show up out of an apparent...