SSIS Solution File Issue: Generate a new .database file and ask to overwrite?

  • Hello All,

    I have a trouble with my SSIS project solution file. I would appreciate it if someone could help me out.

    I'm doing things on our team foundation server. I mapped the latest project to my local path, but every time I clicked the project solution file, it gave me like:

    "[local mapping path]\ projectname11.database already exists. Are you sure you want to overwrite it?" YES/NO?

    I have the [projectname].database in my mapping folder, the projectname11.database will be generated automately when I hit the .sln file in VS.

    If I choose to overwrite it, it will show:

    " The item [local mapping path]\projectname11.database could not be found in your workspace" and " This file is under source code control. It must be checked out before it can be modified."

    If I choose not to overwrite it,

    " The '[local mapping path]\projectname11.database' file already exists"

    This is really irritating. Please let me know if you have any thoughts. Thank you in advance.

    Best,

    Jing

  • I think I know the reason that may cause this. In the local mapping folder, the .dtproj.user file is missing.....

    Is there any way I can bring it back?

    Thank you.

    Jing

  • try right clicking on the Project in VS and "Reload Project", select Yes to overwrite the database

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

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