Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can Package accomplish what I want to do?

Status
Not open for further replies.

fredmartinmaine

IS-IT--Management
Mar 23, 2015
79
US
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top