Thank you, I was struggling with a similar problem and just by selecting ignore from the Source column was able to import all my data. 🙂

WOW!!!

That works like a charm.

Thank you so much.

SELECT DATALENGTH('testfolder/test.aspx') returns one character more than the result dataset.

Which means it is returning the correct number of character.

Why am I not able to print it then?

ok, this works very well. 🙂

SELECT RIGHT(PageName, LEN(PageName) - CHARINDEX('/', PageName)) AS Expr1

BUT the page names returned has the first letter removed....

why is this??

i am...