Our apps are .NET and C++ based so we use NUNIT to devise a long list of test scripts. Come service pack time we simply rerun the NUNIT...

You should have

an Icon for a server that represents you connection to your SQL Server.

An Icon for your text file that represents you CSV file.

A connecting line between the...

Are you allowed to change your database recovery mode to BULK LOGGED?

DTS's can be as simple or as complex as you want.

You can import/export from/to a variety of different sources. For example, I had a datawarehouse that needed to almagamate...

Just for the sake of testing change your INSERT INTO query to SELECT INTO TestTable

That way

INSERT INTO MarketRiskdev.dbo.Import_Argentina

SELECT * FROM TestTable

should work. If it doesn't you will be closer...

bcp is very fast at extracting or importing data.

As Data Transformation Services suggest they can do just about anything you want to data. DTS includes a specific task that...

I'm just wondering why you are using SQL Query Analyser to do this?

Is is just for a quick one off?

If you have to do it more regularly then consider using...

Recognition, visible results, the desire to fund a decent mid-life crisis.

Within SQL Query Analyser make sure that under Tools/Options/Results you have the following settings

Default Results Target : Results To File

Results Output Format : comma delimited

Print Column Headers : Checked

Putting the...

My point about removing the INSERT was to prove that the XML shredding actually works and could come back as a recordset.

If this was the case the chances are that...

Put it this way, you have sat for 15 years in front of a cathode ray gun.

When I was at college in the 1980s one of our tasks was to...

Temporarily comment out the INSERT statement.

If that doesn't work try supplying a small XML file in the correct format.

What happens if you change the parameter to NTEXT rather than TEXT?

Have a separate table.

BEGIN TRANS

INSERT INTO dbo.YourSeparateTable

SELECT FROM dbo.YourOriginalTable

WHERE [qualifying criteria]

DELETE FROM dbo.YourOriginalTable

WHERE [qualifying criteria]

COMMIT TRANS

Then BCP out dbo.YourSeparateTable

Then TRUNCATE dbo.YourSeparateTable

Incidentally a fast way of generating the structure of YourSeparateTable...

cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@xmlInput", SqlDbType.Text, 1024));

Possibly 1024(1KB) should be 5120000 (5MB)?

I have read an article on physical file defragmentation on a SAN or RAID system http://www.raxco.com/products/perfectdisk2k/whitepapers/pd_raid.pdf.

The gist of RAID/SAN defrag is that

a) Not all defrag tools are compatible with SANS/RAID...