none
ssis configuration table

    General discussion

  • hi i created config table with following script

    CREATE TABLE [dbo].[SSIS Configurations]
    (
    ConfigurationFilter NVARCHAR(255) NOT NULL,
    ConfiguredValue NVARCHAR(255) NULL,
    PackagePath NVARCHAR(255) NOT NULL,
    ConfiguredValueType NVARCHAR(20) NOT NULL
    )
    

     iam trying to drop ssis configuration table

    but it is giving error as

    Msg 102, Level 15, State 1, Line 1
    Incorrect syntax near 'Configurations'.

    why it is not dropping

    isit is not possible to drop config table

    before dropping some values are stored in table

    when i am tring to truncate also not possible


    • Edited by v60 Tuesday, February 07, 2012 5:52 AM
    Tuesday, February 07, 2012 5:48 AM

All replies

  • i guess u drop statemnet is incorrect

    use this drop table [ssis configurations]

    Regards,

    Eshwar

    Tuesday, February 07, 2012 6:23 AM
  • Hi Vijay,

    Truncate statement:

    Truncate Table <<tablename>>

    Drop Statement:

    DROP Table <<tablename>>


    Please vote as helpful or mark as answer, if it helps
    Cheers, Raunak | t: @raunakjhawar | My Blog

    Tuesday, February 07, 2012 7:44 AM
  • hi i created config table with following script

    CREATE TABLE [dbo].[SSIS Configurations]
    (
    ConfigurationFilter NVARCHAR(255) NOT NULL,
    ConfiguredValue NVARCHAR(255) NULL,
    PackagePath NVARCHAR(255) NOT NULL,
    ConfiguredValueType NVARCHAR(20) NOT NULL
    )
    

     iam trying to drop ssis configuration table

    but it is giving error as

    Msg 102, Level 15, State 1, Line 1
    Incorrect syntax near 'Configurations'.

    why it is not dropping

    isit is not possible to drop config table

    before dropping some values are stored in table

    when i am tring to truncate also not possible



    It would be helpful if you at least provide us with the statements that you used for the DROP and TRUNCATE TABLE, instead of the CREATE TABLE statement. But I guess User_SQLServer and Raunak are spot on.

    MCTS, MCITP - Please mark posts as answered where appropriate.
    Answer #1: Have you tried turning it off and on again?
    Answer #2: It depends...

    Tuesday, February 07, 2012 8:04 AM
  • Please consider the space in the table name.

    Sharepoint Admin

    Monday, April 09, 2012 8:50 PM