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,908 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

891 reads

Blogs

Weekly reading #29

By

The Data Breach Game: The 9 Worst IT Security Practices Joey D’Antoni shows bad...

#PowershellBasics: Get-Help -Online

By

One of the other things I learned from the Powershell class I’m taking this...

Undercover TV Podcast – Scripting Options in SSMS

By

In this episode of the podcast, Adrian looks at the scripting options available in...

Read the latest Blogs

Forums

Used Stored procedure in SSIS with different database name in DEV, Test and Prod

By patla4u

Hi, Can you please give me Idea, how can i use stored procedure in...

How to upgrade to SP3 with multiple named 2008R2 instances on same server

By trhorner

I have a server with two named instances of 2008 R2, SP1.  I have...

Upgrade from SP1 to SP3 on server with two named instances, run upgrade twice?

By trhorner

I have a server with 2008 R2 SP1 using two named instances.  When I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers