I tried adding a Data Flow Task control to my BI project and got this error
when trying to rename it:

TITLE: Microsoft Visual Studio
------------------------------

Could not get value for property 'a8905386-80fc-478b-86a3-ae9f5c001815'.
Specified cast is not valid.

------------------------------
BUTTONS:

OK
------------------------------

Almost alll of the values in the Properties window have this text:
Could not get value for property 'a8905386-80fc-478b-86a3-ae9f5c001815'.
Specified cast is not valid. All the other controls in my toolbox seem to be
ok. Why is this happening and how can I fix it?

Hello Jason,

Thank you for using Microsoft MSDN newsgroup!

From your description, I understand that you tried to add a data flow
control and to the BI project and when you tried to rename it, you received
the erro rmessage "Could not get value for property
'a8905386-80fc-478b-86a3-ae9f5c001815'. Specified cast is not valid.". If
I'm off-base, please let me know.

I found similar issue is caused by that SqlServer2005DTSUser[$MachineName]
does not have proper read/write, Execute and List Folder Contents
permissions on the following folder:
C:\Program Files\Microsoft SQL Server\90\DTS\Binn directory

If the issue still occurs, please grant the "Full control" permssion to the
startup account of "SQL Server Integration Services" to above folder to
test the situation.

If the problem is not resolved at this point, it could occur if SSIS
componets are not installed properly or some components are not registered.
You may want to reinstall SSIS component via Add/Remove program to
troubleshoot the issue.

To completely remove SSIS component from registry, I would suggest you
consider msicuu2.exe. You may want to have a look at the information at
http://support.microsoft.com/?scid=kb;en-us;290301

Please let me know if it helps and I look forward to your update.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.

Yes, you understand my problem. I granted full control to the
SqlServer2005DTSUser[$MachineName] and I still had the problem. I also
uninstalled VS 2005 and reinstalled with no luck.

I am not sure what I should be doing with the Windows Installer Cleanup app.
I see an entry for Microsoft SQL Server 2005 Integration Services. Should I
remove? What will that do?

Jason



""privatenews"" wrote:

Hello Jason,

Yes, you could remove "Integration services" and "SQL 2005 tools" from
Windows installer cleanup tool after you remove them via Add/Remove
programs. This will completely remove msi related registry information from
the server. Please reinstall the componets after above steps.

If the issue still occurs, please collect the filmon and regmon log when
the issue occurs, and send them to me at petery (AT) microsoft (DOT) com

1. http://www.sysinternals.com/ntw2k/source/filemon.shtml - you plan on
using File monitor on WinNT/2K/XP. Extract it and run file monitor.
2. From the option menu, uncheck Capture events. From the Edit menu, click
Clear Display
4. Open Windows Update site and select updates you want to install
5. Enable Capture events in File monitor tool, and then start to reproduce
the issue. Once the error occurs, stop capture events.
6. From the File menu in File monitor, click Save As to save the log to a
file and then send the file to me for further analysis.

You could get regmon tool from
http://www.sysinternals.com/ntw2k/source/regmon.shtml and use similar steps
to get regmon tool.

Please feel free let's know if you have any update. Thanks.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===



This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Peter,

I removed Integration services and SQL 2005 tools after removing via
Add/Remove programs. I even unistalled VS 2005 and SQL 2005 just to be sure.
I re-installed both applications and it is still happening. Ugh!

I will move to the next plan and email you the filmon and regmon logs next.

Jason

""privatenews"" wrote:

Hello Jason,

Thank you for your update on the status of the issue and we appreciate your
time in working with us. If you get the log files, please send it to me and
and I would follow up soon.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===



This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Peter,

As I stated in my email, I am not sure why I would need this step:

"4. Open Windows Update site and select updates you want to install "

I have both programs installed (filemon/regmon) and can send logs to you
with the information you need but it is not clear to me what information you
want me to capture.
Also, can we expedite this process? I am already 4 days behind in what I
thought would be a simple SSIS package development process. Thank you again
for all your help.

Jason

""privatenews"" wrote:

Hello Jason,

