RadhaKrishnaKiJaya
asked on
DTS Package to SSIS Package
Hello Experts,
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Welcome..
ASKER