With 2005 SSIS i am not sure, you can with 2008, you would just include them like you normally would. Use a Script task and include them...

sqlbi (9/20/2010)

---

can you provide the solution, basically the incoming field has

0.0

25.0

and i want to replace it with NULL

...

What is the datatype of the column that throws the error in problem 1 ?

Checksums in the page header will check that the data has not been corrupeted by the i/o system.

I would be worried about your SQL express databases becoming peridoically corrupted, ...

yes you can do this by using a derived column transformation.

You may out of luck then sorry, dettaching a suspect database can be one of worst things to...

So was the database corrupted, then you dettached it?

Do you have any good backups?

it sounds like you have made your mind up and FAQ deserves to be in a seperate database for the reasons you have listed.

The main con i can see is...

The compatibilty level does not change the version of the database, it changes the sort of commands that can be issued against the database. Every DB attached to 2008...

DECLARE @currentBillAt int

SELECT @currentBillAt = SUM(bill_at) FROM chg_item where batch_id = 9785

PRINT @currentBillAt

I have heard this before, that the order of the table placement in the join affects the...

no it isn't

it worth noting that peer-to-peer trans replication is only available on Enterprise edition.

How large is this database that you are migrating?

while the stepped approach sounds good, you may find it...

can you post the actual query that you ran, as well as the table structres and actual execution plan?

declare @SearchString varchar(100)

set @SearchString = '*411221211*222'

select charindex('*',@SearchString,CHARINDEX('*',@SearchString,1)+1)