Error when trying to run an SSISDB in VisualCron - VisualCron - Forum

Community forum

Rinbreos
2020-09-14T15:07:38Z
Exception in Task: ExecutePackage->Unhandled exception: System.ArgumentException: Keyword not supported: 'driver'.
at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)
at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key)
at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
at System.Data.SqlClient.SqlConnection..ctor(String connectionString, SqlCredential credential)
at SSISDBExecute.SSISDB.ExecutePackage(ProcessSSISDBTaskInfoClass task) in C:\git\code\SSISDBExecute\SSISDB.vb:line 51
Support
2020-09-14T15:26:02Z
Originally Posted by: Rinbreos 

Exception in Task: ExecutePackage->Unhandled exception: System.ArgumentException: Keyword not supported: 'driver'.
at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)
at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key)
at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
at System.Data.SqlClient.SqlConnection..ctor(String connectionString, SqlCredential credential)
at SSISDBExecute.SSISDB.ExecutePackage(ProcessSSISDBTaskInfoClass task) in C:\git\code\SSISDBExecute\SSISDB.vb:line 51



What version are you using? Please send screenshots of your connection settings to support@visualcron.com
Michael
Support
http://www.visualcron.com 

Please like  VisualCron on facebook!
Rinbreos
2020-09-14T15:27:52Z
Currently using version 9.3.5
Rinbreos
2020-09-15T12:11:12Z
We got this problem figured out now we have encountered a new problem.
We are trying to have VisualCron run our SSISDB package and we are now getting this error:

Exception in Task: Begin package execution log
Package:Validation has started.
Data Flow Task:Validation has started.
Data Flow Task:Information: Validation phase is beginning.

Data Flow Task:Validation is complete.
Package:Validation is complete.
Data Flow Task:Start, 6:49:35 AM.
Data Flow Task:Validation has started.
Data Flow Task:Information: Validation phase is beginning.

Data Flow Task:Validation is complete.
Data Flow Task:Information: Prepare for Execute phase is beginning.

Data Flow Task:Information: Pre-Execute phase is beginning.

Data Flow Task:Information: The processing of file "\\files\Apps\Seradex\Import\Ascentis\Duratech_Seradex.csv" has started.

Data Flow Task:Warning: Access is denied.

Data Flow Task:Error: Cannot open the datafile "\\files\Apps\Seradex\Import\Ascentis\Duratech_Seradex.csv".

Data Flow Task:Error: Flat File Source failed the pre-execute phase and returned error code 0xC020200E.

Data Flow Task:Information: Post Execute phase is beginning.

Data Flow Task:Information: The processing of file "\\files\Apps\Seradex\Import\Ascentis\Duratech_Seradex.csv" has ended.

Data Flow Task:Information: "OLE DB Destination" wrote 0 rows.

Data Flow Task:Information: Cleanup phase is beginning.

Data Flow Task:The task, 'Data Flow Task', failed.
Data Flow Task:Finished, 6:49:36 AM, Elapsed time: 00:00:00.297.
Package:Start, 6:49:35 AM.
Package:Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

Package:Finished, 6:49:36 AM, Elapsed time: 00:00:00.454.
End package execution log
Support
2020-09-16T08:16:18Z
Originally Posted by: Rinbreos 

We got this problem figured out now we have encountered a new problem.
We are trying to have VisualCron run our SSISDB package and we are now getting this error:

Exception in Task: Begin package execution log
Package:Validation has started.
Data Flow Task:Validation has started.
Data Flow Task:Information: Validation phase is beginning.

Data Flow Task:Validation is complete.
Package:Validation is complete.
Data Flow Task:Start, 6:49:35 AM.
Data Flow Task:Validation has started.
Data Flow Task:Information: Validation phase is beginning.

Data Flow Task:Validation is complete.
Data Flow Task:Information: Prepare for Execute phase is beginning.

Data Flow Task:Information: Pre-Execute phase is beginning.

Data Flow Task:Information: The processing of file "\\files\Apps\Seradex\Import\Ascentis\Duratech_Seradex.csv" has started.

Data Flow Task:Warning: Access is denied.

Data Flow Task:Error: Cannot open the datafile "\\files\Apps\Seradex\Import\Ascentis\Duratech_Seradex.csv".

Data Flow Task:Error: Flat File Source failed the pre-execute phase and returned error code 0xC020200E.

Data Flow Task:Information: Post Execute phase is beginning.

Data Flow Task:Information: The processing of file "\\files\Apps\Seradex\Import\Ascentis\Duratech_Seradex.csv" has ended.

Data Flow Task:Information: "OLE DB Destination" wrote 0 rows.

Data Flow Task:Information: Cleanup phase is beginning.

Data Flow Task:The task, 'Data Flow Task', failed.
Data Flow Task:Finished, 6:49:36 AM, Elapsed time: 00:00:00.297.
Package:Start, 6:49:35 AM.
Package:Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

Package:Finished, 6:49:36 AM, Elapsed time: 00:00:00.454.
End package execution log



That looks like a permission issue. Make sure you are using credentials/have correct permissions set
Michael
Support
http://www.visualcron.com 

Please like  VisualCron on facebook!
Scroll to Top