Name Flat file at run time

Hi,

I create a flat file in my package using Dataflow task and then I need to send that text file on some FTP site but the problem I am facing is I need to generate file name at run time like file name should be like "abc.yymmdd.txt" where yymmdd are Year,month and date.

Is there any way to give name to a flat file?

Thanks,

Pooja

your Connection Manager has a Property Collection called Expressions. Expand that, and set the ConnectionString to a variable expression.|||

"ABC." + (DT_WSTR,8) ( (YEAR(@.[User:ateTimeVar]) * 10000) + (MONTH(@.[User:ateTimeVar]) * 100) + DAY(@.[User:ateTimeVar]) ) + ".TXT"

Change the variable reference (@.[User:ateTimeVar]) to GETDATE() if you want today's date to be used.

sql

My own Dataflow Component. How make a property with list of predefined values?

I am creating of may of dataflow component.

How make a property with list of predefined values?

Thanks in advance.

If you create a custom UI for the component, you can display any list for the property that you like.

If you really want to do it right, so that the list shows up in the property window in Visual Studio, you'll probably need to implement a UITypeEditor and possibly a TypeConverter. See the Books Online topic "Design-time Methods of a Data Flow Component" for more information. http://msdn2.microsoft.com/de-de/library/ms135969.aspx

|||

Please see this earlier thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=115642&SiteID=1

-Doug

|||I would also look at using an enumeration for the property type/value.