Re: importing delimited file into SQL table via c++

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 01/20/05 

Date: Thu, 20 Jan 2005 19:50:00 -0000

Here is an example of executing a package in C++ if that helps any?

http://www.sqldev.net/dts/ExecutePackage.htm 

-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good.  here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
<ezelasky@hotmail.com> wrote in message 
news:1106242618.204436.204900@c13g2000cwb.googlegroups.com...
> Hello:
>
> Does anyone know of an example showing how to import a delimited text
> file into SQL via the DTS api in C++???  I can get this to work from VB
> but when I translate it to C++ it doesn't work, even though I get a
> HRESULT that succeeded.  It is so frustrating!! Short of posting the
> code here, an C++ example (or link)would be helpful.
>
> BTW - I can get the reverse to work, exporting from SQL to a delimited
> file in C++.
>
> Thanks!
>

Relevant Pages

  • Re: dts of everything except indexes...
    ... Andrew J. Kelly SQL MVP ... > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > www.SQLDTS.com - The site for all your DTS needs. ... and to create indexes afterwards. ...
    (microsoft.public.sqlserver.dts)
  • RE: A couple of R2 Impressions
    ... I agree 110% with Ross M...why why why take away my DTS that I rely and works ... component or I can't use it...it is going to be hard enough to master SQL ... have concern over the decision to dramatically reduce functionality with the ... or good business for MS – it just alienates customers. ...
    (microsoft.public.windows.server.sbs)
  • Re: How do I run a .BAS file saved from a DTS package?
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... I have used DTS for import and export. ... > The DTS Designer is easy to understand and use. ...
    (microsoft.public.sqlserver.dts)
  • Re: Sybase Source. What "data flow source" to use?
    ... but could still use DTS to move data. ... when I right-click over a SQL 2005 database and select Import ... datasources defined in ODBC Datasources on my computer, ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL DTS Job Status
    ... your DB and have the DTS task run an Execute SQL task to write a record to ... Another option is to set up an Operator in SQL Server and have the SQL Agent ... > some of the data that was loaded from DTS. ...
    (microsoft.public.sqlserver.dts)