Re: Dynamically set up DTS Transformations?
- From: "Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx>
- Date: Wed, 14 Sep 2005 18:33:47 +0000
On its way
"Mehdi" <Mehdi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:EFFEC98C-4998-4918-937F-B899A18A2262@xxxxxxxxxxxxx:
Hello Allan, Ihave exatly the same problem, could you send me the answer directly here or send it to my email: mehdi.achour@xxxxxxxx I'm blocked and it's urgent Thanks a lot Mehdi
"Allan Mitchell" wrote:
> Have sent the package to your account > > -- > > > > 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 > > > "justinw" <justin_d_williams@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in > message news:qNSdnfd7FKAs1WXfRVn_vQ@xxxxxxxxxxxxxxx
> > Allan, I have been stuck on this exact issue for 2 days and have > > hopefully found someone in yourself who can help me. Please can you > > send some of the code so I can get a handle on how to have a > > transformation where it is dynamic allowing me to use the same > > package each time but set the source table and destination text file > > to be different each time. My email address is > > justin.d.williams@xxxxxxx Hopefully I will be able to have some > > success tomorrow. Really like the literature you have provided > > throughout the internet. > >
> >> Allan Mitchellwrote:
> > You will have to code this yourself. You can do it but you just need > > to
> >> code it. If you want some code to get a handle on doing it then
> > ping me
> >> offline > >> > >> -- > >> > >> > >> > >> 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 > >> > >> > >> "Jamie" <gsadd@xxxxxxxxx> wrote in message > >> news:%23WjneMyhFHA.3256@xxxxxxxxxxxxxxxxxxxxxxx > >> Hi, > >> > >> I have a DTS that transform data between two databases on the same
> > SQL
> >> Server, as shows below: > >> > >> table A ====> table B > >> (database_1) (database_2) > >> > >> Using Dynamic property of DTS, I can set up the source and
> > destination of
> >> the transformation dynamically via "global variable". I also need
> > the
> >> "transformations" part for the "Transform data task"to be set
> > dynamically,
> >> otherwise this DTS will fail when I transform another table (let's
> > say
> >> table C, its structure is different from table A) to table D (The > >> structure of table D is the same as table C, but not the same as
> > thable
> >> B). > >> > >> So is there a way that the traformations of "Transform data task"
> > between
> >> two data sources (I mean the mapping from the source columns to the > >> columns of destination) can be set dynamically? > >> > >> Thanks a lot in advance, > >> > >> Jamie > >> [/quote:08301de9da] > > > >
>
.
- Follow-Ups:
- Re: Dynamically set up DTS Transformations?
- From: mehdi
- Re: Re: Dynamically set up DTS Transformations?
- From: nsinha
- Re: Dynamically set up DTS Transformations?
- References:
- Re: Dynamically set up DTS Transformations?
- From: Mehdi
- Re: Dynamically set up DTS Transformations?
- Prev by Date: Re: Dynamic DataBase
- Next by Date: Re: MS JET database engine error: workgroup information file is missing or opened exclusively by another user
- Previous by thread: Re: Dynamically set up DTS Transformations?
- Next by thread: Re: Re: Dynamically set up DTS Transformations?
- Index(es):
Relevant Pages
|
Loading
