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!
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.