Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.sqlserver.programming > #31292

Re: While FTP'g the archive attribute appears sometimes preventing me from renaming the filename using T-SQL

Show all headers | View raw

George Lewycky (gelewyc@nyct.com) writes:
> I have a batch job running on SQL Server to GET an ascii file from an
> AS/400 machine and after I process it I rename the file with a date
> stamp using Transaction SQL (T-SQL) under SQL Server 
> 
> Its been running a few years without a hitch but this year the file
> won't rename and I'm suspecting its due to the "A"rchive attribute being
> set--but only its 5th time this year? 

My only comment is that this is good incentive to reimplement the operation
in Powershell or SSIS. This stuff should not run from SQL Server at all. 
T-SQL is not a general-purpose programming language.


-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

Back to microsoft.public.sqlserver.programming | Previous | Next — Previous in thread | Find similar

Thread

While FTP'g the archive attribute appears sometimes preventing me from renaming the filename using T-SQL George Lewycky <gelewyc@nyct.com> - 2016-02-29 14:50 -0800
  Re: While FTP'g the archive attribute appears sometimes preventing me from renaming the filename using T-SQL Erland Sommarskog <esquel@sommarskog.se> - 2016-03-01 21:37 +0100

csiph-web