DTS w/ Oracle Issue
Im having an issue with DTS and I dont know if anyone else has
experienced this...In my transformation I have a sql statement that
executes against oracle..in it I'm selecting COUNT(DISTINCT
I.PX_INVOICE_ID) ...however when the DTS package executes I get an
error stating that "DISTINCTI"."PX_INVOICE_ID" is an invalid
identifier..why is it concatenting this?
Thanks
Jim
.
Relevant Pages
- Re: Transformation Data Task
... Make sure that DTS is Running in Transaction mode. ... make sure Commit on Successful package completion is True. ... > I'm using Transformation Data Task to copy data from one server to another ... I need source and destination connection parameter to set ...
(microsoft.public.sqlserver.dts) - Re: Transformation Data Task
... Make sure that DTS is Running in Transaction mode. ... make sure Commit on Successful package completion is True. ... > I'm using Transformation Data Task to copy data from one server to another ... I need source and destination connection parameter to set ...
(microsoft.public.sqlserver.dts) - Re: Optimize transformation
... I am using one copy column transformation for each column. ... T-SQL: I have considered this. ... difference between DTS and plain T-SQL? ...
(microsoft.public.sqlserver.dts) - Re: How to automatically "map" the transformations in Transform Data Task?
... source column names and destination column names are the same then no ... DTS will do that for you. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >> You then need to add 1 or more Transformation Object ...
(microsoft.public.sqlserver.dts) - Re: How to automatically "map" the transformations in Transform Data Task?
... source column names and destination column names are the same then no ... DTS will do that for you. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >> You then need to add 1 or more Transformation Object ...
(microsoft.public.sqlserver.server) |
|
