Hi All,
This is a difficult situation to explain but I'll do my best.

I have a DTS Package which contains a Connection to an OLAP Data Source, a
Connection to a Text File and a transformation in between which does the
obvious. Prior to the connection to OLAP I modify the MDX Statement (SQL
Statement) in the DataPump task using ActiveX Script.

The problem with this is that the resulting Source column definitions
sometimes change. I know when using the DTS Designer if I change the MDX or
SQL Query it will automatically tell me there are errors. Is there a way
I can execute the auto-mapping feature through ActiveX script?

Any help would be greatly appreciated... .this issue is getting more urgent
by the day.

Thanks
Josh

Josh

I have sent a possible way of doing this to you in private eMail as
requested

--



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


"Josh Lawrence" <someone (AT) microsoft (DOT) com> wrote

Just curious if the solution involved a dynamic property task?