Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS FTP Task - Adding Date Critiera. Expand / Collapse
Author
Message
Posted Friday, June 14, 2013 11:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 18, 2013 10:22 AM
Points: 4, Visits: 19
Hi all. I'm looking for a way to transfer files from an ftp site where the last modified date on the ftp is yesterday ... GETDATE()-1. In other words, I don't need to transfer everything on the ftp, just what was posted the day before. Not sure if that can be done with expressions. I'm not much familiar with programming, but still getting my way around SSIS 2008. Any help will be appreciated. Thanks
Post #1463703
Posted Saturday, June 15, 2013 4:32 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, March 17, 2014 7:18 AM
Points: 2,439, Visits: 6,426
Hi,

I'm not an SSIS expert, so I'd suggest reposting your question on the Integration Services forum which you can find under Data Warehousing on this site. I'm sure you'll have more of a chance getting a suitable answer there.

Regards,
Jan


--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)

In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #1463912
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse