Post reply

Delete SSIS packages from SQL 2005 with spaces in name

  • September 17, 2010 at 1:36 pm

    #140669

    I have been unable to delete some 'test' ssis packages successfully in the past. However, my problem is that I have four ssis packages in SQL 2005 that I haven't been able to delete using dtutil because the ssis packages have spaces in their names (Ex: Import BTXMASr8 Table) and it doesn't recognize the name as legitimate.

    I need to figure out how to delete these. Does anyone know of a way to do that?

  • September 17, 2010 at 3:47 pm

    #1223364

    Put the package name in quotation marks.

    dtutil /SQL "Import BTXMASr8 Table" /DELETE

  • September 17, 2010 at 4:31 pm

    #1223374

    Good work Edogg - beat me to another one 😉

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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