Post reply

Running SSIS from SQL Agent job getting error "Format of the initialization string does not conform to the OLE DB specification"

  • May 11, 2018 at 12:34 pm

    #330811

    I am getting the following error when running an SSIS package from the SQL Agent job.

    "Format of the initialization string does not conform to the OLE DB specification"
    This package is writing a file to a directory with a space in the folder name. In BIDs, it runs fine. I have protection level as DontSaveSensitive on the package and project. I tested running in BIDs and SQL Agent job using a directory with no spaces and it works fine. Only when the directory has a space that it errors out in the SQL Agent job. Is there a way to overcome this without having to use a directory with no spaces?

  • May 11, 2018 at 1:25 pm

    #1990242

    sadie - Friday, May 11, 2018 12:34 PM

    I am getting the following error when running an SSIS package from the SQL Agent job.

    "Format of the initialization string does not conform to the OLE DB specification"
    This package is writing a file to a directory with a space in the folder name. In BIDs, it runs fine. I have protection level as DontSaveSensitive on the package and project. I tested running in BIDs and SQL Agent job using a directory with no spaces and it works fine. Only when the directory has a space that it errors out in the SQL Agent job. Is there a way to overcome this without having to use a directory with no spaces?

    In addition, the SSIS package/project is deployed in the SSISDB catalog.

  • May 12, 2018 at 1:38 am

    #1990265

    Have you tried to enclose the path in double quotes?
    😎

  • July 28, 2020 at 1:07 pm

    #3775392

    I am facing the same issue running SSIS package from sql agent job. The job is scheduled in our production environment. We are facing this issue intermittently and it is getting resolved by itself and we have a successfull run for the same job after the failure.. but there seems to be lot of failed jobs. Could any one suggest a solution that worked please?

    Format of the initialization string does not conform to the OLE DB specification

  • January 6, 2022 at 7:09 pm

    #3970664

    Having a similar issue to priya06 and I have exhausted a lot of my research and troubleshooting.  priya06 were you able to find any resolution to this?

     

Viewing 5 posts - 1 through 4 (of 4 total)

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