krishnaprasad14 (1/31/2012)

---

Thank you for the reply. But here we are not deleteing existed records in UNMATCH table.

[For example, today we got 3 records into Unmatch obkect and tomorrow may be...

Koen Verbeeck (1/30/2012)

---

Use an Execute SQL Task to create a backup of the database.

Use another...

I'm afraid that I don't 100% understand what you are doing. But as you are operating on a single server, I would be tempted to do the whole thing in...

So is it the case that you only ever want to insert new data and that you are not worried about updates?

Is the PK ID an identity column? Just wondering...

Or maybe you...

There's probably a faster way, but this works I think:

select convert(varchar(11), cast('1978-01-25 00:00:00.000' as datetime), 13)

You can set the TablesList property via an Expression.

Try this:

use AdventureWorks2008R2 ;

GO

select avg(salesytd) avgSalesYTD,

a.PostalCode

from Sales.SalesPerson s

join Person.Person p on s.BusinessEntityID = p.BusinessEntityID

join Person.Address a on a.AddressID...

My pleasure - thank you for the feedback.

You need a logical OR on those precedence constraints.

Have a read here[/url] for examples.

Ah, this gives the dodgy result:

select @x Dec, @y Float, cast(@y as numeric(28,15)) casted

So looks like it may be cast as float and then back to numeric in STR()

Thanks Jeff

I checked that BOL entry out this morning, then tried stuff like this:

declare @x decimal(28,15) = 98.43075

declare @y float

set @y = @x

select @x Dec, @y Float

in the expectation...

Also, is there any external configuration going on? If so, merely searching the packages is not enough, you'll also need to look in the config files/areas.

--edit: fix typo

This might not be an enjoyable task.

Where are the packages currently stored? If they're in the file system, you might be able to do some sort of wildcard text search...

jasonmorris (1/20/2012)

---

Phil,

Thanks for that.

I forgot to mention that the variable is declared as DECIMAL(28,15) so I am surprised it causes a rounding issue.

I've never come across this issue before and...