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

  • Question

  • 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


  • I'd try asking for help over here.

    sql-server-transact-sql - Microsoft Q&A



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    • Proposed as answer by KHURRAM RAHIM Saturday, December 19, 2020 5:55 PM
    • Marked as answer by Dave PatrickMVP Wednesday, December 30, 2020 9:44 PM
    Saturday, December 19, 2020 3:32 AM