Sorry I have not seen the error you give in your PM so I have quoted it here for everyone to see. I believe it indicates that you don't have...

You need to use SQL Server Management Studio for 2005 databases.

If you are, check the default database in the connection settings for the server because if it is set to...

What difficulties are you getting?

You need to use SSMS - Right click the database in object explorer - Tasks - Import data.

Choose Flat File Source as the Data source and...

There is a Text qualifier box on the General tab of the FlatFileSource Import wizard. Defaults to none but you can just type the double quote in there.

Also choosing a...

Try char(34) to make the select command generate a double quote 'during the query'. This avoids the problem of the commandline seeing that double quote. I have also added...

I think this SET option is only for the scope of the current session. BOL says you cannot have more than one table with identity_insert on and you will get...

I can't get my head around the double quotes cos bcp doesn't seem to like them in the terminator field, but you could replace the "/t" with "," to get...

That is still executing the statement within SQL server.

You need to pass the command to the cmdshell.

exec master..xp_cmdshell @cmdcommand

Note that xp_cmdshell may not be enabled on your systems. If you...

Sorry, I should have read your error message.

bcp is a commandline executable run from a dos prompt not from within SSMS.

Tony

To generate a format file you need to use 'format' instead of 'out'.

This example is from BOL and BOL is your friend here for all the possible flags for...

Tony,

You need to give the name parameter a size for the varchar declaration.

CREATE PROCEDURE UPDATE_TABLE_COUNT @NAME VARCHAR(4), @COUNT INT

AS

UPDATE TABLE

...

Colin,

Rather than repeatedly use the column alias 'Other1TotalLab' in the next column, just repeat the calculation. (Maybe a performance guru will shout at me here!) Also if you add 1...

You still need to use the update statement.

I would avoid the use of the 'text' datatype. Something like this below but remember you need to work on the error trapping...

Once all the data is in the staging table I don't understand the need to delete records and then export/re-import using a template. Are you doing this just to unpick...

Can't you just use varchar(max) and import the records into a single column. If you import the first char to a different column you could use that to select out...