SSIS: rocket science or dummy user?

21 Apr 2006 8:53 PM

herbert

Every now and then I consider SSIS / DTS for a task like this:
â€œHere is a MS-Excel file. A secretary recorded eBay auctions over years in
it. It is not normalized containing the columns article number, auction
number, description, date/time, and price. There is one MS-Excel sheet per
eBay category. Convert every MS-Excel sheet into a normalized SQL Server
database with two tables: products and auctions.â€

1) I don't have time to read 700+ pages SSIS book. Can somebody please point
me to a solution?

2) My feeling is I better write my own VB.NET 2005 app which takes only a
fraction of the time compared to reading cover to cover of a book.

3) in general: How do I learn SSIS if there is nobody experienced in DTS
around here? Is there any "SSIS for dummies" brochure ?

thanks, herbert

22 Apr 2006 4:12 PM

Andrew Watt [MVP]

Herbert,

As a first step I suggest you take a look at the Integration Services
Tutorial that you can install using SQL Server 2005 Setup. If you work
through that your follow up questions will be more specific.

I suggest you also specifically take a look at information about the
Excel Source and OLE DB Destination as well as the Foreach Loop.

Follow-up Integration Services questions are probably best posted on
the SSIS newsgroup: microsoft.public.sqlserver.integrationsvcs.

Andrew Watt [MVP]

On Fri, 21 Apr 2006 13:53:02 -0700, herbert
<herb***@discussions.microsoft.com> wrote:

Show quote

>Every now and then I consider SSIS / DTS for a task like this:
>“Here is a MS-Excel file. A secretary recorded eBay auctions over years in
>it. It is not normalized containing the columns article number, auction
>number, description, date/time, and price. There is one MS-Excel sheet per
>eBay category. Convert every MS-Excel sheet into a normalized SQL Server
>database with two tables: products and auctions.”
>
>1) I don't have time to read 700+ pages SSIS book. Can somebody please point
>me to a solution?
>
>2) My feeling is I better write my own VB.NET 2005 app which takes only a
>fraction of the time compared to reading cover to cover of a book.
>
>3) in general: How do I learn SSIS if there is nobody experienced in DTS
>around here? Is there any "SSIS for dummies" brochure ?
>
>thanks, herbert