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

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 (AT) microsft (DOT) com> wrote

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 (AT) no-spam (DOT) sqldts.com> wrote

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 (AT) microsft (DOT) com> wrote

clear on this?

Thanks Allen.


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

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 (AT) microsft (DOT) com> wrote

and not working in another database in the same server on which I have a
Administraotr Role!!!!

Thanks

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

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 (AT) microsft (DOT) com> wrote

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 (AT) no-spam (DOT) sqldts.com> wrote

Quotes ?

DTSSource(Cons_RecordType )

Should it be

DTSSource("Cons_RecordType")


Allan

"J-T" <J-T (AT) microsft (DOT) com> wrote