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 web application is not picking up all the data in the table

I'm facing a strange problems regarding an application my company is hosting.
I'm a system engineer and not a developer, so i'm a little bit lost here.
I have a cluster running W2000 SQL Server, this SQL server has some linked
servers (oracle) with one of our costumers, everyday several SQL jobs update
our SQL tables with info from that oracle servers. But for some reason,
recently the users started complaining some some of the info is not available
on the application, after some investigation, i could confirm that everything
is ok with the data on the costumers servers and that our tables keep being
updated with the info, but the application can't seem to catch any of these
info (vendor information in this case). It seems to me that at some point the
table has some corrupt data or something that is preventing the application
from getting all the data.
Do you guys thing this is something with the SQL table or within the
application?
All the help and suggestions are welcome. (my msn is below)
Best regards
Francisco Batista
Portugal
msn: f_batista69@.hotmail.com
No where near enough information to help you. I suggest you find someone
that knows the application to help you.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"francisco - Portugal" <f_batista69@.hotmail.com> wrote in message
news:955AF918-D80E-4B0C-B626-09733B1BE251@.microsoft.com...
> I'm facing a strange problems regarding an application my company is
> hosting.
> I'm a system engineer and not a developer, so i'm a little bit lost here.
> I have a cluster running W2000 SQL Server, this SQL server has some linked
> servers (oracle) with one of our costumers, everyday several SQL jobs
> update
> our SQL tables with info from that oracle servers. But for some reason,
> recently the users started complaining some some of the info is not
> available
> on the application, after some investigation, i could confirm that
> everything
> is ok with the data on the costumers servers and that our tables keep
> being
> updated with the info, but the application can't seem to catch any of
> these
> info (vendor information in this case). It seems to me that at some point
> the
> table has some corrupt data or something that is preventing the
> application
> from getting all the data.
> Do you guys thing this is something with the SQL table or within the
> application?
> All the help and suggestions are welcome. (my msn is below)
> Best regards
> --
> Francisco Batista
> Portugal
> msn: f_batista69@.hotmail.com
|||Thanks anyway for your time, i will try to reach a developer that was
involved in the built of the application.
Merry Christmas
Francisco Batista
Portugal
f_batista69@.hotmail.com
"Arnie Rowland" wrote:

> No where near enough information to help you. I suggest you find someone
> that knows the application to help you.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "francisco - Portugal" <f_batista69@.hotmail.com> wrote in message
> news:955AF918-D80E-4B0C-B626-09733B1BE251@.microsoft.com...
>
>
|||Its best to work with your developer and troubleshoot the lines of code that
calls for the data and then run the same query in your Query Analyser
window.
Alternatively you could run profiler to help troubleshoot the same. If you
think the table has all the data and the app does not return it, then it
could be capped by number of rows or possibly some rowcount option being
set,etc.
"francisco - Portugal" <f_batista69@.hotmail.com> wrote in message
news:EE601359-B05A-4995-9253-92290C82A3A7@.microsoft.com...[vbcol=seagreen]
> Thanks anyway for your time, i will try to reach a developer that was
> involved in the built of the application.
> Merry Christmas
> --
> Francisco Batista
> Portugal
> f_batista69@.hotmail.com
>
> "Arnie Rowland" wrote: