If I understand your scenario right, it is the same as I encountered recently.

I solved it by using a couple of ReportParameters, and referencing the ReporParameters in the report header.

All...

As an extra option when using large datasets: you could check out the TableDiff component from sqlbi.eu.

We have used it in a scenario where several million rows where to be...

I agree with Dinesh that you should look for package configuration, check out the BOL on this (for instance http://msdn2.microsoft.com/en-us/library/ms141132.aspx).

You might also consider using a parent package with child packages,...

It might be that you use the wrong file as the excel destination or something else, I still can't figure it out with your information.

Please post me a message with...

afaik, in the SQL Server Import and Export Wizard, when you have checked the "Save SSIS package" option, you can choose between saving on SQL Server or on File system...

Hi Jan,

If I I understand you correctly, you have an (empty) excel-template somewhere that you copy to the destination, and then fill with data from a SQL source.

You should be...

Ah, that passed my mind when writing, but it slipped away before I wrote it down.

Do you need to use unicode string for some reason, or will non-unicode do as...

This indeed is a very common problem when importing Excel files.

By default, the jet engine that is used to read the excel source, will make a guess about the datatype...

Probably there is a implicit conversion from unicode to non-unicode data types in your package , in the mentioned dataflow. I think Excel is not able to use unicode.

You...

I was a registered attendee as well, but I got an email about it yesterday.

First I thought it was a prank of some sort, but if you check the links...

Unfortunately, the Live Meeting is rescheduled to 6 february 2008 ...

My hunch is that this also means the SQL 2008 exams will be postponed to a later date. Any thoughts?

Welle written, and neat tricks, but i agree with Paul and rather use configuration file.

The use of a server alias might come in handy though for a different scenario as...