Yes, It will create infinite loop but it will end with maximum nesting level on 32

You should have two for each container one for text file and one for excel

or convert excel into text files

You have to call the Proc and functions in Datasets, and use the dataset in the report

You Can migrate the Existing DTS Package from 2005 Migration wizard it it will reduce your 80% design work and then you need to do some batch work to meet...

If you are truncating and loading the tables then how will you find the new emails?, you have to have a archive table there you can load distinct values then...

http://msdn.microsoft.com/en-us/library/ms141682.aspx

You Can use script component and variables to generate SNo.

Hi,

If you are selected SQl command then you have to write a query like,

"Select column1, column2 from sheet1$"

better you can simply "select table or view" option.

Govind

Hi,

Try the Multicast transformation, use of this you can insert to more than destinations from one source.

Govind

Hi

Check this for blank pages

1. Body width = Container width (like table tablix etc)

2. Interactive width = report body width + left and right margin...