fredmartinmaine
IS-IT--Management
I used the (2008 R2) Import Export Wizard to read a flat file into a Table. I saved that as a package. Now, I can open Integration Services and run the package and it pulls records into the table.
However, following that, I have to load an .sql file, containing some SQL statements to act on the new data, moving some or all of the data into a second table. Both of these steps are written and working.
I would like to create a single package that first runs the saved import package, and then runs my SQL statements. Is that even possible? I'm reading on the web about packages and it's a little overwhelming.
I am an MS SQL noob but I need to fast track this project. If it is possible, can someone give me some basic steps to get be going in the right direction?
However, following that, I have to load an .sql file, containing some SQL statements to act on the new data, moving some or all of the data into a second table. Both of these steps are written and working.
I would like to create a single package that first runs the saved import package, and then runs my SQL statements. Is that even possible? I'm reading on the web about packages and it's a little overwhelming.
I am an MS SQL noob but I need to fast track this project. If it is possible, can someone give me some basic steps to get be going in the right direction?