Sign in
 
SQL Server Developer Center > SQL Server Forums > SQL Server Spatial > SSIS import/export does not work with spatial types
Ask a questionAsk a question
Search Forums:
 

QuestionSSIS import/export does not work with spatial types

  • Tuesday, May 05, 2009 2:11 PMwimpy1 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    I want to move a copy of a single table from on database on a SQL2008 server to another database on another SQL2008 server.  Using the built in import/export wizard in SQL Management Studio, it complains  "Found 1 unknown column type conversion(s)   You are only allowed to save the package".

    Has anyone found a workaround for this?
     

All Replies

  • Thursday, May 07, 2009 3:30 AMPure Krome Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Yes there is. You can use BCP to do this. Check out this post for information about doing it.

    It's slightly more work than using SSIS, but it does work! (i've used it plenty of times before).
    -Pure Krome-
     
  • Friday, November 06, 2009 8:55 PMJanetV Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    I would assume that we should be able to use the import Wizard to import tables with sql spatial columns.  Has anyone at Microsoft addressed this issue?

    Thanks