HOWTO: export with SSIS!!! is a new dimension of SQL?

Question

HOWTO: export with SSIS!!! is a new dimension of SQL?

David Brea

SSC Rookie

Points: 30
More actions
June 10, 2009 at 1:50 pm

#131743

Hi there.
Has somebody exported a Select (TSQL) result set to a DBF file (DBase iv, FoxPro 2.0 Dos).
How you did it?
Import, it the easy way, export it seems a new dimension :w00t:

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

COZYROC One Orange Chip Points: 28499 More actions · Answer 1

David Brea (6/10/2009)
Hi there.
Has somebody exported a Select (TSQL) result set to a DBF file (DBase iv, FoxPro 2.0 Dos).
How you did it?
Import, it the easy way, export it seems a new dimension :w00t:

David,

Have you tried using OLEDB Destination with the Jet provider? You can check the connection string you have to use here.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

David Brea SSC Rookie Points: 30 More actions · Answer 2

I had tried to install a Driver, but its only install on ODBC, and it never shows itself at the list in the destinations window at the wizard to Import and Export of SSIS.

What I am doing wrong? or What I need to search for to get hit the task?

Thanks,

David.

COZYROC One Orange Chip Points: 28499 More actions · Answer 3

David Brea (6/12/2009)
I had tried to install a Driver, but its only install on ODBC, and it never shows itself at the list in the destinations window at the wizard to Import and Export of SSIS.
What I am doing wrong? or What I need to search for to get hit the task?
Thanks,
David.

David,

You have to use OLE DB Destination with "Microsoft Jet 4.0 OLE DB Provider". Then you have to setup to use the DBF driver using the connection strings I have sent link.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

David Brea SSC Rookie Points: 30 More actions · Answer 4

Eureka!!!:w00t:

I got it !!:-P

The trick is to use a connection to the fox file, (at my case

c:\temp

is the connection name) and then, choose a data conversion item, and convert from unicode to non-unicode, or viceversa.

Put the codepage (1252), that is all.

All data is copied to my destination file specified at the connection.

Now, i has to continue to create a copy of the dbf file, or delete the previus dbf data, in the way to use it again, all by the SSIS framework.:w00t:

Thanks,

David.:-D