Unable to create SSIS package folder
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.
November 29th, 2010 4:50pm

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 ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
December 1st, 2010 2:52am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics