SSIS 2008: XML ==> SQL Server....Create Tables and then Insert Data all in one step
  Home FAQ Contact Sign in
microsoft.public.sqlserver.xml only
 
Advanced search
POPULAR GROUPS

more...

microsoft.public.sqlserver.xml Profile…
 Up
SSIS 2008: XML ==> SQL Server....Create Tables and then Insert Data all in one step         


Author: Travis McGee
Date: Sep 5, 2008 16:55

SSIS 2008:

I know I have installed the SSIS, but had to spend 30 minutes to figure out
how to get into it.....had to go into it through Visual Studio Business
Intelligence Icon (Dumb, Dumb, Dumb)

When they change something so draaaaaaaaaaaaaaaaaastically, they should make
some effort to minimize the initial hatret ....ie. keeping the previous "How
Do I Start This Darn Thing" path somewhat similar to the previous version.

Don't understand why Microsoft had to do GUI so "UNINTUITIVE" and
COMPLICATED and FRUSTSTRATING to use.

I am trying to use the below 2005 instructions with the 2008 version. About
to kill myself. I can write serious programs with my eyes closed, but
cannot figure out a simple task with new tools.

Came to step 5/6. Added an OLEDB connection.....but the think is I want
SSIS to create tables.

XML data is valid, XSD Schema data is valid (does not have annotation
section)

Tried importing to Access.....it is easy, it worked....over 255 field length
were cut off, though.

Want to do the same thing with SSIS.........but it is just frustrating.
Show full article (1.81Kb)
no comments

RELATED THREADS
SubjectArticles qty Group
SQL Profiler in SQL Server 2000microsoft.public.sqlserver.programming ·