Import dBase tbl into SQLServer dynamically

[JR]

Having the Tablename and location of a dBase file as
Globals, how can I load it into a SQL Server database
table having the same column mapping dynamically?

Using the Transform Data Task object how do I set the
transformation mapping dynamically ?

[JFB]

Hi Jr,
Check this example...
http://www.sqldts.com/default.aspx?6,107,278,7,12
This is for text file but you can get the idea, back to us if you have
questions.
JFB

"JR" <john....@ppml.co.uk> wrote in message
news:09c201c31ad5$60346ab0$a401...@phx.gbl...

[JR]

thanks JFB

thats a good example. I Actually did it last night - got
up at 2:30 and broke it by the time my wife & kids woke up
and I had to go to work!

Basically I worked out how to assign an activeX script &
realised why building the mapping lines dynamically needed
vbNewline rather the CR & LF ! (I'm new to vbScript too).

I'm pretty impressed with DTS now I'm getting to know how
to use it properly

>.
>

[JFB]

Good job JR,
Probably if get the DTS book by chaffin you can learn more about it
http://www.amazon.com/exec/obidos/ASIN/1861004419/sqldts1-20/102-6170029-600
8118
Also in Darren's web site that I give you is a lot resource to explore.
I'm a DTS lover not an expert but I enjoy a lot to help people without pay
:)
JFB

"JR" <john....@ppml.co.uk> wrote in message

news:073c01c31bbf$7f693290$a001...@phx.gbl...