Add a data conversion flow task between your source and destination.

Use this to change the First Name column to (or from) a unicode string in order to be able to...

thx for the details - its gonna make for an interesting period ahead. What I use currently is SSRS 2005 for our more std reports, and those in the the...

I thought the excel services in MOSS were only available in the 2007 version and not 2003? The reason I ask is that I wanted to have online pivot tables...

LOL - toooooo many late nights reading forums... 😉

Still, I read in BOL that you have little control over the page format when rendering to Excel. Bummer.

Currently the reports are distributed via subscriptions, with the "render format" set as Excel. There is no manual export of the report as this is controlled by the report manager...

I didn't know that the export functionality used an excel template. Where can I find this template then?

SenthilKumar...

Once you have a unique identifier the process is relatively easy to complete.

There are two easy methods that you can use.

The first way is to add a Lookup and...

Without any unique identifiers / indexes in your table this will be very slow and inefficient.

Why doesn't your table have any? Why dont you add some when the data...

What does the following expression return?

Fields!ManagementScore.Value + Fields!EcoliScore.Value

As stevefromoz says, remove parts of the eqn and check the evaluated result.

You can do this is SSIS in two steps...

1. Use a merge transform (as you mentioned above)
2. Use a SORT transform, and sort the data on ContractID, making sure you check the...

Try reversing the statement

= IIF((Fields!Hazard.Value <19 AND Fields!Hazard.Value >76)

AND Fields!Complience.Value >11,"OOH OOH","Excellent" )

to see if that gives...

I have used the following when updating new records in our data warehouse (good tutorial)

http://www.sqlis.com/311.aspx

Works very well and does not load all the records into memory at runtime.

From what I can remember of the top of my head, having the BIDS available is an option that you choose on the install. However, with the express edition, there SSIS...

If the identical databases are both SQL Server, you could use the tansfer SQL Objects task in SSIS.

In this task you can choose options of which tables, constraints etc.

You can...

Not sure whether I have the worng end of the stick here , but would it not be easier to import the data using...