It's a add on tool for SSIS. BIDSHelper. It highlights pink if that particular connection manager or variable has an expression.

THANKS YOU EVRY1

My Approach

select cast(cast(123456 as decimal(10,2))*0.01 as decimal(10,2))

Is there a simple way to do this?

0

Thanks chris!

Thanks Perry! That was useful information.

Thanks Viiki and Don I got my answers. This is just for my theory purpose.

in col2 I have values

col2

-----

+

00100

230

-0.1

ch

when i do a select

select case when ISNUMERIC(col2) = 1 then col2 from table1

result set

col2

----

+

00100

230

-0.1

NULL

then i perform the update

update table1

set col1 = CASE WHEN...

i'm still getting the error.

small correction

col1 is data type decimal(5,2)

col2 is varchar of max

Hi all,

Sorry for the late reply. I finally got the issue resolved.

this is the solution

SQLCMD -S Server_1 -d Database1 -Q "dbo.StoredProc"

I forgot to use the switches

i'm not running the command in a job.....just testing it in the ssms...once it works fine then i'll run it in the job

I'm still not getting it....

EXECUTE master..xp_cmdshell 'sqlcmd -Q"exec server1.database1.sample_test"'

error:

HResult 0x2, Level 16, State 1

Named Pipes Provider: Could not open a connection to SQL Server [2].

Sqlcmd: Error: Microsoft SQL Server...

I used it but still no result

My code:

EXECUTE master..xp_cmdshell

'sqlcmd server1 database1 -Q"exec dbo.storedprocedure" -E'

Output:

Sqlcmd: 'CLTDVSQLApp1\DVAPPINST1': Unknown Option. Enter '-?' for help.

NULL

Thanks guys for your replies!

I tried using the code jessie gave.... and i get the following output

My code:

EXECUTE master..xp_cmdshell

'osql server1 database1 -Q"exec dbo.storedprocedure" -E'

Output:

Microsoft (R) SQL Server Command...