How to referrence project parameters in a SSIS Package
I have an SSIS Package I use to import data from two databases having the same table. In my destination table I have a field DB_ID which indicates which database the row came from. I was wanting to have this populated from a project parameter I would set at time of import.
Is this the best way to do this and, if so, how can I reference a project parameter from within my data flow task?
Microsoft SQL ServerMicrosoft SQL Server 2008SSRSSSIS