If you make a copy of a .dtsx file, the Package ID property remains the same.
This value is logged as the SourceID, and to ensure it is unique, you should
generate a new value for any copies of a package.
Or the short hand version
Build your Microsoft SQL Server expertise with technical deep dives for your database journey. Free PDF eBooks from Microsoft SQL Server eBook series Get the technical resources and documentation you need to explore SQL Server 2017 – a comprehensive, mission-critical database for demanding workloads. With this series of technical eBooks on SQL Server, you’ll learn […]
Now we need your help in fine tuning our bushfire warnings. We are in the process of adding CFA Bushfire Warnings and NSW Police Alerts to EWN. We will be adding other states soon after. We are working hard on this now and want to get it right the first time. These alerts could help […]
If you use Scripting tasks, the CLR or build components for SSIS, you will need to convert values from their SSIS types into .Net types. Here’s a quick list of the SSIS data types and their .Net companion. Integration Services Data Types Managed Data Type DT_WSTR DT_TEXT DT_STR System.String DT_BYTES DT_IMAGE System.Byte[] […]
