ahhh

got it, thank you very much. ill try this

The tool is installed on my server. i need to use this utility to convert the '|' delimited text files from unix to dos so that i can load them...

declare

@Path varchar(128),

@FileName

varchar(128)

select @Path =

awesome, thank you very much

but what would the batch file look like. stuck on the syntax

im setting up a procedure to move the file on a daily basis as a new file is loaded in that folder daily

So i have a flat file that is uploaded into my share every day. I need to run this job everyday to import the new data. any sample coding or...

So if i am creating a new table and want the '00' to be added to the data comming into it. what would the code look like?

Thanks Ray