SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On



could not delete file after renamed using filesystem. Expand / Collapse
Author
Message
Posted Friday, November 20, 2009 4:45 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, March 08, 2010 9:08 AM
Points: 90, Visits: 801
Hi All,
What i was trying to do is loading file from txt file to database using ssis once i load done i need to delete and rename another file to txt file and load that again it is working from the folder i had setup for looping within folder using for each containeer. every thing works renaming and deleting but after renaming another loop stopped. reason i found when it renamed that txt file in that folder it is only read only. could not figuer out to change that setting or any logic. i am stuck... any help would be great for me.

Thanks
Sagar
Post #822789
« Prev Topic | Next Topic »


Permissions Expand / Collapse