It was a little late the other night, trying to stuff my latest Silverlight 2 Article into the database and DTS was giving me absolute fits...
I could see there were some extra characters ahead of the column name in the DTS record, but wasn't sure where they came from. I opened the file in SlickEdit, and it wouldn't let me view the file as hex ... hmmm...
<pause>Then followed a series of actions that had absolutely nothing to do with what was causing the problem</pause>
I finally looked in the lower right-hand corner of SlickEdit and realized the file was Unicode... well, how did that happen, and how do I get it back? To be honest, I'm sure there's a way in SlickEdit to do so, but I was past the point of being a careful searcher by now and just copy and pasted that sucker into notepad and wrote it back out as flat ASCII. I re-opened it in SlickEdit, deleted the extra characters at the front end, and DTS'd it up.
Whew!
For reference, I foisted the problem on myself by scavenging the html file out of the VS2008 build folder for my Silverlight project. I modified it to be my article, then cut the body of it out to DTS. The html file that VS2008 produced was Unicode and the beginning of my problems... so if that matters to the way you work, watch out for it!
I've now copied a piece of that file and have it listed as a template for deploying SL2 articles and the one I created is NOT unicode :)
Stay in the 'Light!
Twitter SLNews | Join me @ SilverlightCream | SL Web Articles | SL2 Web Articles | My Articles | My Tutorials | My Tooltips | My SL2 Articles | My SL2 ToolTips | SilverlightCream
posted @ Friday, May 30, 2008 11:41 AM