I have a couple of questions regarding a package I am writing. Hope you
ca help:

1. I have a "Transform Data Task" that is moving fields from a file
directly into a table. There may be exceptions regarding fields that
cannot be null, non-numerics to integers, etc.

Thus, it is worth catching these in an exception file. With this
package, I may be applying it to several servers and this may mean that
file locations change for each server. Thus, my file location is a
global parameter that is populated in an ActiveX script and then used
in this script as an override for file locations throughout the
package. I have used this successfully as an override for the Input
file name for the task and a Winzip parameter in a ProcessCommandLine
parameter for a DTSCreateProcessTask)

However, this has not been done via my own knowledhe or the help
system, but simply by finding other examples in DTS packages.

In my ActiveX script, how do I override the Exception File name
mentioned at the start od this question? I have no examples of this.

2. My transform task is moving fixed length fields directly into
varchars (eg 60 byte text intro a varchar(60) column on my table. I
think this is not converting into a varchar as I would like (I believe
all fields are being created as fields of length 60, even if they are
spaces). Is it possible in this step to ensure the input fields are
trimmed (cannot see an option when moving directly to a table) and if
possible, treat empty fileds (all spaces) as NULL?

Cheers

Mark

Please ignore as |I have found an alternative solution.

Cheers

Mark
stainless wrote: