StubHub Sales import

Driver	@Mark Shaver, @Lisa Gregerson
Approver	@April Dianne Gahuman
Contributors	@Kaitlyn Niemann (Unlicensed)
Informed	N/A
Objective	Import sales provided by Logitix via email/csv into a db table.
Due date	TBD
Key outcomes	Automated record/daily import of data provided via email.
Status	In Analysis

Problem Statement

Need email attachment received from developer@logitix.com into Database table on receipt.

Must have:	Ability to read from csv attachment in it@ticketboat.com inbox. Ability to read data from csv attachment into data stream. Ability to write to DatawareHouse. Ability to run on schedule. Need either a table created or a table specified as data destination.

Must have:

Nice to have:

Ability to update old records if they should come through an additional time.
Addl reporting parameters.
Columns for StubHubEventID(smallint), TransactionDate(smalldatetime), EventDate(smalldatetime), PrimaryPerformer(varchar(50)), SecondaryPerformer(varchar(50)), VenueName(varchar(50)), Section(varchar(20)), SectionNumber(varchar(10)), Row(varchar(10)), Seats(varchar(18)), Quantity(smallint), TransactionAmount(money), Marketplace(varchar(60)), DeliveryOption (varchar(20))

Not in scope:

Milestone	Owner	Deadline	Status

Milestone	Owner	Deadline	Status
Identify or create destination table	@Kaitlyn Niemann (Unlicensed)	N/a	In Analysis
Read csv into data stream	@Kaitlyn Niemann (Unlicensed)	N/a	Not Started
Write csv to table	@Kaitlyn Niemann (Unlicensed)	N/a	Not started