File Operations in Script Task

[ilin]

I have DTS Package,which I need to migrate to SSIS.
In my DTS I have 3 ActiveX scripts: one creates file with different name every day(Date Extension like FileName_YYYYMMDD). Then data transformation transform data from stored proc to this file. Second one creates another file (title) with different name every day(Date Extension like FileNameTitle_YYYYMMDD). Then data transformation transform data from another stored proc to this file.
3rd ActiveX script creates final file, merge these files in final and deletes the unused files. Then final file FTP to Mainframe.

What would be a best approach to do this task in SSIS and what script can I use (if somebody has an example).

Thanks for the help

 

[mrdenny]

Setup two connection objects. Use a .NET script to change the settings of the connection objects.

Use a .NET script to read the files and write the data to a new file.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[ilin]

Do you have or can advice examples?

Thanks

 

[mrdenny]

Sorry, I don't. Check google. I'm sure there are examples out there. I just haven't had to do it yet.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com