SSIS Upgrade error about file & project names

  • So, this is weird. Maybe I'm missing something.

    Upgrading SQL 2008 (some 2005) SSIS packages to SQL 2012 and occasionally getting this error:

    File and project names cannot contain any of the following characters:

    /\?:&*"<>|#%

    Seems clear enough to me. But when I look over the project and file names in my solution (even the solution name), I'm not seeing a single one of these characters. The only character I have is the underscore (_) and that's not in the above list.

    Should I be looking elsewhere besides Solution Explorer to find the offending file / project information or is the underscore what's kicking the error?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • A bit of a stab in the dark but have you tried deleting the .suo file? (Close the solution first) If it's a straight upgrade and nothing else has changed it stands to reason that it's a setting somewhere..

    Does it give you any indication of which files it thinks it causing problems?

  • tindog (5/11/2016)


    A bit of a stab in the dark but have you tried deleting the .suo file? (Close the solution first) If it's a straight upgrade and nothing else has changed it stands to reason that it's a setting somewhere..

    Does it give you any indication of which files it thinks it causing problems?

    I have not deleted the .suo file. I'll try that a little later.

    And unfortunately, no, it did not indicate which file or project is causing the problem. That's why I'm confused.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • I am experiencing this same issue. Have you been able to resolve it?

    Thanks!

    Mark Biagi

    Biagi Consulting

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

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