I am trying to rewrite an existing DTS package to SSIS package. The very first step is (ActiveX Script Task Properties), where I have vb scripts, which picks up a text file and writes the data in a SQL table.
1. I am using VS 2008 to create the SSIS package. The question is, what is the option in Toolbox, I need to select to do the job? I need to select in SSIS tools
2. Also, I have many steps, where I used Execute SQL Task Properties for coding the SQL Statements. In SSIS, what is the option I need to select.
Please try to help. Thank you very much in advance.