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,022 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,011 reads

Blogs

SQLSaturday Orlando Notes – Large Printed Schedules

By

One of the things we’ve done most years in Orlando is to print poster...

Upgrading Windows 10 Home to Pro

By

I use Hyper-V and a few other things that require Windows 10 Pro. When...

Power Platform Quick Tips – Episode 03: Documenting Power Automate Flow Logic

By

Welcome back to my series on Power Platform quick tips! In this episode you...

Read the latest Blogs

Forums

Impact value about missing indexes

By msimone

is there relation between Impact from sys.dm_db_missing_index_group_stats and Impact from cache plan? Thanks for...

Migrating DB encrypted by master key

By CharlieRL

I'm migrating DBs from a 2008 R2 instance onto a 2017 instance.  I have...

SQL Monitoring

By SQLEYES

Hi All, I have SQL 2012 instance on a vm server  which I am...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers