Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SSIS Package for Access

Author  Topic 

werhardt
Constraint Violating Yak Guru

270 Posts

Posted - 2009-02-27 : 08:40:51
My coworker would like see if there is a way to create an SSIS package that automatically put the date that the report is run in the in the access database naming convention. Is there a way to do this? So, what she want is her database to come out like CoAM02272009.mdb, then next month would be CoAM03272009.mdb

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-03-02 : 10:00:52
Have a look at expression builder in ssis
http://msdn.microsoft.com/en-us/library/ms137574.aspx
Go to Top of Page
   

- Advertisement -