Hi Jeff,

Well actually I needed to construct a file, which has certain keys with specific headers and footers. Consider the example below:

{X987gt}

[Financial data]

Extraction 1

Time: 1130

1234R

4567R

3765R

Extraction 2

Time: 1130

3786R

9856R

2345R

Extraction 3

Time: 1130

1234R

4673R

7129R

...

I am...

Thanks to everyone for their inputs. I came to know that Varchar(8000) is the max I could pass from an SP to SSIS, also that's the max Xp_CmdShell could work...

If you are giving wrong indexes for a parameter in the SQL Task, sit throws this error.

- Sayan

Yes it is like that. Actually in our DB we have two primary users - the SA user and the NORMAL ones.

Now a group amongst the NORMAL ones are going...

Yeah you got it right, BUT the multiple results will come from different tables. It is something like I have a table (say table_1) that loads all the parent tables of...