The problem has been fixed, see here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=341979&SiteID=1

Thanks you all for the reply.

But my question is to store the resaults (no record or has records with the fields values) to global varibles in Execute SQL task in DTS...

Thanks Bill.

Probably this is CSS or template inside used to generate the reports.

I have the same requirement. One book i only have is the SQL Server 2005 SSAS with MDX Solution.

I couldn't get any result too.

Anyway, thanks for sharing your exp.

Patrick

Great! It works fine! Thanks

Thanks for the article

excellect opps

nice option

I couldn't find the MsDtsSrvr.ini.xml.

Thank you anyway!

Patrick

Yes, I installed SSIS, and i am able to find DTExec.EXE in the installation folder. I have developed several packages in BIDS actually.

Thanks,

Patrick

Hi Jamie,

For sure, I installed the SSIS and i can use the BS Development Studio.

Thanks,

Patrick

Thanks for the reply. However, i couldn't find the file which's mentioned in the link above. Also, I couldn't get the error message such as '.. RPC server is unavailable'.

Patrick