This thing is driving me crazy. I have a simple flat .txt file I'm trying to import into a DB, and this USED to work perfectly with SQL Server 2000. With 2005, I get "product level insufficient."
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=217596
I've read that and I've looked around. It seems like the solution is to actually connect to the Windows box that the server itself is running on (where SSIS is installed) and import there?? But that's a pain.. that means I'd have to Remote Desktop into the server EVERY time I want to import a text file. Surely there's some other way to do this??
Any advice would be great. Thanks!I don't recognise the error message but the error itself sounds very familiar. Is this a double hop problem?|||Not sure what double hop is.
In SQL Server Management Studio, I'm trying to import a flat .txt file into the DB. Here's a screenshot of the error message (I highlighted it):
http://img59.imageshack.us/img59/319/prodinsuffrw4.gif|||Just looked on web. Looks different so I won't be much help. You seen this?
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=112469&SiteID=1|||Ahh, installing SP1 fixed it. Now I have a new problem but I'll research it a bit before posting :)sql
Friday, March 23, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment