[dba-SQLServer] Bulk insert (Arthur Fuller)

Hi Guys:  Keep cool, everybody.  John:  The fact that you asked many
questions that nobody here could answer is unfortunate but again doesn't
reflect badly on the tool or the users.  The two sites I mentioned
(sqlcentral.com and sswug) have very active forums specifically
dedicated to such topics as SSIS in 2005 or DTS in sql2k, etc.  When you
have a very specific question such as some of the ones you posed here, I
have found better results on forums such as those.  This forum has some
very capable people, but relatively few regular posters.  SQL Server is
such a broad product that by now it takes a number of people specialized
in different aspects of it to solve many of the harder problems.  Most
of those specialists are solving problems that the wizards in sql server
cannot begin to address.  Good luck.  David


------------------------------

Message: 6
Date: Wed, 2 May 2007 07:55:50 -0400
From: "JWColby" <jwcolby at colbyconsulting.com>
Subject: Re: [dba-SQLServer] Bulk insert
To: <dba-sqlserver at databaseadvisors.com>
Message-ID: <002e01c78cb0$d6e93950$657aa8c0 at m6805>
Content-Type: text/plain;	charset="us-ascii"

Arthur knock it off.  I haven't even begun to explore what SQL Server in
general can do.  I asked a whole STREAM of questions about using SSIS to
do
this and you and everyone else were strangely silent.  This list is
exactly
about getting HELP not "your statements are preposterous".  If you can't
answer how to do it, that is fine (notice that you STILL aren't offering
an
answer) but if YOU DON'T KNOW (being the kung fu master of SQL Server)
then
exactly how am I supposed to figure it out.

Preposterous my statements may be (though you aren't showing me proof of
that) but insulting your statements are, and not helpful to boot.

I came up with a solution to my problem that involved a TOY.  YOU OTOH
do
NOT offer a solution but hint that someday when I too am a kung fu
master I
will be able to solve my problems masterfully.  Which I do not doubt.  I
respectfully suggest that you put your money where your mouth is.

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur
Fuller
Sent: Tuesday, May 01, 2007 11:33 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Bulk insert

To put it as gently as possible, you haven't even begun to explore what
SSIS
can do. Several of your statements are so preposterous as to lie beneath
rebuttal. I suggest that when you have a spare weekend, you investigate
the
SSIS documentation. There you will find abundant insight into how to
handle
CSV and fixed-width files, not to mention a whole lot more. I'm sorry
that
the wizards couldn't get you from here to there, but just because you
couldn't figure out immediately how to do it does NOT mean it's the
tool's
problem. SSIS is a quantum leap beyond what DTS could do, and even it
could
handle your CSV and trailing spaces problems without difficulty.

I respectfully suggest it's time for input (read some documentation) not
output. This is not to say that SSIS is problem-free, but the trivial
issues
you raise are solvable in a few minutes of reading.

Arthur