SQLDTS Date Offset function
From: slugfest (bh_parker_at_hotmail.com)
Date: 11/04/04
- Next message: Patrick: "Re: Help! Are my DTS Packages gone for good?"
- Previous message: Allan Mitchell: "Re: Creating a mirror image of a database"
- Next in thread: Darren Green: "Re: SQLDTS Date Offset function"
- Reply: Darren Green: "Re: SQLDTS Date Offset function"
- Messages sorted by: [ date ] [ thread ]
Date: 4 Nov 2004 12:49:58 -0800
I'm using the SQLDTS FTP Task and sm trying to use the date offset
function to grab files from a dated folder. The source is
"/Pictures/(dated folder)". The dated folder is in this format
mmddyyyy or 11042004. What I am trying to do is set up the FTP task to
grab the files from the PREVIOUS day's dated folder...which is why I
need the date offset function.
The example on www.sqldts.com gives this...
Similarly a format of FilePrefix_<dd_mm_yyyy>.txt would result in
FilePrefix_30_11_2002. If you combine this with the date offset of
-86400 this will translated to FilePrefix_26_11_2002.log.
But that isn't clear to me.
Any help is appreciated.
- Next message: Patrick: "Re: Help! Are my DTS Packages gone for good?"
- Previous message: Allan Mitchell: "Re: Creating a mirror image of a database"
- Next in thread: Darren Green: "Re: SQLDTS Date Offset function"
- Reply: Darren Green: "Re: SQLDTS Date Offset function"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
