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!

What does the job fail with ?


--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Marco Linders" <m.linders (AT) pforb (DOT) com> wrote

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!

This error here

'Col007' (DBTYPE_STR), destination column 'COSMC' (DBTYPE_R4)).

is telling us that your source is a string and you are trying to go to a
REAL. The values are incompatible. SQL Server will do an implicit
conversion between the two but the problem with using a String as the source
is that it could quite happily be 'ABC' and that will not be accepted at the
other end.

Now that said. If you schedule it then it should work the same. Are the
tests using the same file when they work manually not scheduled ?


--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Marco Linders" <m.linders (AT) pforb (DOT) com> wrote

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!

Can i see the file + table struct ?

I can then try repro.

Send me privately.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Marco Linders" <m.linders (AT) pforb (DOT) com> wrote

Hi Frank,

Thanks for your reply.

For sure I checked the versions, but it has nothing to do with it,
because other DTS's I have are working good, when I schedule them. And
also, when I change the data type from real to numeric.

If you have any other suggestions, please let me know.

Regards,
Marco.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hello Allan,

Please send me your e-mail address, so I can send you the files.

Best regards,
Marco.




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hello, Marco!

remove no-spam from my address in the header

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

: Please send me your e-mail address, so I can send you the files.

: Best regards,
: Marco.

--- AspNNTP 1.50 (ActionJackson.com)

Done

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Marco Linders" <m.linders (AT) pforb (DOT) com> wrote