Hi,

Sorry to say, I did not investigate further.

It was conveyed to the client it will be like this, and client was OK with that, so I left it there only.

I do...

Yes, SEQ_NBR is already a IDENTITY Column.

Actually I issue a delete command to delete all the records from the table.

I want to reset the seed value after deleting all...

Thanks Guys.

Actually at first place, I do not want to re-design the reports, thas why I have asked if there is any solution to this.

Secondly My client is happy with...

Hello,

I just have another table( you can say temp table).

I first populate that table.

Then by Execute SQl Task, have a script to update and insert the records in the...

Warning messages I am able to resolve.

It was just not to select columns which are not going to be used in the process ahead.

For errors, I suppose I was trying...

Hello,

For now I have a blank copy of the file with column names.

I just copy (overwrite) the blank file to the dataFile, then reload the file.

Thanks,

Sunil

Hello Scott,

I tried that also, still the problem is same.

Even in the Explorer I have "confirm open after download" check box unchecked. (Explorer --> Tools --> Folder Otpions --> File Types...