Re: Dynamic column mapping
From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 11/15/04
- Next message: Allan Mitchell: "Re: text file to sql server"
- Previous message: Jamie Carper - MJW Corp: "Re: Dynamic column mapping"
- In reply to: Jamie Carper - MJW Corp: "Re: Dynamic column mapping"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 15 Nov 2004 19:31:40 -0000
You have mailed me provately and I have supplied a method for doing this
-- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.Konesans.com "Jamie Carper - MJW Corp" <Jamie Carper - MJW Corp @discussions.microsoft.com> wrote in message news:78F34201-99FF-47BB-AF29-3701D9986AD3@microsoft.com... >I too am attempting to dynamically map the destination columns. > > I have a DTS that reads from multiple text files importing them into a SQL > tables. I do not know from one file to the next what the structure is going > to be. However I have included a sort of header file for my DTS to read > before the transformation. From this header file I am able thru the Dynamic > Properties to run a SQL query that builds the receiving table. I then thru > the same process set both the Source and Destination. I am also able to set > the column lengths of the TextFile object prior to Transformation. > > However I cannot determine how to affect the mappings. All I want is for the > DTS to use the default mapping it uses when I enter the Transformation > dialog. Nothing more nothing less. I want to do this using either the Dynamic > Properties or some other DTS process. > > > > > "Allan Mitchell" wrote: > >> In article <#WLANUMnEHA.3684@TK2MSFTNGP10.phx.gbl>, Krish wrote: >> > I believe there a way to do dynamic transformation mapping. >> > >> > I have source file as text file (two different text files), delimited pipe. >> > Iam exporting data from text file to Sqlserver database using DTS. >> > >> > 1st type of text file has - 32 columns >> > >> > 2nd type of text file has - 21 columns >> > >> > (both has same column name, expect number of columns) >> > >> > Iam using scripts to map two different text files (different names too..), >> > but finding hard time in mapping columns dynamically. >> > >> > Any script help appreciated. >> > >> > Thanks, >> > >> > Krish >> > >> >> OK >> >> Dynamic mapping is not as easy as it could/should be. >> >> In your instance the solution is simple. >> >> You have two datapump tasks. One for a 32 column text file and one for the 21 >> column text file. >> >> At the start of the package you check the file to see which type it is. You >> then Enble/Disable the correct instance of the datapump. >> >> >> -- >> >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) >> www.SQLDTS.com - The site for all your DTS needs. >> www.konesans.com - Consultancy from the people who know >> >> >> >>
- Next message: Allan Mitchell: "Re: text file to sql server"
- Previous message: Jamie Carper - MJW Corp: "Re: Dynamic column mapping"
- In reply to: Jamie Carper - MJW Corp: "Re: Dynamic column mapping"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
