SSIS import/export does not work with spatial types RRS feed

  • Question

  • 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?
    Tuesday, May 5, 2009 2:11 PM

All replies

  • 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-
    Thursday, May 7, 2009 3:30 AM
  • 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?


    Friday, November 6, 2009 8:55 PM