FSO seems the way to go, for what you're describing; if it doesn't do the trick in Dynamic Property Task, try it in an ActiveX script. Sorry I can't be of more specific help on this one.
Bryant --- In [email protected], "les_claypoo1" <[EMAIL PROTECTED]> wrote: > > 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 --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/I258zB/QnQLAA/TtwFAA/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/
