Having problems with variables

I have a Execute Process Task that pretty much executes a batch file that downloads a file that has a dynamic file name (with datetime stamp). Now I would like to load this file to a Flat File Source task in the Data Flow Task section automatically. So, creating a file manager or something on the fly. Is something like this possible with SSIS? Or am I simply hitting the wall here?

Thank you.

Why can you not just drop a data-flow into your package and make sure it executes after the Execute process task?

-Jamie

has anyone used Best Practices Analyzer Tool for Microsoft SQL Server 2000 1.0?

the download link is at
http://www.microsoft.com/downloads/d...=en&familyid=B
352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en
any feedback for the product would be appreciated. thank you.
Yes, I've used it. See my post called Other Best Practices.
Also, it would be nice if you could export a report to an html document. It
would also be nice if you could show all of the servers on the same report.
"===steve pdx===" <lins@.nospam_portptld.com> wrote in message
news:%23KhgERfiEHA.2624@.TK2MSFTNGP12.phx.gbl...
> the download link is at
>
http://www.microsoft.com/downloads/d...=en&familyid=B
> 352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en
> any feedback for the product would be appreciated. thank you.
>
|||Michelle
BPA ships a couple of SQL Reporting Services reports, which let you do what
you want (HTML, all servers at once, export to other formats, etc). Check
out the .rdl files under the \reports folder.
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"michelle" <michelle@.nospam.com> wrote in message
news:ObDnVrgiEHA.712@.TK2MSFTNGP09.phx.gbl...
> Yes, I've used it. See my post called Other Best Practices.
> Also, it would be nice if you could export a report to an html document.
It
> would also be nice if you could show all of the servers on the same
report.
>
> "===steve pdx===" <lins@.nospam_portptld.com> wrote in message
> news:%23KhgERfiEHA.2624@.TK2MSFTNGP12.phx.gbl...
>
http://www.microsoft.com/downloads/d...=en&familyid=B
>