when running SSIS package with Windows Auth it works but with SQL Auth it fails
I believe your connection string is off based on what you added, I would try looking at the following website. It looks like your string is designed for a CE device...

https://www.connectionstrings.com/sql-server-2008/