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

1,687 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

704 reads

Blogs

What does the Machine Learning process look like?

By

This is the second article in the Machine Learning area. I have explained a...

Azure Cosmos DB: real-time data movement using Change Feed and Azure Functions

By

In this article, we will focus on creating a data pipeline to ETL (Extract,...

Quick 6 month check – how are those learning goals going…?

By

So in January I wrote a blog post on some goals I had this...

Read the latest Blogs

Forums

DB Snapshot on TDE Enabled Database

By GonnaCatchIT

Dear All, I have a DB on which TDE is enabled. When trying to...

Installing SQL 2017 Error

By garryha

I am trying to install SQL Server 2017 Enterprise Edition.  It is an Iso...

Select n records in table X from a field on table Y

By luisalfonso70

Hi, hope someone can help with this. I've the table gifts_to_give: Id_give      number_of_gifts          name ...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Intersection

See possible answers