"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:OLL6Jg9qEHA.2764@TK2MSFTNGP11.phx.gbl...
> If you really want to possibly redo everything everytime then using
> DataPump task is not for you.

> When you say "Feed a file" what do you mean.

"Brandon Lilly" <brandon.lilly@no_spam.medevolve.com> wrote in message
news:uMzhsD9qEHA.2436@TK2MSFTNGP10.phx.gbl...
> As part of a much larger DTS package, I am needing to copy a large
> quantity
> of data from an Oracle source to a flat text file. I originally intended
> to
> use the datapump object to do this, but I am not needing to do any
> transformations, I simply want to copy the data to a file.
> If this were one query, I would just set it up in DTS, but I actually want
> to feed the package a file that contains the scripts of the data I wish to
> export. Each time the query changes, all the transforms (copy row) need
> to
> be redone, and this seems like a silly amount of work to get this to
> work -
> not to mention that I cannot seem to find documentation on how to do this
> anyhow.
>
> Is there another way? Can anybody point me to a website with a solution
> to
> this?
>
> Also, I read somewhere that the datapump tasks truncates text data. While
> none of the tables have wide text rows (> 255 characters), they are very
> wide with each having as many as 275 columns. Is this going to be an
> issue?
>
> Thanks,
>
> Brandon
>
>

"Brandon Lilly" <brandon.lilly@no_spam.medevolve.com> wrote in message
news:efX2bq9qEHA.592@TK2MSFTNGP11.phx.gbl...
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> news:OLL6Jg9qEHA.2764@TK2MSFTNGP11.phx.gbl...
>> If you really want to possibly redo everything everytime then using
>> DataPump task is not for you.
>
> The data extraction is just a small portion of the overall package. See
> below...
>
>> When you say "Feed a file" what do you mean.
>
> I have a text file that was generated from another process that contains a
> SQL query that will be used to extract data from Oracle to a delimited
> text
> file. Essentially, I set the contents of that script as the datapump
> task's
> SQL Source statement. Since the query changes between runs, I have to
> clear
> out all the transformations, and reconfigure them all. In this case, I am
> never needing to actually transform anything - I simply want to copy all
> columns. I just found something about a "many-to-many transformation",
> but
> can only find directions on how to set it up manually with the DataPump
> task, and not through vbscript.
>
> As I said, the datapump is only a small part of the overall package,
> sitting
> somewhere in the middle of the execution path (the results are then
> encrypted, packaged up and sent to a remote site, etc)
>
> Thanks,
>
> Brandon
>
>