Ok thanks Ramesh.

Thanks for that.

However, your code not only produced the XSD Schema but it also contains the data as well.

Is this correct as I was under the idea that an XSD...

Folks,

It was rather easy in the end. I have worked it by SUBSTRING.

MarkC,

That is neat! I don't understand how the query works with FOR XML PATH but I'll work it out.

As Jon has just said, time to brush up on some XML...

Chirag,

I have performed your solution with a cursor (Code below) however is there a way without a cursor? Jon has a method but it's very long winded and complex, surely...

You are going to have to call ORACLE and log a SR.

In SQL Server 2000, I had a Stored Procedure that used to send a NETSEND message using xp_cmdshell when I was about to restore a Database. The NESEND message is...

Ok Thanks.

Robert,

I have seen this before. This is a bug within Oracle. You will need to contact Oracle to get the fix for it!

This is Bug 5043675  and the patch...

Thanks Jeff, perhaps I should open my eyes!

Start off with the SQL Upgrade Advisor. You can install it when you install SQL Server 2005.

In addition get onto the SQL Server home page on the Microsoft website and...

Is this Server also a Reporting Services Server?

If so, are you using session caching for Reports?

"Set the Delay Validation to true" for which object or property?

That's it Crispin.

It was to do with the scope. I have set the scope to "Package" and it I can now see the variable.

Crispin,

This link http://www.sqlis.com/55.aspx is the procedure I followed and the example clearly shows the User Variable.

Sorry, but this must be some sort of configuration issue within SSIS unless of course...