July 10, 2003 at 8:26 pm
Hi All,
I have a problem with running DTS import on a new instance of SQL Server 2000 (SP3) on Windows Server 2003. The wizard can navigate to the csv source file but can't read it. The error when trying to proceed is "The file you have selected has a size of 0. Select another file with a valid size."
Has anybody run into this issue before?
Any advice greatly appreciated!
Thanks,
Megan
July 11, 2003 at 7:13 am
Megan,
The error message 'The file you have selected has a size of 0. Select
another file with a valid size' is caused by the control bytes of the record. Go to this dBforums archive for microsoft.public.data.odbc
URL http://dbforums.com/arch/212/2002/10/517677. It has more info for you on how to resolve the issue. It looks like it may be a little work.
All the best,
Dale
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
July 11, 2003 at 7:15 am
The DTS wizard needs data in the file to analyze it to attempt to find column(s). Edit the file to put at least one line with data matching the columns of the intended table.
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply