locked
Unable to create SSIS package folder RRS feed

  • Question

  • Hi,

    I am seeing intermittent issues while running this command on my SSIS server. Would you know when this error gets thrown?

    I am able to manually create this folder.

     

    dtutil /SourceS "server name" /FC "SQL;\;folder name"

     

    Error (0xC0014043) creating folder Iter39_Packages_Manual in folder \.

    Description: The CreateFolderOnSQLServer method has encountered OLE DB error cod

    e 0x80040E2F (The statement has been terminated.) The SQL statement issued has f

    ailed.

     

    Monday, November 29, 2010 9:47 PM

Answers

  • Hi deepak nair,

    Based on my testing, if we add a folder to SQL Server Integration Services(SSIS), and the folder has been exist in the same path, we will encounter the error:
    Error (0xC0014043) creating folder testfolder2 in folder \.
    Description: The CreateFolderOnSQLServer method has encountered OLE DB error code 0x80040E2F (The statement has been terminated.) The SQL statement issued has failed.

    In this case, please check if the folder name has been exist in the root path \.

    Additionally, the CreateFolderOnSQLServer calls the stored procedure [msdb].[dbo].[sp_ssis_addfolder] to add a record to table sysssispackagefolders. There is a UNIQUE NONCLUSTERINDEX on parentfolderid and foldername, this is why we cannot add same folder to same path.

    If you have any more questions, please feel free to ask.

    Thanks,
    Jin Chen


    Jin Chen - MSFT
    Wednesday, December 1, 2010 7:51 AM