Actually, if you bothered to look at the code, you would see that it gets SharePoint list data.

After Office 2007 was installed I found that I could not view my cube correctly in Visual Studio. I found that re-installing SQL Server SP2 fixed the problem.

Remember that SSRS comes with Report Builder which can be used to create ad-hoc reports. Although this is a smart-client application, it is kicked off from the Report Manager...

I think you are making it more complex than it needs to be. :crying:

I would create five variables in your foreach container. One takes the

SourceFolder (for your...

The file system task will use the variables from the container if you set the IsSourcePathVariable=True

Also, try using Expressions in your Varibles if you need to create a file path.

If your text file is in a regular layout, you can use the SSIS flat file connection manager to import the files content into the data flow.

If the text file...

Try

DATEADD( "hh" , TT_DETL_TO_TM_ZN_OFST , TT_DETL_POD_DTT)

Try increasing the size of the strings you are using just to ensure it is not a truncation error.

See my post SSIS: Calling SharePoint web services from the data flow which outlines how to get information from SharePoint and use it in the data flow.

Try this instead. It works for me.

DATEADD( "hh" , TT_DETL_TO_TM_ZN_OFST , TT_DETL_POD_DTT)

Simply escape the double quote using a backslash.

e.g. "my \"test\" string"

will come out as

my "test" string

I am not sure why you need to rename the zip to default.zip. Personally I would use the ForEach container to enumerate the list of files in a directory...

The Katmai release fixes this problem. However, that does not solve your problem now!

I suggest your convert everything to upper case so you can do the...

Did you call the AddRow() method on your output buffer? If not, you will not get any output from your script component.

Absolutely - one fact table and a time dimension. So if you understand that, please explain what your problem is with getting the grouping?