Unanswered: Question About Listing Source Table Name as Column in Database Table
I apologize in advance if my wording is hard to understand. I am very new to working with Databases and SQL. Feel free to ask any questions for clarification. I am an intern working on building a database for my company using SQL 2008. I have unpivoted my Excel source table and it is now in my OLE Database. I would like to include a column in the OLE DB with the name of the source table (Excel File) so I will be able to easily see where each piece of data came from.