SQL Agent and SSIS Date Parameter Issue

• acrutchley

  SSCrazy

  Points: 2117

  More actions

  August 15, 2014 at 6:49 am

  #289914

  I have created a SSIS package that accepts 3 parmeters: A boolean and two dates (datetime format).

  I have created a SQL agent job to run the package which works successfully with the default parameter values, and also if I change the boolean value.

  However when I change one of the date parameters, which are in the format of: 15/08/2014 12:15:00 something else e.g. 15/08/2014 13:15:00 the job fails with the following error: Message

  Executed as user: xxxxx\xxxxxxx. Microsoft (R) SQL Server Execute Package Utility Version 11.0.5058.0 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 13:41:15 Failed to execute IS server package because of error 0x80131537. Server: xxxxxxxxxxxx, Package path: \SSISDB\xxxxx\xxxxxxxxx\Package.dtsx, Environment reference Id: NULL. Description: String was not recognized as a valid DateTime. Source: mscorlib Started: 13:41:15 Finished: 13:41:15 Elapsed: 0.172 seconds. The package execution failed. The step failed.

  If I the try to edit the job step I get the following error box: String was not regognized as a valid DateTime. (mscorlib), and the only thing I can do is to delete the step.

  I also noticed if I script the job to a new query window when the job is first created (with the default values) all the parameters are listed, if I change the boolean value and script it again all the parameters are list and shows the change to the boolean value. If I change one of the date parameters and script the job all all but the changed parameter is listed.