Hi, I am not clear on your context here. CDC runs on a database where the data is being monitored for changes. How does this relate to your "destination "?

Change Data Capture (CDC) is a SQL job that crawls the sql server transaction log looking for changes. When a change is read it writes an entry to its...

I can add that SSIS is extendable. Thus it is possible to create in .NET your very own data source component for the data flow task to adapt to...

Just to note, you dont really need the GROUP BY clause in this example. The "SELECT MAX(WeekDay)" part is not really an aggregation on the previous columns listed. But it...

It would be nice to post create tables statements with sample data to see how your data is structured. What I am seeing / reading described is a final front...

That is interesting and thanks for sharing. This is equivalent to the UNION ALL operator but not the UNION operator. I suppose that you can take the query, wrap it...

Data conversions are a norm in the ETL world. Overall SSIS handles them great. The OP did the right thing by doing the conversion in the data source adapter with...

Hi, by using the Lookup transform, you will be only inserting rows that had no match.

So to do this in the Lookup transformation editor> general ...

Specify how to handle...

What language setting are you using? For example:

SELECT CAST('25/08/14' as datetime)

SELECT CAST('08/25/14' as datetime)

Can give you different results based on your language setting for the server.

SSIS can be rather quirky. Did you initially not do the conversion in the select query within the data source? And then changed it after realising you need to? That...

The way I read it your error is within SSIS. So let us see if you can use Excel as a dataflow destination. Right click your project > properties >...

I am wondering if you could not eliminate the nested looping by only using the one loop to iterate through the dates and then somehow build an expression pertaining to...

ChrisM makes a good point as a numeric column will not give the expected results...

Either the column is a char/varchar or will have to be cast at select time because...

Just to note,

I was recently having a similar issue. The test database I was working on gets restored from back up periodically from another machine. So that breaks the...

Hi, it does not appear the SCD component will do the job here. So this relates back to an earlier post on doing the updates, inserts programatically with execute t-sql...