Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Posts
    65

    Unanswered: Infamous product level insufficient error message

    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/SQLServ...dbackID=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!

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I don't recognise the error message but the error itself sounds very familiar. Is this a double hop problem?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jan 2004
    Posts
    65
    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

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Just looked on web. Looks different so I won't be much help. You seen this?
    http://forums.microsoft.com/MSDN/Sho...12469&SiteID=1
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Jan 2004
    Posts
    65
    Ahh, installing SP1 fixed it. Now I have a new problem but I'll research it a bit before posting

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •