T-SQL Need Urgent help in CURL Execution issue from sql script.

• Question

• 

  

  0

  Sign in to vote

  Hi,

  Thanks in advance,

  We are using the CURL.exe for the FTP file transfer from one of our sql script. As we are unable to process two files at a time it allows only one file to transfer. It was working fine in our previous server which is

  "Microsoft SQL Server 2008 R2 (SP3-GDR) (KB4057113) - 10.50.6560.0 (X64)   Dec 28 2017 15:03:48   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)" 

  
  

  After migrating to new version we are facing issue. Please help me out in this thanks
  

  The process cannot access the file because it is being used by another process.
  FTP error code : 1

  
  

  D:\PriceLists_Support\curl\curl.exe -T J:\EU_INCR\PriceLists_INCR\810\Price_XXXXXXXX.csv ftp://ftp2.XXXXXX:21/ -u FTPXXXXX:XXXXXXX3! -w "2020-12-19 03:48:41.677,140588,111,120,%{http_code},%{size_upload},%{time_total}\r\n">>X:\INCR\PriceLists_Support_INCR\ftp_log.txt

  CURL Version:

  
  

  New Migrated SQL VERSION:

  Microsoft SQL Server 2017 (RTM-CU22) (KB4577467) - 14.0.3356.20 (X64)   Aug 20 2020 22:33:27   Copyright (C) 2017 Microsoft Corporation  Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: ) (Hypervisor) 

  Saturday, December 19, 2020 2:15 AM