I was checking Endofrowsets() in the script which is not required and thats the cause for the error. Its now fixed after removing that condition.

yes i too thought of using it. But what if we need to copy same files to several folders say for eg, 10 different folders. Do we need to create...

Hi All, I too face a similar problem. I need to copy one excel file from a folder and paste it in two different folders. How this can be achieved?

To add with Rav's query, i too faced this same error. In my case i use text files as my source initially it was working fine. But now it throws...

BINARY_CHECKSUM(*) is used with the tables in the SQL Server, but i want to know the changes between the new flat file of that particular table and the records which...

I have given in my post that i am downloading the flat files from mainframe, this downloading is done every month so the newly downloaded files may have been updated....

Hi thanks for your response. I first used SSIS package to export the flat file data in to the table and i have successfully implemented. But now i have some...