We have two 2008 R2 SQL Servers - one running an expensive application to maintain our data and the second is web application SQL Server. The Web SQL pulls data from the Application SQL and then feeds it out to our customers and remote staff. I need a process to run during the week at 10 am - 1 pm - 4 pm. The queries simply pull the data from the Application and completely overwrites the Web data. I have written the queries and have done this process manually using the Import Wizard. What I don't know is how to select and implement the best process to automate this process. I have tried saving the Wizard files in SQL but I can't find the project files to use the SSIS package. Can you help jump start me on this project? Thanks - NC Beach Bum.Thanks - NC Beach Bum

Hi there. You've got the right idea. When you run the Import/Export Wizard, one of the last steps is a page with checkboxes. One of them is "run immediately", and one is "save SSIS package". You don't say what options you used when you "saved" the package... and what choices you make is entirely up to you - there are no "wrong" choices there. I'd suggest you save to the File System - the packages are easier to keep track of there. Set the package protection level to "Do Not Save Sensitive". When you hit next, you'll be asked where to save the package to. It doesn't matter where - you can copy this file around as much as you like - it's like an XLSX file is to Excel. Once you have the DTSX file, copy it to the server with SSIS on it - is that the AppSQL or WebSQL box? RDP to that server and use SSMS to create a new SQL Agent Job. Add a job step of Integration Services Package, and select from the file system. Find the package. Now set a schedule for the times you want the package to run. That should get you started - come back with other questions as you run into them. Talk to me now on