DTS Package to SSIS Package

RadhaKrishnaKiJaya
RadhaKrishnaKiJaya used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
>> I have vb scripts, which picks up a text file and writes the data in a SQL table.  

Instead of ActiveX script, I would recommend to use the Flat File Source and read data from Text file and write it to SQL Server Detination.

>> 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

Use Business Intelligence Development Studio(BIDS) client to create a new Integration Services Project and then start coding your package.

>> 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.

You can use Execute SQL Task in BIDS client or your Integration Services project as well.
Kindly let us know for more details and hope this basic tutorial helps for you to get started..
https://www.codeproject.com/Articles/173918/How-to-Create-your-First-SQL-Server-Integration-Se

Author

Commented:
Thank you Raja for you help.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Welcome..

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial