I did google before I posted and found the page too.

But that is not the answer. Microsoft said those two are deprecated, new development should use the new one. But...

Thank you, but when I tried to add a connection manager, in the provider list, I don't see there is a MSOLEDSQL. I do see one named microsoft OLEDB provider...

Thank you. We have the two situations you mentioned.

First if export then import , when doing import from the Ispac, will that automatically upgraded it to 2019 SSIS?

second, if deploy...

Another  place  I saw similar of this is in a sql script:

select cast(stu.VisibleID as int) as StudentID

,case when r.VisibleRouteID like '[0-9][0-9][0-9][0-9]-T%' then trex.OriginPointID

when r.VisibleRouteID like '[0-9][0-9][0-9][0-9]-I%' then trex.OriginPointID

when r.VisibleRouteID like...

Thank you, just saw that  too. I did unintall CU7, and apply CU6.  For now I think we are fine.

We will have to find another maitenance time for next CU8...

Thanks for the article.

Question, 1. how can you know the applilcation is using kerberos? In my environment, I always use domain account instead of local system account for the SQL...

This is more context of the script code:

Public Overrides Sub PreExecute()

'Sample valid value:

'Eff 20070905 Rev 00

'Pattern should match Route Number in VisibleRouteID string, allowing for a few minor formatting errors...

Thanks, I also heard complex logic should handle in business layer not on database layer. Is that just some people's preference?

Thanks all for the analysis and tips!

There are SSIS packages for other purpose of this project, but not for this process.

• This reply was modified 5 years, 1 month ago by sqlfriend.

Yes, there was a very experienced SQL developer contractor too.  He designed the whole database model, build up the database, create stored procedures and created some SSIS packages.

Thanks much, it makes sense to me.

The project was a big one and a complicated one. And an entire project team with several good developers and BA and Project manager...

Thanks. This overnight update process is a part of  a  big project we had and hired several contract developers and project team. The web service/applications does very complicated process for...

Just an update, last night run is successful, and the duration is normal too.

The two things we changed is to use FQDN instead of server name for the application call...

• This reply was modified 5 years, 1 month ago by sqlfriend.

after we restarted server, last night it runs in the middle of the process of 2000 of 6000 records, it gave the error:

Errors :                {                                System.Data.SqlClient.SqlError: A transport-level error...