Just found this article, which does something similar but saves the XML to a file.

Does it work for you?

http://www.rad.pasfu.com/index.php?/archives/25-SSIS-Sql-Server-to-XML-Save-to-file.html

Graham

Hi Wendy,

You can extract data from an Excel spreadsheet using SSIS but I've had some issues in the past, especially when the number of columns was over 255, as Excel...

If you change the SQL task to return a simple hard coded string as a test (for example <test>testing</test>) does this append the root node?

I've done something similar and never...

Could you use a broker package that would reuse the existing packages that are there?

Each package could load in the details of the source and destination depending on a number...

What data is in the file, is it in a foreign language?

What collation is the database?

Graham

Hiya,

I haven't tried importing data via Open Query so can't really comment, sorry.

If you set the underlying table to be a NVARCHAR you shouldn't need to use a cast or...

Hi,

From what you have described I don't think this is an issue with the size of the fields but with the data itself and that SQL cannot convert the data...

Hi,

With a little (ok a lot) of help from Google I've been able to get the MDX working.

It does take a bit longer to run (from 1 seconds to ~4)...

With a virtual partition we can split it...

Hi,

Thank you for your reply.

Gianluca Sartori (1/22/2012)

You can use more than 4GB. Is memory an issue now on SQL2000? If not, you will not probably see memory pressure on the...

Hi Charlie,

I haven't actually used the bulk insert command (I generally use SSIS to import files into SQL), but my guess is that something is wrong with the source file.

Are...

Brilliant, thank you very much for your speedy replies.

Thank you!

Graham

Hi,

Just thought I'd mention that the ClearMem utility does seem to have had an effect and so far Visual Studio seems to be working more reliably.

So if anyone else is...

I've just installed the software, not 100% sure what to do with it yet though!

I've set up a schedule and it thinks it cleared the system memory sucessfully.

Graham

Hi,

SQL is configured to claim between 15 Gig and 25 Gig of memory.

Analysis Services is configured to claim 20 Gig max.

Rebooting the server sometimes helps the problems dissapear, but we...