Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
ssis configuration table

Discussion ssis configuration table

  • Tuesday, February 07, 2012 5:48 AM
     
      Has Code
    Sign In to Vote
    0

    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
    •  
     

All Replies

  • Tuesday, February 07, 2012 6:23 AM
     
     
    Sign In to Vote
    1

    i guess u drop statemnet is incorrect

    use this drop table [ssis configurations]

    Regards,

    Eshwar

     
  • Tuesday, February 07, 2012 7:44 AM
     
      Has Code
    Sign In to Vote
    0

    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 8:04 AM
     
      Has Code
    Sign In to Vote
    0

    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...

     
  • Monday, April 09, 2012 8:50 PM
     
     
    Sign In to Vote
    0
    Please consider the space in the table name.

    Sharepoint Admin