If I split my scripts into 30 different files(1 per file) and use foreach loop container, would it work? Would it work? Can the data flow task grab query from...

I have created a sample package for the first 5 scripts having 5 different sources,dataflow task and destination. I wanted to know if there is any other simple way of...

No all the scripts have different number of columns and different column names. I want one Excel file with 30 tabs.

The table structure is almost the same except for some fields. Actually the primary key is the run_identity. We are actually doing a migration from sql server to oracle database...

Hi, its a big table so the sript is very big indeed. this is the ddl fro staging table.

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[stg_na10ndel66]') and OBJECTPROPERTY(id,...