SSIS Tutorial Lesson-1-6 cant Find dbo.DimDate table in AdventureWorks2012 Database

John Sade 21 Reputation points
2021-08-19T04:00:52.367+00:00

Hi,
I recently started practicing SSIS-tutorial, and am in Tutorial -- Lesson 1-6; While executing the steps in the document, under the Heading "Add and configure the Lookup Date Key transformation" I couldn't find

'dbo.DimDate' table in AdventureWorks2012.

Am I using the wrong version of the AdventureWorks database or is it something else?

Thanks

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,592 questions
{count} votes

Accepted answer
  1. ZoeHui-MSFT 37,671 Reputation points
    2021-08-19T05:24:34.787+00:00

    Hi @John Sade ,

    Please use AdventureWorksDW2012 database for a try.

    Download link: adventureworks-install-configure

    124562-screenshot-2021-08-19-132353.jpg

    Regards,

    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.