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