Create a view that formats each column the way you want, then export from the view in DTS.  Liberal use of STR, CAST, CONVERT, REPLACE, and STUFF should do the job.

You can set the default location for data and log files in Management Studio by going to Server Properties - Database Settings.  This will only affect new databases, it won't...

You say you have two packages that run three times slower as a scheduled job than they do when you run them manually (even though other packages don't seem to...

It's not just hard, it is impossible to handle an error in a trigger.

A trigger is considered to be part of the statement that caused the trigger.  You can't check...

Use BULK INSERT with a format file.

This query is not necessarily bad, but if it is bringing your server down you need to take a long hard look at it.  Does the execution plan look optimum? ...

If the source and destination tables have different structures, you can create a view on the source system that matches the destination table and export from the view using BCP,...

You might consider using BCP to write all the data from the source server to a file, then use it again to load the file into the destination table.  If...

If you want a bulk insert to ignore some table columns that don't appear in the input file, the format file must have 0 for prefix length, column length, and...

The basic problem is that if you create a new SQL login without providing the SID value, a new SID will be assigned.  Then when you restore or attach a...

That is one reason why I like to use replaceable tags instead of multiple concatenation to build strings.  I find it much easier to debug and maintain, especially if you're...

It is expecting an END to match the WHILE ... BEGIN, so there is a syntax error on whatever comes before GO.

If it was as simple as copying the script, the upgrade wizard could do it for you.  SSIS scripting is done in VB.NET instead of VBScript.

Most of it is not...

One step that would make life easier is to create SQL logins on your new server with the same SID as the old server.  Then you don't need the sp_change_users_login...

An easy way to create the temp table would be:

set @Query = 'IF OBJECT_ID(''tempdb..#MyTempTable'') IS NOT NULL  DROP TABLE #MyTempTable

SELECT * INTO #MyTempTable FROM ' + @Tablename + ' WHERE...