Sure, it's just another source.

I would be careful of the data based on how it is being generated into that file, and provide yourself safeguards against importing the same...

If that is the only problem you are experiencing, maybe reload toolbox from "Choose items..."

By the way, non-profs can get donated software at TechSoup.org - certainly worth a look!

This is a SQL Server forum so you might need to look elsewhere for freebie db recommendations. MySQL perhaps?

if you ever had the Column Names thing checked, and later unchecked it, I'd replace the component with a new one from the toolbox and make sure to not check...

oh, goodness, that's a biggie. We actually scrapped our web reports for this very reason once it became an enormous task to validate new BI deliverables against old reports...

I went with the FMTONLY ON to display "dummy select" high up in sp, set FMTONLY OFF and have SET NOCOUNT ON in the OLEDB source.

Wow, lots of stumbling around...

Yes, 2005. Plenty of good stuff to try - thanks!!

ah, you got me, Phil - it IS selecting from a temp table. Well, shoot, makes perfect sense that SSIS cannot divine that from thin air.

Do...

I also cannot get any columns out and the sp has no parameters so shouldn't be any setup I'm neglecting.

I'm baffled.

martin.walter (6/17/2013)

---

Help! Can you point me too some resources that will help me to work out how to identify the source and transformations on data used by a report....

we have the concept of SourceSystemKey to identify where a record came from. that plus the business key of the table is all we need.

We have DimSourceSystem that we...

It looks like an error occurred simply because I see an On Error task firing.

take a look at the Event Handler tab to see what might be lurking under On...

have you looked on the progress tab for the 'red and white bubbles' that show errors? When things get stuck like that, and do not turn red, there are...

we started doing incremental fact table loads using row version and like it a lot.

I do have a log table that identifies source (we host so have mult source servers),...