none
Write and delete CSV files in SQL database RRS feed

  • Question

  • Hi !

    I have a question about creating a job in SQL 2012 and I would like some help.

    So I have a local folder on a PC which contains CSV files that are generated by another system via VBS script with unique names as follows ("id_yyyymmdd_hhmmss"):

    "id_20190913_090000",

    "id_20190913_094512",

    "id_20190913_103205", ...

    I need to create a scheduled SQL Server Agent job (e.g. every minute) that runs a package with a dataflow as follows: if there are CSV files in this local folder when the event occurs that is written to SQL database of each files in the correct order (oldest to newest file) and only after writing the data contained in the CSV file the CSV file be deleted from the local PC folder.

    The intention is to create a kind of buffer (local folder) between the system that generates the CSV files via script and the SQL database so that, in case of communication loss or slowness, it does not affect writing to the SQL database. Currently the system writes directly to the SQL database via script (without generating CSV files), however it is generating slowness since each write has to open the connection to the database and then close, stopping the execution of the script.


    What I would like to ask help is how to save multiple CSV files in the SQL and after the confirmation of writing delete the recorded file.

    I appreciate any help!

    Cheers,
    Berg

    Friday, September 13, 2019 1:16 PM

Answers

  • Hi everyone !

    I finally found the problem today. Following the solution:


    In SQL Server Job > Properties > Steps > In the Execution Option Tab >

    I've checked "use 32 bit runtime"  and in the "data sources tab" unchecked the checkboxes of the connection managers.

    Cheers,

    Berg

    • Marked as answer by Augusto B Tuesday, October 8, 2019 5:24 PM
    • Unmarked as answer by Augusto B Tuesday, October 8, 2019 5:24 PM
    • Marked as answer by Augusto B Thursday, October 10, 2019 11:21 AM
    Tuesday, October 8, 2019 2:32 PM

