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...

Apart from a few commas here and there, your two rows of results look the same. Try to imagine yourself looking at your post for the first time – it's...

Try this and see what happens. Hopefully my edits make some sense:

public void Main()
{

String FilePath = Dts.Variables["User::FolderPath"].Value.ToString() + Dts.Variables["User::FileName"].Value.ToString();

Dts.Variables["User::FileExistsFlag"].Value = 0;
if...