FTP files using SQL stored procedure

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'

5 (2)

2002-12-09

2,270 reads

Add Check Digit (LUHN)

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

1,212 reads

Blogs

Reviewing 2019 Career Goals

By

According to this post, I rate 2019 as a Failure. Of the books I...

ASF 029: Tomaz Kastrun interview

By

Introduction Tomaž Kastrun is BI & DEV developer, data analyst & data science. With...

Schema Filtering in SQL Prompt

By

I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue...

Read the latest Blogs

Forums

Can we use DC SQL Cluster Role name in DR Site (Same name Both Site)

By Harshana-455711

Hi I have SQL Server FCI running in my DC site following are cluster...

error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE

By webrunner

Hello experts, A client is reporting the following error when his application tries to...

Connectivity to Oracle 12.2 instance via OLE DB ?

By VoldemarG

I installed Oracle 12 on Windows 10 in  all possible ways/configurations, including the defaults....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers