[font="Arial"]Hello,

The server is looking for the path on the physical machine it is installed upon. You have probably given a path on the your local machine.

If you have permission...

[font="Arial"]Hello,

declare @columncombine

select @columncombine = select id + ',' + lastname + ',' + jobDescription from table

if the values are in a table with those column definitions and you want to...

Another suggestion. When you are in DTS there is a little dialog icon to modify the field contents so that you don't have to have an 8000 varchar (...

Hello,

I would recommend using DTS if possible.

Regarding your problem, from the error message it would appear that in the column mentioned there are rows that are not populated so the...

[font="Arial Black"]Hello,

From the error message I would suspect that DTS is using the Ole data functionality to attempt to access the file. It's not finding a default index or...