Thank you so much for this. I had this issue developing over time. I could mitigate it by falling back on older versions.

I know I have a legacy server where...

Test existence of data and set a variable to 1 or 0. Then add an expression to the flow line to evaluate the variable so the mail task runs only...

I did some testing.

added the reprocessing column option to the cdc source.

Performed a couple changes in DDL and DML over the tracked table.

Ran the CDC update package which failed. The...

Hello,

Great article, I would like to know more about how to handle disruptions:

- Server crash

- SQL Server instance restart

- CDC package fails half way

- CDC Package fails due to time...

My workaround is to run through a SQL Agent job with the SSIS step Execution Option set to use 32 bit runtime.

I like the article. The explanation is clear.

One subject I would like to get more info on is the remote processing of a partition. Right now, I process the...

We have a debate about partitioned tables vs the old partitioned view in SQL2008. I have a troublesome table with over 30M rows. I thought that horizontal partitioning with aligned...

Nice article, This seems better than the out of the box SCD.

I am intrigued by the comment about SQL2008 able to detect changed rows at the source. It is likely...

Hi, Did anyone tried to send this type of report to a blackberry? I have mixed success with this, it works very well with a PDA but not so well...

http://blogs.msdn.com/sqlreleaseservices/archive/2008/10/20/sql-server-2005-sp3-coming-soon.aspx

I am not sure why you find the Import and...

Hi,

I am not going to upgrade to SQL2008 before Cumulative patch #2 which MS said will fix a show stopper bug I found when testing SQL2008 RTM.

I am glad I...

delphigao (8/22/2008)

---

How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET --- http://support.microsoft.com/kb/316934/en-us%5B/url%5D%5B/quote%5D

This link is broken

I have never found a way to replace data in an existing Excel file. The standard behavior is to append data. The only workaround is to have excel.exe on the...

Great article, this may solve the problem I had with this code that would have been considerably faster than Coalesce.

-- create list to pivot hist data

SELECT @DistList =

COALESCE(@DistList +...