All replies

  • Hi Berg,

    SSIS has the following tasks for your needs:

    • Foreach Loop Container, to traverse directory for files.
    • Flat File Source Adapter, to read *.csv files.
    • OLEDB Destination to insert data into a database.
    • File System Task, to delete loaded *.csv files.

    Friday, September 13, 2019 2:08 PM
  • Hi

    As suggested by Yitzhak, SSIS suits to fulfill your need. Below reference link helps to implement a SSIS Solution dealing with CSV files.

    https://www.mssqltips.com/sqlservertip/2923/configure-the-flat-file-source-in-sql-server-integration-services-2012-to-read-csv-files/

    Hope this is helpful!

    Thank you


    If this post helps to resolve your issue, please click the "Mark as Answer" of that post and/or click Answered "Vote as helpful" button of that post. By marking a post as Answered and/or Helpful, you help others find the answer faster.

    Friday, September 13, 2019 2:14 PM
  • Hi Augusto B,

    The following links will be helpful for you.

    SSIS ForEach Loop File Enumerator

    File System Task in SSIS

    Best Regards,

    Mona 


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, September 16, 2019 2:13 AM
  • Hi

    Just checking in to see if my initial answer helped or you still facing any issues.

     

    If my initial reply answers your query, do click “Mark as Answer” and Up-Vote for the same which might be beneficial to other community members reading this thread .

    And, if you have any further query do let us know.

    Thank you


    If this post helps to resolve your issue, please click the "Mark as Answer" of that post and/or click Answered "Vote as helpful" button of that post. By marking a post as Answered and/or Helpful, you help others find the answer faster.

    Wednesday, September 18, 2019 3:05 AM
  • Hi !

    First of all I would like to thank you all for the helpful answers.

    But I still have a question:

    I created in Visual Studio a "Contro Flow" to copy multiple CSV files to SQL and after the copy then delete all CSV files of the local folder. When the package is executed in Visual Studio through "Start Debugging" button it works perfectly, but when the package is executed through a scheduled job in "SQL Server Agent" the data from the CSV files are copied aright to SQL database but the CSV files are not deleted from the local folder.

    Can anyone help and tell me why?

    Cheers,

    Berg


    • Edited by Augusto B Thursday, September 19, 2019 12:15 PM picture attached
    Thursday, September 19, 2019 12:14 PM
  • Hi Augusto B,

    Please check if the user execute the package in SQL Server Agent has permission to delete the folder.

    Best Regards,

    Mona


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, September 20, 2019 10:31 AM
  • Hi @Mona Lv !

    Could you tell me where I check this ?
    The user that execute the job has all "server roles" checked in "Security" folder.

    Thank you for your attention !

    Cheers,

    Berg

    Friday, September 20, 2019 2:43 PM
  • Hi Augusto B,

    If you are not getting any run-time errors from the "Delete CSV File" step, it means the issue is not related to the permissions.

    I am leaning towards the issue with the "Delete CSV File" step settings pointing to a different directory and/or not matching file name pattern.

    Please share a screen shot of its configuration.

    Friday, September 20, 2019 3:27 PM
  • Hi Yitzhak Khabinsky !

    So, when the package is started directly in Visual Studio (not through a scheduled job in SQL Server Agent) the CSV files are copied and deleted correctly, as following:

    But with scheduled job in SQL Server Agent the files are copied but not deleted. Below the "Delete CSV File" configuration requested and the "Server roles" in SQL Server Security:

    Cheers,

    Berg

    Friday, September 20, 2019 4:28 PM
  • Hi Augusto B,

    Thanks for sharing the screen shots.

    I see that you are using the "Delete directory content" operation and Source Connection CSV Files.

    Two points of interest:

    • Are you using any expression on that connection for your run-time environment on the server?
    • How is it configured in the Connection Managers tab in the SSISDB Catalog?

    Friday, September 20, 2019 5:58 PM
  • Hi Yitzhak Khabinsky !

    Sorry for the delay in reply but I was out.

    So, I couldn't find the Integration Services Catalog folder in my project:

    Following the data sources connection string:

    Cheers,

    Berg

    Tuesday, September 24, 2019 4:24 PM
  • Hi Berg,

    I see that you are on SQL Serve 2008R2 SP1 (build 10.50.2500.0). That's why it doesn't have the Integration Services Catalog.

    Let's concentrate on the 'CSV Files' connection pointing to the 'C:\Users\Administrator\Desktop\CSV Files'

    A couple of questions:

    1. Is it a correct path in the run-time environment on the server?
      It seems like a client machine path.
    2. What about a space between '~\CSV Files'?
      Please try to enclose that entire path inside quotation marks.



    Tuesday, September 24, 2019 4:52 PM
  • Hi again Yitzhak Khabinsky !

    About your questions:

    1. Yes the path is correct and the folder is in Server Desktop, as following:

    2. I've tried the path between ' ' too but no success.

    Regards,

    Berg

    Tuesday, September 24, 2019 5:35 PM
  • Hi Berg,

    Thanks for the update.

    Let's try an alternative approach. Please change the 'CSV Files' connection to a non-existing path and re-run the package. Let's see if you'll get any error.

    Tuesday, September 24, 2019 5:45 PM
  • Hi Yitzhak Khabinsky,

    I've changed to a non-existing path and the CSV files were copied normally to SQL database but the CSV files were not deleted either.

    Below log error:

    Regards,

    Berg


    • Edited by Augusto B Tuesday, September 24, 2019 8:48 PM
    Tuesday, September 24, 2019 8:17 PM
  • Hi Berg,

    I don't see any error pertaining to the files deletion in the SQL Server Agent log.

    I guess, you need to check the SSIS package logs for further details.



    Tuesday, September 24, 2019 8:28 PM
  • Hi Yitzhak Khabinsky !

    The strange thing is that running the package directly in Visual Studio works correctly and does not generate error logging, only when the package is executed through the SQL Server Agent Job that CSV files are only copied but not deleted.

    Unfortunately I can not understand where the error may be ...

    Cheers,

    Berg

    Tuesday, September 24, 2019 8:54 PM
  • Hi Berg,

    As I already said, you need to turn on SSIS logging for all events. SQL Server Agent log is not enough.

    The SSIS log will expose what is I going on.

    Useful links:


    Tuesday, September 24, 2019 9:32 PM
  • Hi Yitzhak Khabinsky !

    Sorry the delay in feedback but following is the log table generated of  executing the package in SSIS:

    SSIS log file


    As I said if running the package directly in SSMS the CSV files are deleted correctly, this only does not occur when the package is executed through the job in SQL Server Agent.

    Can you check the log file and give an opinion, please ?


    Cheers,

    Berg


    • Edited by Augusto B Thursday, September 26, 2019 4:58 PM log file attached
    Thursday, September 26, 2019 4:54 PM
  • Hi Berg,

    Your log is very skimpy.

    You need to turn on all the events for the log to capture all of them.


    Thursday, September 26, 2019 4:59 PM
  • Hi !

    Ok, you're right ! Following the link with all log events checked:

    SSIS logs

    Regards,

    Berg

    Thursday, September 26, 2019 5:22 PM
  • Hi Berg,

    Here is what I see in the log provided towards the end. It says that there are two files there. And they are successfully deleted.

    340;Diagnostic;SRVDB01;SRVDB01\Administrator;Delete CSV File;;;Executing File System Operation: "DeleteDirectoryContent" "CSV Files" ""							
    341;Diagnostic;SRVDB01;SRVDB01\Administrator;Delete CSV File;;;Deleting all files and directories under 'C:\Users\Administrator\Desktop\CSV Files'.							
    342;Diagnostic;SRVDB01;SRVDB01\Administrator;Delete CSV File;;;Deleting file at 'C:\Users\Administrator\Desktop\CSV Files\test_01.csv'.							
    343;Diagnostic;SRVDB01;SRVDB01\Administrator;Delete CSV File;;;Deleting file at 'C:\Users\Administrator\Desktop\CSV Files\test_02.csv'.							
    344;Diagnostic;SRVDB01;SRVDB01\Administrator;Delete CSV File;;;Finished deleting all files and directories under 'C:\Users\Administrator\Desktop\CSV Files'.							


    Thursday, September 26, 2019 6:15 PM
  • Hi Yitzhak Khabinsky !

    Yes it is working well in SSMS. The CSV files are deleted correctly only when the package is executed directly in SSMS, but it does not happen when the package is executed in SQL Server Agent. That is the issue ...

    Cheers,

    Berg 

    Thursday, September 26, 2019 6:25 PM
  • Hi Berg,

    • The log you provided, is it from the server run by the SQL Server Agent?
    • To troubleshoot, you can try to run Microsoft Process Monitor on the server:
      Process Monitor v3.52


    Thursday, September 26, 2019 6:38 PM
  • Hi Yitzhak Khabinsky !

    The log provided it's from the server run by SSMS (Start Debugging button). When it's run by the SQL Server Agent any log is generated.

    To a test I run the job manually in SQL Server Agent (Start Job at Step ...) and the following error is generated:


    Cheers,

    Berg

    Thursday, September 26, 2019 7:31 PM
  • Hi Berg,

    I don't understand your screen shot and how the "The Messenger service has not been started..." error message is related to the SSIS package execution.

    Here is what you need to do:

    • Expand SQL Server Agent in the Object Explorer, and then expand Jobs.

    • Right-click a particular job, and then click View History.

    To troubleshoot, you can try to run Microsoft Process Monitor on the server:
    Process Monitor v3.52


    Thursday, September 26, 2019 7:50 PM
  • Hi Yitzhak Khabinsky !

    I also enable the log in SQL Server Agent and ran the Job manually. Following the log generated:


    id;event;computer;operator;source;sourceid;executionid;starttime;endtime;datacode;databytes;message
    1;OnPreValidate;SRVDB01;SRVDB01\Administrator;Package;27FDA9CB-CA73-49BE-8E32-6B02660B170B;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;
    2;Diagnostic;SRVDB01;SRVDB01\Administrator;SRVDB01\WINCC.Dados_Producao_MP6;441EE37A-E36F-47D4-9242-67006BA0E895;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;"ExternalRequest_pre: The object is ready to make the following external request: 'IDataInitialize::GetDataSource(NULL, CLSCTX_INPROC_SERVER, ConnectionString: Data Source=SRVDB01\WINCC;Initial Catalog=Dados_Producao_MP6;Provider=SQLNCLI10.1;Integrated Security=SSPI;,...)'."
    3;Diagnostic;SRVDB01;SRVDB01\Administrator;SRVDB01\WINCC.Dados_Producao_MP6;441EE37A-E36F-47D4-9242-67006BA0E895;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IDataInitialize::GetDataSource succeeded'. The external request has completed.
    4;Diagnostic;SRVDB01;SRVDB01\Administrator;SRVDB01\WINCC.Dados_Producao_MP6;441EE37A-E36F-47D4-9242-67006BA0E895;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IDBInitialize::Initialize'.
    5;Diagnostic;SRVDB01;SRVDB01\Administrator;SRVDB01\WINCC.Dados_Producao_MP6;441EE37A-E36F-47D4-9242-67006BA0E895;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IDBInitialize::Initialize succeeded'. The external request has completed.
    6;Diagnostic;SRVDB01;SRVDB01\Administrator;SRVDB01\WINCC.Dados_Producao_MP6;441EE37A-E36F-47D4-9242-67006BA0E895;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IDBCreateSession::CreateSession'.
    7;Diagnostic;SRVDB01;SRVDB01\Administrator;SRVDB01\WINCC.Dados_Producao_MP6;441EE37A-E36F-47D4-9242-67006BA0E895;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IDBCreateSession::CreateSession succeeded'. The external request has completed.
    8;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetColumnsRowset(NULL, 1, DBCOLUMN_COLLATINGSEQUENCE, IID_IRowset, 0, NULL,...)'.
    9;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IRowset::GetColumnsRowset succeeded'. The external request has completed.
    10;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IAccessor::CreateAccessor(DBACCESSOR_ROWDATA,...)'.
    11;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;External request parameter for IAccessor::CreateAccessor.
    Parameter DBBINDING[1]:
        Ordinal: 5
        Value offset: 0
        Length offset: 0
        Status offset: 0
        Part: 1
        MemOwner: 0
        MaxLen: 0
        Flags: 0
        Type: 19
        Precision: 0
        Scale: 0
    
    12;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;External request parameter for IAccessor::CreateAccessor.
    Parameter DBBINDING[2]:
        Ordinal: 12
        Value offset: 4
        Length offset: 0
        Status offset: 0
        Part: 1
        MemOwner: 0
        MaxLen: 0
        Flags: 0
        Type: 3
        Precision: 0
        Scale: 0
    
    13;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IAccessor::CreateAccessor succeeded'. The external request has completed.
    14;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'.
    15;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed.
    16;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'.
    17;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed.
    18;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'.
    19;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IRowset::ReleaseRows finished'. The external request has completed.
    20;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'.
    21;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed.
    22;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'.
    23;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed.
    24;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'.
    25;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IRowset::ReleaseRows finished'. The external request has completed.
    26;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'.
    27;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed.
    28;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'.
    29;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed.
    30;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'.
    31;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IRowset::ReleaseRows finished'. The external request has completed.
    32;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'.
    33;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed.
    34;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'.
    35;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed.
    36;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'.
    37;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IRowset::ReleaseRows finished'. The external request has completed.
    38;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'.
    39;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed.
    40;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetData'.
    41;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IRowset::GetData succeeded'. The external request has completed.
    42;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'.
    43;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IRowset::ReleaseRows finished'. The external request has completed.
    44;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::GetNextRows'.
    45;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IRowset::GetNextRows succeeded'. The external request has completed.
    46;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IRowset::ReleaseRows'.
    47;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IRowset::ReleaseRows finished'. The external request has completed.
    48;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'IAccessor::ReleaseAccessor'.
    49;Diagnostic;SRVDB01;SRVDB01\Administrator;"OLE DB Destination" (213);000000D5-0000-0000-0000-000000000000;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'IAccessor::ReleaseAccessor finished'. The external request has completed.
    50;Diagnostic;SRVDB01;SRVDB01\Administrator;SRVDB01\WINCC.Dados_Producao_MP6;441EE37A-E36F-47D4-9242-67006BA0E895;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_pre: The object is ready to make the following external request: 'ITransactionJoin::JoinTransaction'.
    51;Diagnostic;SRVDB01;SRVDB01\Administrator;SRVDB01\WINCC.Dados_Producao_MP6;441EE37A-E36F-47D4-9242-67006BA0E895;F5052813-74E8-415E-8315-E88A9842C098;2019-09-26 16:18:27.000;2019-09-26 16:18:27.000;0;0x;ExternalRequest_post: 'ITransactionJoin::JoinTransaction succeeded'. The external request has completed.



    • Edited by Augusto B Thursday, September 26, 2019 7:54 PM
    Thursday, September 26, 2019 7:51 PM
  • Hi Berg,

    To troubleshoot, you can try to run Microsoft's Process Monitor on the server:

    Process Monitor v3.52

    You can find me on LinkedIn and Skype.

    Thursday, September 26, 2019 8:03 PM
  • Hi Yitzhak Khabinsky !

    Following the job history log requested previous:

    

    Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
    09/26/2019 16:39:58,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by User SRVDB01\Administrator.  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/26/2019 16:39:58,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  16:39:58  Error: 2019-09-26 16:39:58.98     Code: 0xC000F427     Source: Package      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  Error: 2019-09-26 16:39:58.98     Code: 0xC000F427     Source: Package      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  Error: 2019-09-26 16:39:59.01     Code: 0xC000F427     Source: Package      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  Error: 2019-09-26 16:39:59.01     Code: 0xC000F427     Source: Package      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  Error: 2019-09-26 16:39:59.07     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  16:39:58  Finished: 16:39:59  Elapsed:  0.515 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/26/2019 16:32:58,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by User SRVDB01\Administrator.  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:02,0,0,,,,0
    09/26/2019 16:32:58,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  16:32:58  Error: 2019-09-26 16:32:59.74     Code: 0xC000F427     Source: Package      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  Error: 2019-09-26 16:32:59.82     Code: 0xC000F427     Source: Package      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  Error: 2019-09-26 16:33:00.04     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  16:32:58  Finished: 16:33:00  Elapsed:  1.295 seconds.  The package execution failed.  The step failed.,00:00:02,0,0,,,,0
    09/26/2019 16:19:46,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by User SRVDB01\Administrator.  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/26/2019 16:19:46,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  16:19:46  Error: 2019-09-26 16:19:46.62     Code: 0xC000F427     Source: Package      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  Error: 2019-09-26 16:19:46.65     Code: 0xC000F427     Source: Package      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  Error: 2019-09-26 16:19:46.71     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  16:19:46  Finished: 16:19:46  Elapsed:  0.484 seconds.  The package execution failed.  The step failed.,00:00:00,0,0,,,,0
    09/26/2019 16:10:45,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by User SRVDB01\Administrator.  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/26/2019 16:10:45,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  16:10:45  Error: 2019-09-26 16:10:45.43     Code: 0xC000F427     Source: Package      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  Error: 2019-09-26 16:10:45.46     Code: 0xC000F427     Source: Package      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  Error: 2019-09-26 16:10:45.52     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  16:10:45  Finished: 16:10:45  Elapsed:  0.468 seconds.  The package execution failed.  The step failed.,00:00:00,0,0,,,,0
    09/26/2019 13:16:56,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by User SRVDB01\Administrator.  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/26/2019 13:16:56,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  13:16:56  Error: 2019-09-26 13:16:57.32     Code: 0xC000F427     Source: Package      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  Error: 2019-09-26 13:16:57.36     Code: 0xC000F427     Source: Package      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  Error: 2019-09-26 13:16:57.39     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  13:16:56  Finished: 13:16:57  Elapsed:  0.546 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 17:17:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 17:17:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  17:17:00  Error: 2019-09-24 17:17:01.05     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  17:17:00  Finished: 17:17:01  Elapsed:  0.405 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 17:16:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 17:16:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  17:16:00  Error: 2019-09-24 17:16:01.26     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  17:16:00  Finished: 17:16:01  Elapsed:  0.422 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 17:15:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 17:15:01,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  17:15:01  Error: 2019-09-24 17:15:01.43     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  17:15:01  Finished: 17:15:01  Elapsed:  0.39 seconds.  The package execution failed.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 17:14:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 17:14:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  17:14:00  Error: 2019-09-24 17:14:00.59     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  17:14:00  Finished: 17:14:00  Elapsed:  0.406 seconds.  The package execution failed.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 17:13:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 17:13:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  17:13:00  Error: 2019-09-24 17:13:00.77     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  17:13:00  Finished: 17:13:00  Elapsed:  0.39 seconds.  The package execution failed.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 17:12:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 17:12:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  17:12:00  Error: 2019-09-24 17:12:00.93     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  17:12:00  Finished: 17:12:00  Elapsed:  0.39 seconds.  The package execution failed.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 17:11:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 17:11:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  17:11:00  Error: 2019-09-24 17:11:01.11     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  17:11:00  Finished: 17:11:01  Elapsed:  0.421 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 17:10:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 17:10:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  17:10:00  Error: 2019-09-24 17:10:01.29     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  17:10:00  Finished: 17:10:01  Elapsed:  0.39 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 17:09:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 17:09:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  17:09:00  Error: 2019-09-24 17:09:00.45     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  17:09:00  Finished: 17:09:00  Elapsed:  0.421 seconds.  The package execution failed.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 17:08:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 17:08:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  17:08:00  Error: 2019-09-24 17:08:00.62     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  17:08:00  Finished: 17:08:00  Elapsed:  0.422 seconds.  The package execution failed.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 17:07:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 17:07:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  17:07:00  Error: 2019-09-24 17:07:00.78     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  17:07:00  Finished: 17:07:00  Elapsed:  0.406 seconds.  The package execution failed.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 17:06:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 17:06:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  17:06:00  Error: 2019-09-24 17:06:00.96     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  17:06:00  Finished: 17:06:00  Elapsed:  0.405 seconds.  The package execution failed.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 17:05:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 17:05:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  17:05:00  Error: 2019-09-24 17:05:01.13     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  17:05:00  Finished: 17:05:01  Elapsed:  0.406 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 17:04:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 17:04:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  17:04:00  Error: 2019-09-24 17:04:01.32     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  17:04:00  Finished: 17:04:01  Elapsed:  0.39 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 17:03:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 17:03:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  17:03:00  Error: 2019-09-24 17:03:00.46     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  17:03:00  Finished: 17:03:00  Elapsed:  0.406 seconds.  The package execution failed.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 17:02:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 17:02:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  17:02:00  Error: 2019-09-24 17:02:00.65     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  17:02:00  Finished: 17:02:00  Elapsed:  0.406 seconds.  The package execution failed.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 17:01:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 17:01:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  17:01:00  Error: 2019-09-24 17:01:00.83     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  17:01:00  Finished: 17:01:00  Elapsed:  0.406 seconds.  The package execution failed.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 17:00:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 17:00:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  17:00:00  Error: 2019-09-24 17:00:00.99     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  17:00:00  Finished: 17:00:00  Elapsed:  0.406 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 16:59:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 16:59:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  16:59:00  Error: 2019-09-24 16:59:01.17     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  16:59:00  Finished: 16:59:01  Elapsed:  0.405 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 16:58:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 16:58:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  16:58:00  Error: 2019-09-24 16:58:01.35     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  16:58:00  Finished: 16:58:01  Elapsed:  0.421 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 16:57:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 16:57:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  16:57:00  Error: 2019-09-24 16:57:00.51     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  16:57:00  Finished: 16:57:00  Elapsed:  0.421 seconds.  The package execution failed.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 16:56:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 16:56:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  16:56:01  Error: 2019-09-24 16:56:01.38     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  16:56:01  Finished: 16:56:01  Elapsed:  0.39 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 16:55:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 16:55:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  16:55:00  Error: 2019-09-24 16:55:01.11     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  16:55:00  Finished: 16:55:01  Elapsed:  0.406 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 16:54:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 16:54:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  16:54:00  Error: 2019-09-24 16:54:01.10     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  16:54:00  Finished: 16:54:01  Elapsed:  0.39 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 16:53:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 16:53:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  16:53:00  Error: 2019-09-24 16:53:01.09     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  16:53:00  Finished: 16:53:01  Elapsed:  0.375 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 16:52:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 16:52:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  16:52:00  Error: 2019-09-24 16:52:01.09     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  16:52:00  Finished: 16:52:01  Elapsed:  0.375 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 14:35:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 14:35:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  14:35:00  Error: 2019-09-24 14:35:00.95     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  14:35:00  Finished: 14:35:00  Elapsed:  0.405 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 14:34:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 14:34:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  14:34:00  Error: 2019-09-24 14:34:01.14     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  14:34:00  Finished: 14:34:01  Elapsed:  0.406 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 14:33:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 14:33:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  14:33:00  Error: 2019-09-24 14:33:01.31     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  14:33:00  Finished: 14:33:01  Elapsed:  0.39 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 14:32:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 14:32:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Argument "CSV" for option "connection" is not valid.  The command line parameters are invalid.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 14:31:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 14:31:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Argument "CSV" for option "connection" is not valid.  The command line parameters are invalid.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 14:30:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 14:30:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Argument "CSV" for option "connection" is not valid.  The command line parameters are invalid.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 14:29:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 14:29:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Argument "CSV" for option "connection" is not valid.  The command line parameters are invalid.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 14:28:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 14:28:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Argument "CSV" for option "connection" is not valid.  The command line parameters are invalid.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 14:27:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 14:27:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Argument "CSV" for option "connection" is not valid.  The command line parameters are invalid.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 14:26:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 14:26:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  14:26:00  Error: 2019-09-24 14:26:00.62     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  14:26:00  Finished: 14:26:00  Elapsed:  0.406 seconds.  The package execution failed.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 14:25:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 14:25:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  14:25:00  Error: 2019-09-24 14:25:00.61     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  14:25:00  Finished: 14:25:00  Elapsed:  0.39 seconds.  The package execution failed.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 14:24:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 14:24:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  14:24:00  Error: 2019-09-24 14:24:00.61     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  14:24:00  Finished: 14:24:00  Elapsed:  0.406 seconds.  The package execution failed.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 14:23:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 14:23:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  14:23:00  Error: 2019-09-24 14:23:00.75     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  14:23:00  Finished: 14:23:00  Elapsed:  0.39 seconds.  The package execution failed.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 13:30:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 13:30:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  13:30:00  Error: 2019-09-24 13:30:00.68     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  13:30:00  Finished: 13:30:00  Elapsed:  0.421 seconds.  The package execution failed.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 13:29:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 13:29:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  13:29:00  Error: 2019-09-24 13:29:00.81     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  13:29:00  Finished: 13:29:00  Elapsed:  0.405 seconds.  The package execution failed.  The step failed.,00:00:00,0,0,,,,0
    09/24/2019 13:28:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 13:28:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  13:28:00  Error: 2019-09-24 13:28:00.98     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  13:28:00  Finished: 13:28:01  Elapsed:  0.406 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 13:27:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 13:27:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  13:27:00  Error: 2019-09-24 13:27:01.16     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  13:27:00  Finished: 13:27:01  Elapsed:  0.39 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 13:26:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:01,0,0,,,,0
    09/24/2019 13:26:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  13:26:00  Error: 2019-09-24 13:26:01.35     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  13:26:00  Finished: 13:26:01  Elapsed:  0.405 seconds.  The package execution failed.  The step failed.,00:00:01,0,0,,,,0
    09/24/2019 13:25:00,Record SQL,Error,0,SRVDB01\WINCC,Record SQL,(Job outcome),,The job failed.  The Job was invoked by Schedule 9 (Minutos).  The last step to run was step 1 (Importacao Arquivo CSV).,00:00:00,0,0,,,,0
    09/24/2019 13:25:00,Record SQL,Error,1,SRVDB01\WINCC,Record SQL,Importacao Arquivo CSV,,Executed as user: SRVDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  13:25:00  Error: 2019-09-24 13:25:00.49     Code: 0xC000F427     Source: Delete CSV File      Description: To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  13:25:00  Finished: 13:25:00  Elapsed:  0.405 seconds.  The package execution failed.  The step failed.,00:00:00,0,0,,,,0


    • Edited by Augusto B Thursday, September 26, 2019 8:23 PM
    Thursday, September 26, 2019 8:21 PM
  • Hi Augusto B,

    May I know if you have anything to update?

    Best Regards,

    Mona


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, October 4, 2019 9:01 AM
  • Hi everyone !

    I finally found the problem today. Following the solution:


    In SQL Server Job > Properties > Steps > In the Execution Option Tab >

    I've checked "use 32 bit runtime"  and in the "data sources tab" unchecked the checkboxes of the connection managers.

    Cheers,

    Berg

    • Marked as answer by Augusto B Tuesday, October 8, 2019 5:24 PM
    • Unmarked as answer by Augusto B Tuesday, October 8, 2019 5:24 PM
    • Marked as answer by Augusto B Thursday, October 10, 2019 11:21 AM
    Tuesday, October 8, 2019 2:32 PM
  • Hi Augusto B,

    Please remember to click "Mark as Answer" the responses that resolved your issue.

    This can be beneficial to other community members reading this thread.

    Thank you.

    Best Regards,

    Mona




    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, October 9, 2019 3:22 AM