That's what I had the dynamic property task set to
(FileSystemObject), but if I use SQL
(select '\\servername\folder\filename' + {fn Now()} + '.csv' it
doesn't rename it because it is using the connection to the SQL db
instead of the connection to the location where the file will be
place. If I switch it to the connection where the file will be it
is not a valid statement.(cause its not a DB). So that was I was
wondering other ways to rename the file. Global variable,
environmental variables, activeX scripts. stuff like that.
Thanks,
-Tom
HAPPY THANKSGIVING TO ALL... EAT LOTS OF TURKEY AND PUMPKIN PIE!!
--- In [email protected], "Databasedude.com"
<[EMAIL PROTECTED]> wrote:
>
> How about FileSystemObject?
>
> HTH
> Bryant
>
> --- In [email protected], "les_claypoo1"
> <[EMAIL PROTECTED]> wrote:
> >
> > I have a dts job set up to export a .csv file
to '\\servername\folder1
> > \filename.csv' I know there is that Dynamic Property Task but
> > I can't get it to work to rename the file
to 'filename2005.11.23.csv'.
> > Any ideas on how to get it to work? I tried making a little sql
> > statement to populate that name but it doesn't work because the
> > connection source is set to the SQL DB, not the location where
the file
> > will be placed. I was wondering if I should just do this with
active-X
> > (vbscript)??
> > Thanks for any help. -Tom
> >
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/u8TY5A/tzNLAA/yQLSAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
