Transfer SQL Server Objects Task internals

How often do you wonder what something’s actually doing under the hood (in the way that it talks to SQL Server)? It’s a trick I’ve written about before – when working out how SSRS did multivalue parameters. This time, it’s Integration Services’ turn. SSIS has this Transfer SQL Server Object task, designed to be able to transfer objects like tables from one database to another. But Ali got in touch saying that it wasn’t transferring the default constraints for his table – that thing which means that the current date, 0 or ‘dbo’ gets populated in the field when you … Continue reading Transfer SQL Server Objects Task internals