Hi All,

I have a DTS package that failed on a step that contain the ONLY following
SQL command:

select idDataSource = cast(1 as smallint)

The above select command failed and give me the following error:

Syntax error converting from a character string to uniqueidentifier

In my opinion, the error is totally bogus. I looked at the package log file
and below is the logged error:


Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:The task reported failure on execution. (Microsoft
OLE DB Provider for SQL Server (80040e14): Syntax error converting from a
character string to uniqueidentifier.)
Step Error code: 8004043B
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100

BTW. I don't know if it is just a coincident it really has some things to
do with it: I just ran the Microsoft Auto Update today.

Please shed me a light, even you only have a candle (;-)!

Is idDataSource a uniqueidentifier ?

If yes then the error is good.

look at this example

CREATE TABLE ShowErrors(col1 varchar(10))
GO
INSERT ShowErrors(col1) VALUES(1)
INSERT ShowErrors(col1) VALUES('Allan')

select * from ShowErrors WHERE col1 = 1


-- Error: Syntax error converting the varchar value 'Allan' to a column of
data type int.(22018,245), Batch 1 Line 1


SQL Server will convert the left hand side of the equation to the datatype
of the right hand side and I believe it due to numeric precedence.



--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


" David N." <huongdat (AT) comcast (DOT) net> wrote