Thanks, thats what I was trying to remember! I am getting an error now b/c I have a where clause after the end of the case statement - the error...

Actually I need to do the opposite. I need to set city_state = to its length minus 3 characters, as opposed to setting its length equal to 3 characters.

I believe...

Job owner has not changed. The backup to disk was sucessful - and the only difference between that job and the one that failed is backing up to disk (success)...

SQL Server Scheduled Job 'ADPS DATA ENTRY LOG BACKUP' ....Status: Failed ... Message: The job failed. The Job was invoked by Schedule 26 (Schedule 1). The last step...

You were absolutely correct. It must be late in the day for me, at least that is what I will tell myself.

Thank you again for your help!!

Ok, I get the MM/DD/YYYY

but then

set @datevar = cast(@filedate as datetime) gives me a conversion error.

@filedate is a varchar(10)

@datevar is datetime

and @filedate holds 01/11/2002

Thanks!!

Thanks - I think that will fix it. I was trying to convert the same variable from a varchar to datetime, instead of casting the varchar into a different datetime...

Right - the rtrim does not get rid of them. This makes things difficult b/c that is a dynamically stored filename that I am trying to access - the 2...

Sure - the table has one column varchar(17).

Lines of data

wb010120021.txt

wb010220021.txt

wb010320021.txt

wb010420021.txt

wb010520021.txt

for some reason, if I specify varchar(15) - which is the length of the data - I get a truncation...

I have a different type of bulk insert question. I'm using a format file - and I have dbl checked its format with the table format that data is being...

Your push routine was easiest to use - I put it in an execute process task and it works exactly as I need it to. You would think the http://FTP...

Generally speaking yes, it will be the current date in YYMMDD format. But sometimes we have to load multiple files (old files) - and so I need to grab all...