O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

How to do it...

  1. If not already done, open the package created in the previous recipe, FactOrdersToHDPCuster.dtsx.
  2. Add a Hadoop Hive task and rename it hht_HDPDWHiveTable.
  3. Double-click on it to open the Hadoop Hive Task Editor, as shown in the following screenshot:

Update the following parameters:

HadoopConnection: cmgr_Hadoop_Sandbox

SourceType: DirectInput

InlineScript: Use the following script:

 USE SSISCookBook; DROP TABLE SalesExtracts; CREATE EXTERNAL TABLE SalesExtracts( OrderDate timestamp, FirstName string , LastName string , CompanyName string , Category string , ProductName string , ProvenanceCode smallint , ProvenanceDescription ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required