This stored procedure takes four parameters1)file to ftp2)server name or IP3)ftp login4)ftp passwordSP will ensure that local file exists before continuing,it will create and execute a batch file in order to push the file to the remote FTP server.--exec exampleEXEC dbo.up_FTPPushFile 'c:\temp\test.txt', 'server', 'user', 'password'
2002-12-09
4,747 reads
If you ever need to create a credit card like number this stored procedure is for you.Most credit cards contain a check digit, which is the digit at the end of the credit card number. To generate the check digit, the LUHN formula is applied to the number. To validate the credit-card number, the check […]
2002-11-30
4,077 reads
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
By James Serra
A TON of new features announcements at the European Microsoft Fabric Community Conference help...
I am trying to build an ETL for an Existing Table. The ETL (SSIS)...
(This is probably the wrong forum to be posting this question, so please forgive...
Hi, We are using database snapshot together with changetracking to keep a datawarehouse up...
In the current (2024) version of the Data Migration Assistant, which on-premises targets are available?
See possible answers