Hello all,
I've installed the SSIS component and i'm trying to import data into an
existing table.  I can't find an option, via the import/export wizard, to
direct the import to a specific table.  What happens currently, is a new
table is created each time I import.  Does anyone know how to do this?

Thanks Art

See my response to the posting immediately below this one in
microsoft.public.sqlserver.newusers, subject: "Import a csv into existing
table".

Often, the quality of the responses received is related to our ability to
'bounce' ideas off of each other. In the future, to make it easier for us to
give you ideas, and to prevent folks from wasting time on already answered
questions, please:

Don't post to multiple newsgroups. Choose the one that best fits your
question and post there. Only post to another newsgroup if you get no answer
in a day or two (or if you accidentally posted to the wrong newsgroup -and
you indicate that you've already posted elsewhere).

If you really think that a question belongs into more than one newsgroup,
then use your newsreader's capability of multi-posting, i.e., posting one
occurrence of a message into several newsgroups at once. If you multi-post
appropriately, answers 'should' appear in all the newsgroups. Folks
responding in different newsgroups will see responses from each other, even
if the responses were posted in a different newsgroup.


Show quoteHide quote

error importing data from Access to SQL Server
Upgrade connection issues
View results of Dynamic SQL in Management Studio
SQL 2005 Management Studio can't edit text rows with > 4000 charac
backup again