Sorry for my I forgot the delate the step which is for a different thread.
You could ignore the step4 and directly go to step 5 to reproduce the issue
(try to rename the Data Flow Task to see the error) after you enable
capture events. The following is the correct steps:

1. http://www.sysinternals.com/ntw2k/source/filemon.shtml - you plan on
using File monitor on WinNT/2K/XP. Extract it and run file monitor.
2. From the option menu, uncheck Capture events. From the Edit menu, click
Clear Display
3. Enable Capture events in File monitor tool, and then start to reproduce
the issue (rename the task). Once the error occurs, stop capture events.
4. From the File menu in File monitor, click Save As to save the log to a
file and then send the file to me for further analysis.

You could get regmon tool from
http://www.sysinternals.com/ntw2k/source/regmon.shtml and use similar steps
to get regmon log

I understand this issue is urgent for you but response in newsgroup might
be laggy (48 hours response time) and I'm sorry that we are not able to
resolve the issue in a efficient manner. Please understand that urgent
issues are not recommended for the newsgroups and they are best handled
working with a dedicated Microsoft Support Engineer by contacting Microsoft
Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.

If we're not able to find clues from filemon/regmon, to find out the root
cause of this issue we may need to analyze memory dumps or use live debug,
this work has to be done by contacting Microsoft Product Support Services.
Therefore, we probably will not be able to resolve the issue through the
newsgroups.If the issue is urgent, I recommend that you open a Support
incident with Microsoft Product Customer support Services (CSS) as above.

I appreciate your understanding on this. I look forward to your update and
logs requried and I appreciate your time.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===



This posting is provided "AS IS" with no warranties, and confers no rights.

Hello Jason,

Thank you for your reply and additional information on the issue. I checked
the regmon/filemon and I did not find any "Access denied" errors. Though
there are some "not found" and "overflow" errors, they shall not relate to
this issue. For example:

8\Common7\IDE\PrivateAssemblies\Microsoft.DataTran sformationServices.Design.
dll SUCCESS Offset: 3864108 Length: 512
10322 12:08:33 AM devenv.exe:4760 OPEN C:\Program
Files\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.DataTran sformationServices.Design.
pdb NOT FOUND Options: Open Access: All
10323 12:08:33 AM devenv.exe:4760 OPEN
C:\WINDOWS\symbols\dll\Microsoft.DataTransformatio nServices.Design.pdb
NOT FOUND Options: Open Access: All
10324 12:08:33 AM devenv.exe:4760 OPEN
C:\WINDOWS\dll\Microsoft.DataTransformationService s.Design.pdb
PATH NOT FOUND Options: Open Access: All
10325 12:08:33 AM devenv.exe:4760 OPEN
C:\WINDOWS\Microsoft.DataTransformationServices.De sign.pdb NOT FOUND
Options: Open Access: All
10326 12:08:33 AM devenv.exe:4760 CLOSE C:\Program
Files\Microsoft Visual Studio

From the log I found that mcshield.exe read/open may DTS related files and
I suspect this may relate to this issue. You may try to temporarily disable
Mcafee program to test if the issue persists.

Also, from further research, this kind of issue may relate to the ODBC
drivers. I suggest that you reinstall SQL Microsoft SQL Server Native
Client from the following link:

http://www.microsoft.com/downloads/d...D60-A13C-4479-
9B91-9E8B9D835CDC&displaylang=en

In addition, you may want to re-install MDAC 2.8 included in WinXP SP2 or
Win2003 SP1

Right click %windir%\inf\mdac.inf , and click Install

Please direct it to WinXP SP2/Win2003 SP1 setup CD or folder when prompted.

Since we cannot pinpoint the root cause directly from regmon/filemon, if
above methods do not help, we may need analyze memory dump/live debug to
further troubleshoot the issue. As I mentioned, this work has to be done by
contacting Microsoft Product Support Services. If you have any questions or
concerns on this, please feel free to let's know. I appreciate your
understanding.


Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===

Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:

BCPS:
https://partner.microsoft.com/US/tec...rview/40010469

Others: https://partner.microsoft.com/US/tec...pportoverview/

If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default...rnational.aspx.

================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.