Use naming conventions for data sources and datasets that document the source of data.
- Data sources. If you do not want to use an actual server or database due to security reasons, use an alias that indicates to the user what the source of data is.
- Start with DS and followed by databasename(Avoid server name as this will change during the deployment) (e.g. DS_AdventureWorks)
- Datasets. Use a name that indicates which data source it is based on.
- Start with DT and followed by datasorurce name and followed by meaningful name about the dataset (e.g. DT_DS_AdventureWorks_Customerinfo)
E.g. the name of a Tablix which shows the policy summary will be “TBXPolicySummary”
|Three letter Abbreviation