Here is the fix for VS 2010 and VS 2012.

FIX: SSIS 2012 XML Source task cannot load data from a URI

http://support.microsoft.com/kb/2991526

Enjoy!

I'm having the same problem. The SSIS package uses the native FTP task to pull down a number of files. It seems random but never gets more then...

Upgrade to SQL Server 2005.

Then you will have the XML data type which gives you up to 2 gigs in a single XML instance. If you need more then...

I cannot see your XML example but this should get you started.

Note: Replace the ( and ) with the correct XML tag indicators.

DECLARE @XML XML

SET @XML =

'(root)

(row)

(ID)1(/ID)

(Supervisor)1(/Supervisor)

(Center)Dallas(/Center)

(/row)

(row)

(ID)2(/ID)

(Supervisor)2(/Supervisor)

(Center)Dallas(/Center)

(/row)

(row)

(ID)3(/ID)

(Supervisor)3(/Supervisor)

(Center)Dallas(/Center)

(/row)

(/root)'

SELECT

x.value('ID[1]','int') AS...

Instead of preaching your “RBAR” cliché and putting people down for doing it the wrong way why don’t you get off your soap box and make yourself helpful for a...

J,

INNER JOIN T2 ON T1.something = T2.somethingelse

VS

INNER JOIN T2 ON T2.somethingelse = T1.something

This is exactly the same to SQL Server. Take a look at the execution plan. It...

SELECT

Column1

FROM

YourTable

FOR XML RAW('SomeNameHere'), TYPE, ELEMENTS

Just add the following after your WHERE clause.

FOR XML RAW('Team'), TYPE, ELEMENTS

The code I'm providing is a start in the right direction. You however need to reformat your XML so your data is organized in a more normalized manner. ...

Your welcome.

TIP:

For small amounts of XML use Xquery. (If you cut and past your xml into a text file it should be < 5MB)

For Large amounts of XML use Open...

I don't know what the size of your data types are. I was just guessing when I set those values. If you need support for something larger just...

If you don't like OPEN XML, or server dosn't have the resources to support it.

Here is the Xquery method.

DECLARE @XML XML

SET @XML = 'YOUR XML GOES HERE'

SELECT

x.value('debt_id[1]','VARCHAR(30)') AS debt_id

,x.value('payment_amount[1]','MONEY')...

OPEN XML Method.

Note that this allocates 1/8 of your servers memory when you call sp_XML_preparedocument. My server has 10gigs and sits at 8743mb avail on average so its...

If you have code like this or need to use code like this, you have other greater issues going on and need to put the pipe down.

beath,

I'm not talking about the placement of the backup files. I'm talking about the maintenance plans that I use to create the backup files. He wants me to...