Hi. I hoping to get some help incorporating an SSIS package (either via SQL or file) into a job with multiple steps. The SSIS package would take place somewhere in the middle of the steps. I'm running SQL 2005 on a Windows 2003 Server OS. The SSIS package drops an existing table in the database, re-creates it and then populates the table with data from our mainframe. We previously ran this in a SQL Server 2000 environment with no problem and it ran nightly. The additional steps involve manipulation of another table in the database (called rico_owners) as well as the addition of new columns in the table (called btxmasw1) with manipulation of data to populate those columns. So everything has to happen in a certain order and each step has be be complete before the next step can take place. It was definitely simpler in SQL 2000. Thanks for your help!