I've had this problems intermittently using temp tables. What I did was
convert to permanent "temp" tables with the maximum field size defined
and the problem went away. The problem would happen occasionally when a
value exceeded the original default definition.
To determine which step failed, find the matching task or step under
Disconnected Edit. If the error message states
DTSTask_DTSExecuteSQLTask_5 failed, open the package, click on a blank
area, click Disconnected Edit, expand Tasks, and click on the
DTSTask_DTSExecuteSQLTask_5 task. Hopefully the description or SQL
statement will identify where the problem is.
Good luck.
-----Original Message-----
From: Norkett Margaret
[mailto:mssqldba-ezmlmshield-x7040435.[Email address protected]
Sent: Tuesday, May 29, 2007 8:23 AM
To: LazyDBA Discussion
Subject: RE: DTS Logging
I am importing data from a comma delimited file into a holding table,
then
using the data in the holding table to populate other tables in my
production database.
The DTS job first imports the data to the holding table, and then
subsequent
steps do the other work.
From the error message on the job, I am unable to tell which step is
failing
(and there are around 25 steps).
I may just have to scrap that part of the job and send it all to stored
procedures and/or triggers to do the work required.
If you have any questions or concerns, please let me know them.
Margaret Norkett
Database Administrator
* 864-271-6522 ext 222
* 864-270-2884
Freedom is not worth having if it does not include the freedom to make
mistakes. Mahatma Gandhi
-----Original Message-----
From: Vanessa van Gelder [mailto:[Email address protected]
Sent: Tuesday, May 29, 2007 7:52 AM
To: 'Norkett, Margaret'
Subject: RE: DTS Logging
I know what I means you read me incorrectly..
Well what are you importing from and to?
-----Original Message-----
From: Norkett, Margaret [mailto:[Email address protected]
Sent: 29 May 2007 01:49
To: 'Vanessa van Gelder '
Subject: RE: DTS Logging
Thank you for your response.
As most DBA's would be, I'm well aware of what the message means (and by
the
way, it means the string or binary data being inserted into the column
is
too BIG, not too small).
However, when I take the data and query into QA, I am unable to
duplicate
the error -- i.e. there is no data that doesn't fit the column
constraints.
Also, when I check the table that holds the data, all the columns are
appropriately populated with the necessary information.
Could this be some result of something writing to a system table?
If you have any questions or concerns, please let me know them.
Margaret Norkett
Database Administrator
* 864-271-6522 ext 222
* 864-270-2884
Freedom is not worth having if it does not include the freedom to make
mistakes. Mahatma Gandhi
-----Original Message-----
From: Vanessa van Gelder [mailto:[Email address protected]
Sent: Tuesday, May 29, 2007 7:37 AM
To: [Email address protected]
Subject: RE: DTS Logging
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text
It means that what your are importing into is too small for what you are
insert, you need to check the length of the data you are importing into
the
table and make sure your columns sizes are big enough
-----Original Message-----
From: Norkett Margaret
[Email address protected]
Sent: 29 May 2007 01:32
To: LazyDBA Discussion
Subject: RE: DTS Logging
I have the same situation as Mr. Debiasi and yes, I do expand the view
to
show the details.
I've also taken the entire scripted job into Query analyzer using the
same
data and am unable to duplicate the error (which for me is "string or
binary
data will be truncated"
If you have any questions or concerns, please let me know them.
Margaret Norkett
Database Administrator
* 864-271-6522 ext 222
* 864-270-2884
Freedom is not worth having if it does not include the freedom to make
mistakes. Mahatma Gandhi
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---
DXS - The Essential Healthcare Information Solution
http://www.dxs-systems.com/
DISCLAIMER:
This communication (including any attachments) may contain confidential
or
proprietary information. If you are not the intended recipient and you
have
received this communication in error, you should destroy it without
copying,
disclosing or otherwise using its contents and notify the sender
immediately
of the error.
Internet communications are not necessarily secure, and may be
monitored,
intercepted or changed after they are sent. DXS and its subsidiaries do
not
accept liability for any loss you may suffer as a result of
interception, or
any liability for such changes.
---
DXS - The Essential Healthcare Information Solution
http://www.dxs-systems.com/
DISCLAIMER:
This communication (including any attachments) may contain confidential
or
proprietary information. If you are not the intended recipient and you
have
received this communication in error, you should destroy it without
copying,
disclosing or otherwise using its contents and notify the sender
immediately
of the error.
Internet communications are not necessarily secure, and may be
monitored,
intercepted or changed after they are sent. DXS and its subsidiaries do
not
accept liability for any loss you may suffer as a result of
interception, or
any liability for such changes.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page