Hot answers tagged ssis
Don't just use the whole table. Instead choose the option to write a query. Then simply write a select statement that doesn't use that Identity Column. Alternatively, when you map columns, if you click "Delete rows in destination table", it will truncate the target table before loading data. If the opportunity exists for data to be removed from the ...
You've got something that doesn't convert to an integer value in your source data. Since the expression language doesn't have a tryparse method, the cleanest mechanism is to use a script component as a Transformation and leverage the .NET methods. Connect a Script Component to your source. On the Input Columns tab, check col as ReadOnly. On the Inputs ...
Under Solution Explorer On Righ Side In BIDS ---->RightClick ---->Properties ---->Configuration Properties ---->Debugging ---->Debug Options ---->Run64BitRuntime ---->False
Only top voted, non community-wiki answers of a minimum length are eligible