Some that I'd like to add are: embedded code editor, allow the option to show/hide headers/footers for subreports and package an updated ReportViewer control with each new version of...

If SQL is prohibited you can use the Slowly Changing Dimension transformation in SSIS to update your table. This works best on smaller tables. The wizard should walk you...

Evil Kraig F (8/25/2011)

Jeff Moden (8/24/2011)

Evil Kraig F (8/22/2011)

The problem...

Are you trying to wrap the values in xmlSummary with "<?xml version=\"1.0\" encoding=\"utf-8\"?><Report>" and "</Report>"? You are getting an error is because {1} is not a format string -...

You could do the below, but I highly recommend using MERGE instead.

IF EXISTS (SELECT 1 FROM tbldata WITH (NOLOCK) WHERE Id=@Id)

BEGIN

...

What are you trying to do with this line:

Dts.Variables["Validation_XML"].Value = string.Format("<?xml version=\"1.0\" encoding=\"utf-8\"?><Report>{0}{1}</Report>", xmlSummary);

You are probably getting the error because {1} is not a valid format string.

Mwise

You could add a return value or output of the record count in the execute sql task, store that return value in a variable and then check that the value...

I think what you may need to do is to move your stored procedure call to an Execute SQL task. You can get output and return variables from that...

Here's an example using a Script component in the data flow task to do custom splits: [/url]. Can you see if that helps?

MWise

If you do decide to go with an exam prep book, most come with a cd containing test software. Plus my Ms Press book came with an eval version...

Check your table definitions - st_ppl and st_cd will need to have the same columns in the same order. Otherwise, don't use * in your insert...select statement. Instead...

I'm with you on this one. I think the article should be fixed...

Can the startup offer stock options or a performance bonus? How badly would $12K impact your lifestyle and household budget? Or can you wait longer at your job...

I believe that the query is incorrect and need to have the database filter (AND S.database_id=DB_ID()) added to it. I ran the query both with and without and ended...

I wasn't post-jacking. I was sharing my experience and advice directly in response to the original poster (MaricopaJoe) concerning his issues with a data driven subscription. Granted his...