Don't like the cursor. Can you run something like this?

SELECT o.name,

ddps.row_count

FROM sys.indexes AS i

INNER JOIN sys.objects AS o ON i.OBJECT_ID = o.OBJECT_ID

INNER JOIN...

Resender (4/7/2014)

---

Ok I got the following issue:

SSIS to import flat files,everything went fine for months,now suddenly errors.

At first the errors indicated an error in the file (the provider of the...

naresh0407 (4/5/2014)

---

Hi All,

I have file name like this CLM_20140504.I will get file everyday..I just need to check whether file is...

Please read this and then post back with any specific questions you may have.

Lempster (4/4/2014)

---

Phil Parkin (4/4/2014)

---

Lempster (4/4/2014)

---

You could also use a 3rd party custom component such as the Checksum component from Konesans to calculate and store a checksum for the five address...

Lempster (4/4/2014)

---

You could also use a 3rd party custom component such as the Checksum component from Konesans to calculate and store a checksum for the five address columns you are...

Eric Mamet (4/4/2014)

---

I am indeed using SQL Server Developer edition 64 bits and I do get through once I have created a 32 bits alias.

I did not realise that...

Eric Mamet (4/4/2014)

---

Phil,

One more question if I may...

I can get this Alias to work when I connect through ODBC (like through MS Access or an ODBC connection through an...

brad.mccollum (4/3/2014)

---

None at all of the examples I am finding actually work once I implement and modify the code for my particular situation. It only seems to loop through the...

Have a look here.

We don't use SSISDB in dev, just everything after dev.

Without actually looking at the bothersome data, I'm running out of ideas on this one. It sounds like you should be able to narrow down roughly where the problem lies...

Eric Mamet (4/2/2014)

---

Phil,

In previous versions, I found...

lmnorms (4/3/2014)

---

Thank you. Adding in:

Select '<?xml version="1.0"?>' + Cast((

[Original Select

]

) AS VARCHAR(MAX)) as XMLData

Worked nicely....

You mention SS2012 in your post, yet this is a 2005 forum, which is a bit confusing.

If you could post some source data in readily consumable format (see the link...

Koen Verbeeck (3/31/2014)

---

Phil Parkin (3/31/2014)

---

Apologies - I should...