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
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SSIS

Author  Topic 

kabon
Starting Member

48 Posts

Posted - 2012-07-12 : 06:08:56
I have OLE DB Source -> Flat File Destination...

I want to debug it for one hour and that file name after debug (export) looks like filename_Calender_Time.txt

Can you help me please?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-07-12 : 09:46:26
hmm...debug for 1 hr? whats that for?

for dynamic filename you can use expression builder

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

kabon
Starting Member

48 Posts

Posted - 2012-07-13 : 00:03:23
not for 1 hr, if I debug the flat file, that file name if I debug twice it'll be same, and I want to the same name to file name with date and time behind the file name for example :
abcde.7/13/2012.11:06:20.txt
Go to Top of Page
   

- Advertisement -