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...

If you have ten files, you can create ten dataflows and have them run in parallel OR have ten different packages and call them in parallel with a master package....

sqldriver (8/27/2014)

---

I ran into this method in an Itzik Ben-Gan article, which looks more complicated, but of course somehow manages to run a bit faster where I've tested it against...