The solution was to install KWS on the server where the solution is going to be deployed to in addition to the development server.

• This reply was modified 5 months, 1 week ago by  Bhagat.

I have spent a few days researching on the internet with no great success. Also recreated a new solution as well just in case it got corrupted.

The only potential solution...

Thank you Phil, I think that will work when I do deploy to the SSISDB.

At the moment, dataverse is constantly being update with a new/deleted/updated columns which is why I...

Sorry, forgot to mention this is to be used within SSIS / Visual Studio 2019, so those do not work.

So, casting the below output to date datatype:

the problem with security in the fileshare, for some reason it was missing MSSQL$ITSQL account.

adding it back, allowed files to be written.

yes , it looks like I need to setup environments.

Thanks

Permissions will be denied to access server B from VS as each server has different login connections to the MySQL database as it's based on IP address of the server.

In...

Thanks Phil for getting back.

Bit of progress, the output location is a Share, when changed to a different share, the writing of files work.

So going to ask my IT department...

yes, we can manually create files onto that network location as the users.

Tried the SSISDB cataog, the package_data column shows all null values for some reason.

However, we do have source control (GitLab), so I can search in there.

Thank you

The package

1. connects to a SQL server database to get current month data.
2. pass a results of a variable (from 1) into an SSRS report defined in a script task...

So I installed sql server locally and deployed a dtsx package to the integration services catalog from VS. SSISDB database is already there, so thought I'd create the SP there.

The...

Think I found the issue, administrator visual studio had deployment target of 2016, which I assume defaulted the language to 2015.

The answer is to update the format to

Format=EXCELOPENXML

and then works

the file already exists, which only has headers