Re: Dynamically Build Columns For Transfering Data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Derek/Allen

I have similar issue, we have bunch of .dbf files which we need to
import in SQL Server 2005 on daily basis. Data Structures in .dbf
files keeps changing say 2 times a month.

Is there any way in SSIS to drop and recreate SQL Server tables
automatically if strucutre in .dbf files changes.

Thanks

AM1234



Allan Mitchell wrote:
Hello Derek,

You did and you should have the code now


allan

I believe I just sent it correctly.

"Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx> wrote in message
news:5aaa448066c78c856d0821b3684@xxxxxxxxxxxxxxxxxxxxxxx

Hello Derek,

remove the no-spam first

Allan

I send a note back to the no-spam address. Correct?

"Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx> wrote in message
news:5aaa448066c28c856cbd064915a@xxxxxxxxxxxxxxxxxxxxxxx

Hello Derek,

send me an eMail privately and I'll send you some code

Allan

I need to dynamically build the columns used in a Transform Data
Task (or possibly a Data Driven Query Task). I understand how to
read from the registry and/or text files to dynamically set items,
but I am not sure where to start to build the source and
destination columns in a Transform Data Task. I read the columns
from the system tables in the source and destination databases, so
that is how I will get the list of columns. In DTS, what
properties can I set dynamically for 1) The SQL statement used to
get the source data, and 2) the SQL statements (or the columns
used) to write the destination data. Please point me in the right
direction.

Thank You,
Derek Hart

.

Relevant Pages

  • Re: sql language problem
    ... connecting to the table using the odbc driver ... The langage in the dbf files is ... > Protuguese, and after I finish my import into SQL server, the characters ... > changed into some monster characters, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Exception.txt.dest being overwritten on multiple calls to the same package
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. ... > for each iterated package. ... I suppose I can create a final task that combines the> similar files by name pattern, or better yet, loads them all into SQL> Exception tables for easier inspection. ... >>> I have a data migration package that pulls data from DBF files located> in ...
    (microsoft.public.sqlserver.dts)
  • Re: Database normalization
    ... You will have to recreate each of those dbf files as a table in order ... to import the data into SQL Server. ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Re: The Contrarians Development Language
    ... My personal preferences would probably be SQL Server, MySQL, and dbf ... The only one of those that's an odd choice is the dbf files, ...
    (borland.public.delphi.non-technical)
  • Re: Variable text file destination name
    ... How can I change the filename for a text file connection? ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > destination of the text file! ... > Connection properties using the Dynamic Properties Task ...
    (microsoft.public.sqlserver.dts)