hi here my requirement is while creating log file it has to create with date and time in am or pm (my system time is in 12 hours format) can one tell me how to write expression for this plese

To do this, you want to make the connection manager you created for the log file to be dynamic using expressions. Select the connection manager for the log file and create a new expression in the Properties window. Select the Connection String property, then click the ellipse button to enter the Expression Builder window. In the Expression box, type the following expression to fulfill your requirements. "C:\\SSIS\\" + @[System::PackageName] + "_" + (DT_STR,4,1252)DATEPART( "yyyy" , @[System::StartTime] ) + "_" + RIGHT("0" + (DT_STR,4,1252)DATEPART( "mm" , @[System::StartTime] ), 2) + "_" + RIGHT("0" + (DT_STR,4,1252)DATEPART( "dd" , @[System::StartTime] ), 2) + "_" + RIGHT("0" + (DT_STR,4,1252)DATEPART( "hh" , @[System::StartTime] ), 2) + RIGHT("0" + (DT_STR,4,1252)DATEPART( "mi" , @[System::StartTime] ), 2) + RIGHT("0" + (DT_STR,4,1252)DATEPART( "ss" , @[System::StartTime] ), 2) + ".log" This code will name the file based on the package name, and then append a timestamp at the end separated by underscores. The double backslashes are required in the path, since a single backslash is an escape character. The RIGHT function enables you to easily guarantee that you will always have two characters for the month and day, for example. Otherwise, months like January would be trimmed to only a single digit (1) instead of two digits (01). When you run the package again, you’ll now see that the log file is timestamped. Sea Cloud

I WANT AM OR PM IN IN TIME AND AFTER RUNNING THE PACKAGE TWO LOG FILES ARE CREATING I WANT ONLY ONE WHAT CAN I DO TO GET AND ALSO I DONT WANT SYSTEM START TIME I WANT CREATING LOG FILE TIME AND DATE

Create a variable which collects the result of this query [eg:@date] SELECT CONVERT(VARCHAR(20), GETDATE(), 100) [eg: Jan 1 2005 1:29PM] "C:\\SSIS\\" + @[System::PackageName] + "_" + (DT_STR,4,1252)@date+ ".log" This will work...! Please mark posts as answered where appropriate

not working

Is it throwing any error or what is the output you are getting from that

a truncation occured during evalution of expression

Check whether the variable is getting the correct result..... "C:\\SSIS\\" + @[System::PackageName] + "_" +@date+".log" Try this....

but the file name is as Package_SELECT CONVERT(VARCHAR(20), GETDATE(), 100).log

There lies the problem..... Use Execute Sql task .. select a sqlserver connection ...... then in the Sql expression give this query.... then You will get the desired result..... Try This....!

i am not getting wre the problem