 | |
SQLDTS Date Offset function
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
SQLDTS Date Offset function -
11-04-2004
, 02:49 PM
#2
| |||
| |||
|
|
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. |
date/time. The current date/time is substituted at runtime as defined by
the format which must be enclosed in <>.
Try -
/Pictures/<mmddyyyy>
and a value of -86400.
(I think there is a mistake with the quote example, so I'll check that
out.)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
#3
| |||
| |||
|
|
In message <a6b91807.0411041249.35d6d5a8 (AT) posting (DOT) google.com>, slugfest bh_parker (AT) hotmail (DOT) com> writes 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. The date offset is a value in seconds that is added to the current date/time. The current date/time is substituted at runtime as defined by the format which must be enclosed in <>. Try - /Pictures/<mmddyyyy and a value of -86400. (I think there is a mistake with the quote example, so I'll check that out.) |
In terms of the GUI interface of your SQLDTS Task, where do I place
the value -86400? Is it something like this...
/Pictures/<mmddyyyy-86400>
OR
Is it a separate field all together?
Thanks.
#4
| |||
| |||
|
|
Darren Green <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote in message news:<NlLj7KDXuriBFwdo (AT) sqldts (DOT) com>... In message <a6b91807.0411041249.35d6d5a8 (AT) posting (DOT) google.com>, slugfest bh_parker (AT) hotmail (DOT) com> writes 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. The date offset is a value in seconds that is added to the current date/time. The current date/time is substituted at runtime as defined by the format which must be enclosed in <>. Try - /Pictures/<mmddyyyy and a value of -86400. (I think there is a mistake with the quote example, so I'll check that out.) Darren, In terms of the GUI interface of your SQLDTS Task, where do I place the value -86400? Is it something like this... /Pictures/<mmddyyyy-86400 OR Is it a separate field all together? Thanks. |
Cheers
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
#5
| |||
| |||
|
|
In message <a6b91807.0411050726.377057be (AT) posting (DOT) google.com>, slugfest bh_parker (AT) hotmail (DOT) com> writes Darren Green <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote in message news:<NlLj7KDXuriBFwdo (AT) sqldts (DOT) com>... In message <a6b91807.0411041249.35d6d5a8 (AT) posting (DOT) google.com>, slugfest bh_parker (AT) hotmail (DOT) com> writes 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. The date offset is a value in seconds that is added to the current date/time. The current date/time is substituted at runtime as defined by the format which must be enclosed in <>. Try - /Pictures/<mmddyyyy and a value of -86400. (I think there is a mistake with the quote example, so I'll check that out.) Darren, In terms of the GUI interface of your SQLDTS Task, where do I place the value -86400? Is it something like this... /Pictures/<mmddyyyy-86400 OR Is it a separate field all together? Thanks. The offset goes on the second tab "File filter date offset (seconds):" Cheers |
When I use the File Filter, it is applied to both the Source and
Destination. Is there a way to apply it ONLY to the Source?
Thanks.
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.