Dear all,
Hope all are fine. I am trying to run package from sql agent job, but got below error
"The GetEnumerator method of the ForEach Enumerator has failed with error 0x80131509 "(null)". This occurs when the ForEach Enumerator cannot enumerate."
Package used in this JOB will use excel and package reads multiple sheets and load data to Mysql.
In google many said to run in 32 bit, So I enabled 32 bit from job property, after enabling it i am getting different Permisson error saying " Execute SQL task fail to connect "MySql"connection may not be configured correctly or you may not have right permission on this connection DTSER_Failure(1) "
This Execute sql task inserts log, this worked when this package was running in 64 bit.
Don't know what is missing
This package runs sucessfully in UAT(using bids and via Agent Job)
pLease give me solution as today app getting live and data s need to be up.
Thanks