this is what i used when i came across the problem

http://msdn.microsoft.com/en-us/library/ms179296.aspx

specifically,

You can use TRY…CATCH to handle errors that occur during compilation or statement-level recompilation

by executing the error-generating...

i created custom code like so:

Public Shared Function formatDivision(Num1 as double,Num2 as double) as object

if isnothing(Num2) or Num2 = 0 then

formatDivision= 0

elseif isnothing(Num1) or Num1 = 0 then

formatDivision= 0

else

formatDivision=...

it seems that the ISDATE function doesn't support those data types by design.

https://connect.microsoft.com/sql/feedback/ViewFeedback.aspx?FeedbackID=327335

i got that link from here: http://dhaneenja.blogspot.com/2010/11/isdate-function-doesnt-validate-date.html

select 123456 * 0.01

i've finally got my package working.

i used the Script Task item. Had a few problems but solved them in the end.

i'm sure it would have worked with the Console App...

I've learnt something today. Gails...

i thought that perhaps the code in the Console App wasn't working even though it worked when set up as a standard Project, so i ran the Console App manually...

sure:

it runs a Stored Procedure to get back a set of data.

it then cycles through that set of data, opening a Web Service and passing the data through one row...

thanks for the advice.

i've followed the steps from this link, to create a consoleapp

http://averagecoder.net/passing-arguments-to-your-vbnet-console-application.htm

within the SSIS package, i've added the Execute Process Task and added the full pathway to the...

select right('0000' + convert(varchar(3),@seedval), 4)

convert the @seedval to varchar(3) maybe?

or

select * from (

select firstname + ' ' + surname as name from tblEmployee

)y

where y.name like '%john%'

select id,firstname + ' ' + surname as custName from tblemployee

order by custName desc

works for me

glad to have helped.

would this work also ?

begin try

declare @sql nchar(1000) = 'select * from sdfad'

EXEC sp_executesql @sql

end try

begin catch

select ERROR_MESSAGE()

end catch

to add to my first comment, you will need to follow the example that follows, from the same website:

USE AdventureWorks2008R2;

GO

-- Verify that the stored procedure does not already exist.

IF OBJECT_ID...