Failed to start project ; Exception deserializing the package "values doesn't fall within the expected range"

Question

Post reply

Failed to start project ; Exception deserializing the package "values doesn't fall within the expected range"

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247183 More actions · Answer 1

Not sure about the error, but this task may work better using xp_Dirtree. Here is an example:

DROP TABLE IF EXISTS #Results

CREATE TABLE #Results ( Subdirectory VARCHAR(300) , depth INT , [File] BIT );

INSERT #Results ( Subdirectory , depth , [File] ) EXEC sys.xp_dirtree 'c:\temp', 0, 1;

SELECT * FROM #Results r WHERE [File] = 1

kishoremania Ten Centuries Points: 1059 More actions · Answer 2

Phil Parkin - Tuesday, December 5, 2017 12:49 PM
Not sure about the error, but this task may work better using xp_Dirtree. Here is an example:
DROP TABLE IF EXISTS #Results
CREATE TABLE #Results ( Subdirectory VARCHAR(300) , depth INT , [File] BIT );
INSERT #Results ( Subdirectory , depth , [File] ) EXEC sys.xp_dirtree 'c:\temp', 0, 1;
SELECT * FROM #Results r WHERE [File] = 1

Thanks!
This is great. It's (sys.xp_dirttree) working fine in my local, but not in shared location. Any idea?

kishoremania Ten Centuries Points: 1059 More actions · Answer 3

I think my project got corrupted, when I create in new project, not seeing this exception anymore.

Anywayz thanks for helping Phil.