<div>
Thank you both, <br />
I'm not familar with either of the processes that you mentioned above. <br />
Sommervile, you say to create a batch file, where can i do this on the SSIS tool
</div>


Thank you both,
I'm not familar with either of the processes that you mentioned above.
Sommervile, you say to create a batch file, where can i do this on the SSIS tool

<div>
<div class="content wysiwyg-content">
Hi, <br />
I have a file i want to access, and take the latest csv file saved in that folder. <br />
<br />
I can FTP to this server<br />
and in this folder is a list of all the csv files that are saved daily. <br />
<br />
if there were only one new file saved there every day, and nothing else in the folder and the same name for this new file, then i can get my package to pick up this folder. <br />
<br />
But because every day there is a new file saved and its name will be different every day 'filename_date' , i do not know how to do this.<br />
<br />
Can anyone direct me in what to do. <br />
Is there something i can do with the settings on the FTP tool on SSIS. <br />
I'm using SQL SERVER 2005. <br />
<br />
thank you
</div>
</div>


Hi, 
I have a file i want to access, and take the latest csv file saved in that folder. 

I can FTP to this server
and in this folder is a list of all the csv files that are saved daily. 

if there were only one new file saved there every day, and nothing else in the folder and the same name for this new file, then i can get my package to pick up this folder. 

But because every day there is a new file saved and its name will be different every day 'filename_date' , i do not know how to do this.

Can anyone direct me in what to do. 
Is there something i can do with the settings on the FTP tool on SSIS. 
I'm using SQL SERVER 2005. 

thank you

using SSIS to FTP  to a server and pull csv onto another drive

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.