For the purposes of getting your feet wet with SSIS, I would recommend that you try importing a CSV file rather than getting sidetracked with the intricacies of Excel drivers.

Unfortunately, I'm not a user of Report Builder, so I can't help you with that bit.

I would assume that it is because there is more than one match in tblDataActions for each Application number, and that is causing your result set after joining to contain...

Looks like it may be better to move that data to a staging table first (in its native format, as per the input file) and then use T-SQL to manipulate...

One final attempt and I'll stop: how about 8,877,691?

Is the total number of rows 8,877,690, by any chance?

Try this

SELECT * INTO [DBO].[T_NEWTABLE]
FROM [WorkLSC].[dbo].[vw_OLDTABLE)

Is there an ORDER BY along with the TOP 1000?

I think we need a few more parameters ...

As the set of integers is unbounded, the answer is an infinite number.

But, if you are saying, how...