"Marco Linders" <m.linders@pforb.com> wrote in message
news:OYbG3pWYDHA.1680@tk2msftngp13.phx.gbl...
> Hello all,
>
> I created a DTS to import an ASCII-file. First task in the DTS is to
> create a new table. I use a few real data type fields as well.
>
> When I execute this DTS manualy, everything is working fine. But when I
> schedule this DTS, the job fails.
>
> When I change the specific fields from real to, for example, numeric
> (30,10) and I schedule the DTS, everything is working fine.
>
> Can anyone tell me why I get this problem with real data type fields? An
> how can I solve this problem? I need the real data type fields, for
> later on in the DTS.
>
> Thanks in advance for any help.
>
> Best regards,
> Marco.
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

"Marco Linders" <m.linders@pforb.com> wrote in message
news:O0KDtRZYDHA.1680@tk2msftngp13.phx.gbl...
> Hello Allan,
>
> First of all, thanks for your reply.
>
> When I look at the Job History, the following message I get:
>
> Executed as user: <SERVERNAME>\SQLServiceAccount.
> ..p_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
> DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish:
> DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSDataPumpTask_1
> DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = 0 (0) Error
> string: Error during Transformation 'DTSTransformation__7' for Row
> number 1. Errors encountered so far in this task: 1. Error source:
> DTS Data Pump Help file: Help context: 0 Error Detail
> Records: Error: -2147213269 (8004202B); Provider Error: 0 (0)
> Error string: TransformCopy 'DTSTransformation__7' conversion error:
> Conversion invalid for datatypes on column pair 1 (source column
> 'Col007' (DBTYPE_STR), destination column 'COSMC' (DBTYPE_R4)).
> Error source: Microsoft Data Transformation Services (DTS) Data Pump
> Help file: sqldts80.hlp Help context: 30501 DTSRun OnError:
> DTSSte... Process Exit Code 1. The step failed.
>
> I hope this enough for you.
>
> Regards,
> Marco.
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

"Marco Linders" <m.linders@pforb.com> wrote in message
news:ebXJPoZYDHA.4040@tk2msftngp13.phx.gbl...
> Allan,
>
> I use the same DTS, with the same files. I do not change a thing.
>
> So manually it's working good, but scheduled I get the message.
>
> O should say, that it also should not work when I start it manually.
> But, again, then it's working...
>
> Strange isn't it?
>
> Regards,
> Marco.
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!