"J-T" <J-T@microsft.com> wrote in message news:J-T@microsft.com:

> I'm doing all the transformation in the ActiveX script of the datapump.
> Sorry to confuse you .It's working fine on one database so there is no
> booboo in the logic.There is something I'm missing somewhere and that's
> making the package incompatible with the other Database here is some portion
> of ActiveX:
>
> This refers to Table ---->DTSDestination("RECORD_TYPE") =
> DTSSource(Cons_RecordType ) <----This referes to CSV file
>
> Makes sense?
> Thanks a lot
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> news:eFbM66VZFHA.2452@TK2MSFTNGP12.phx.gbl...
> > Then it has to be the Source to the DataPump. Remember there are Source
> > Files and Destination files. You cannot specify a SQL Statement against a
> > Text File. Where do you get DTSSource() from?
> >
> > Confused.
> >
> > Allan
> >
> > "J-T" <J-T@microsft.com> wrote in message news:J-T@microsft.com:
> >
> >> > You have a CSV file as a Source in the datapump?
> >> Yes,I have a TextFile(Source) which is pointing to my CSV file.
> >>
> >> > If yes then you cannot specify a statement here you must just choose
> >> > the
> >> > object as the source i.e. the text file.
> >> I don;t get what you mean by this.This package is working on one database
> >> and not working in another database in the same server on which I have a
> >> Administraotr Role!!!!
> >>
> >> Thanks
> >>
> >> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> >> news:O1T1ZvVZFHA.3364@TK2MSFTNGP09.phx.gbl...
> >> > You have a CSV file as a Source in the datapump?
> >> >
> >> > If yes then you cannot specify a statement here you must just choose
> >> > the
> >> > object as the source i.e. the text file.
> >> >
> >> > Allan
> >> >
> >> > "J-T" <J-T@microsft.com> wrote in message news:J-T@microsft.com:
> >> >
> >> >> > So everything is pointing to everywhere it should be?
> >> >> Yes,Allen.Everything is right
> >> >>
> >> >> > What is the statement you are using in the source for the DataPump?
> >> >> I'm using a CSV file from my local desktop.It is like
> >> >> DTSSource(...).Am I
> >> >> clear on this?
> >> >>
> >> >> Thanks Allen.
> >> >>
> >> >>
> >> >> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> >> >> news:%23voO6OVZFHA.2128@TK2MSFTNGP15.phx.gbl...
> >> >> > So everything is pointing to everywhere it should be?
> >> >> >
> >> >> > What is the statement you are using in the source for the DataPump?
> >> >> >
> >> >> > Allan
> >> >> >
> >> >> > "J-T" <J-T@microsft.com> wrote in message news:J-T@microsft.com:
> >> >> >
> >> >> >> I changed everything to whatever you siad.Still get this error:
> >> >> >> "Syntax error or access violation"
> >> >> >> Everthing is fine.Databases are all pointing to what I
> >> >> >> want.Catalognames
> >> >> >> are
> >> >> >> right.Table name is also right.Why am I getting this error?
> >> >> >>
> >> >> >> It'd reslly geetting on my nerves?
> >> >> >> Isn't it a permission issue?I'm the admin server wide,why I should
> >> >> >> get
> >> >> >> this
> >> >> >> error?
> >> >> >> Thanks
> >> >> >>
> >> >> >> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> >> >> >> news:e%23FRPBVZFHA.2520@TK2MSFTNGP09.phx.gbl...
> >> >> >> > Ahhhh
> >> >> >> >
> >> >> >> > Right
> >> >> >> >
> >> >> >> > First thing you do is make the DestinationObjectName property of
> >> >> >> > that
> >> >> >> > DataPump task name only so find it in Disconnected edit | Eit and
> >> >> >> > change
> >> >> >> > th
> >> >> >> >
> >> >> >> > dbName.OwnerName.TableName
> >> >> >> >
> >> >> >> > To
> >> >> >> >
> >> >> >> > OwnerName.TableName
> >> >> >> >
> >> >> >> >
> >> >> >> > Now you need to change the Catalog property of the connection on
> >> >> >> > which
> >> >> >> > your destination sits through the DP task. Easy.
> >> >> >> >
> >> >> >> > Allan
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> > "J-T" <J-T@microsft.com> wrote in message news:J-T@microsft.com:
> >> >> >> >
> >> >> >> >> I'm using a Dynamic property to change my pump Task connection
> >> >> >> >> based
> >> >> >> >> on a
> >> >> >> >> global variable.The global variable specifies which database I'd
> >> >> >> >> like
> >> >> >> >> to
> >> >> >> >> use
> >> >> >> >> my DTS in.DestinationObjectName is something like
> >> >> >> >> [DatabaseName].[dbo].[TableName]. I don;t know how to change
> >> >> >> >> this
> >> >> >> >> portion
> >> >> >> >> only([DatabaseName]).
> >> >> >> >>
> >> >> >> >> Thanks
> >> >> >> >
> >> >> >
> >> >
> >