Friday, March 23, 2012

FileSystemTask->Size limitation?

I am using FileSystemTask to copy around 4 gb file(ASCII). Is there any limitation on the file size.

SQL Server 2005 SP2, Windows 2003 server. Copying from one Windows 2K server to other Windows 2K server.

Thank you,

As far as I know, there is no limitation. Are you getting any error?

|||We are copying files much larger than this. What error are you getting? could it be that you have run out of space on the destination?|||

Currently I am not getting any error messages.

Same file copy operation is not working fine right now in DTS package. So we decided to move this part of the flow to SSIS.

I was making sure any known size limitation if at all in SSIS.

Thank you all for your answers.

No comments:

Post a Comment