Tag Info

Hot answers tagged

4

Yes there may be impact. To start with, you must read List of SQL Server features deprecated in SQL Server 2012 List of deprecated Database engine features in SQL Server 2012 Breaking changes to DB engine feature in SQL server 2012 You must run SQL server 2012 upgrade advisor and generate report before doing migration. This report would list out all ...


1

Yes. You will need to configure all the servers involved with your process to be of DTC. When you use the native SSIS transaction capability, if the connection managers are entirely self contained, then behind the scenes a standard BEGIN TRAN...COMMIT|ROLLBACK are issued. When there are multiple servers involved, that's when the distributed transaction ...


1

Not really. Since Excel isn't a proper client server database, you can't ask it how many rows are there before bringing them in. You could bring them into a staging area and count rows as they come in. If they don't match and you need to handle that with a business process, the destination is untouched. If they meet your validation criteria, do a second ...


1

The problem lies in the referencing. You might have copied the package from an older one and are making the changes or you might have edited the connection managers. The connection managers are internally used using the GUID that you have mentioned. You might have changed most of the references from the UI, but still there are some objects and tasks, that ...


1

Try setting the ValidateExternalMetaData property False and then try, quite possible due to run time allocations. Also set DelayValdiations to True, wherever applicable. If it does not solve, then let me know!!



Only top voted, non community-wiki answers of a minimum length are eligible