OpenFileDialog not working in SSIS Package

[CTB]

Hello all,

(what happened to this board? it's been a while since I've been here.
Looks like only one person answering the question that comes in every
1 or 2 months. Used to be a lot busier. Is there a better place to
ask questions?)

I've just recently moved to a Windows 7 Professional machine. We
installed the SQL Server 2005 client tools (BIDS/SSIS/SSMS) and
updated everything. All of our SSIS Packages are designed to be run
in VS/BIDS in debug mode because they require user interaction. The
first item is a Script Task that uses OpenFileDialog to prompt the
user to select a file in the folder that contains all the files that
needs to be imported (folder path is derived from file path of
selected file). On this system, the OpenFileDialog won't open/show.
Anyone have any ideas as to why? Is there any known issues about
this? Is there other components/patches that need to be downloaded/
installed?

I tried creating a brand new blank package with only a script task in
the control...flow and still nothing. MsgBox debugging shows it will
freeze on the ShowDialog() method of the object. Code is as follows:




Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
Imports System.Windows.Forms

Public Class ScriptMain


Public Sub Main()
MsgBox("Working so far!!!")

Dim pofdSelectFolder As New OpenFileDialog
MsgBox("variable declared")

'pofdSelectFolder.InitialDirectory = "\\Server\Share\"
'MsgBox("Initial Directory set")

'pofdSelectFolder.Title = "Fat the whuck?"
'MsgBox("Title set")

pofdSelectFolder.ShowDialog()
MsgBox("Yaaayyy!!! it works!!!")

Dts.TaskResult = Dts.Results.Success
End Sub

End Class





Everything works fine until I get to ".ShowDialog()". No dialog box
pops up...can't get past it to get the "Yaaayyy!!! it works!!!"
message...script task just remains yellow with no error messages
indicating something is wrong.

My products are:
MS Win 7 Pro - 6.1.7601 Service Pack 1 Build 7601
Microsoft Visual Studio 2005 - 8.0.50727.867 (vsvista.050727-8600)
Microsoft .NET Framework - 2.0.50727 SP2

Installed Edition: IDE Standard

Microsoft Visual Studio 2005 Premier Partner Edition - ENU Service
Pack 1 (KB926601)
Security Update for Microsoft Visual Studio 2005 Premier Partner
Edition - ENU (KB2251481)
SQL Server Analysis Services - Microsoft SQL Server Analysis Services
Designer - Version 9.00.5000.00
SQL Server Integration Services - Microsoft SQL Server Integration
Services Designer - Version 9.00.5000.00
SQL Server Reporting Services - Microsoft SQL Server Reporting
Services Designers - Version 9.00.5000.00
Update for Microsoft Visual Studio 2005 Premier Partner Edition - ENU
(KB932232)



For what it's worth, I keep getting the following error message that
some others get...doesn't appear to be a fix for this issue

https://skydrive.live.com/?cid=5febb0ee89579911&sc=documents&id=5FEBB0EE89579911%21557
...or...
Loading Image...
...or...
Loading Image...

My login should be an admin on this machine, so I don't know what the
issues is.

Thanks for any help anyone can provide,

CTB

[Bob Barrows]

Post by CTB
Hello all,
(what happened to this board? it's been a while since I've been here.
Looks like only one person answering the question that comes in every
1 or 2 months. Used to be a lot busier. Is there a better place to
ask questions?)

The best place might be
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/threads

While these are web forums, you can also access them through NNTP, see
http://communitybridge.codeplex.com/

Post by CTB
I've just recently moved to a Windows 7 Professional machine. We
installed the SQL Server 2005 client tools (BIDS/SSIS/SSMS) and
updated everything. All of our SSIS Packages are designed to be run
in VS/BIDS in debug mode because they require user interaction. The
first item is a Script Task that uses OpenFileDialog to prompt the
user to select a file in the folder that contains all the files that
needs to be imported (folder path is derived from file path of
selected file). On this system, the OpenFileDialog won't open/show.
Anyone have any ideas as to why? Is there any known issues about
this? Is there other components/patches that need to be downloaded/
installed?

Sorry, I've never run into this issue so I cannot answer this.

[r***@gmail.com]

I just came across this problem. The solution is to set the FileDialog::ShowHelp property to true and the dialog will be displayed.

Found the solution on this post:
http://www.aspnet-answers.com/microsoft/Powershell/31776466/openfiledialog-doesnt-work-with-framework-35.aspx

[r***@gmail.com]

I just came across this problem. The solution is to set the FileDialog::ShowHelp property to true and the dialog will be displayed.

Found the solution on this thread:
http://www.aspnet-answers.com/microsoft/Powershell/31776466/openfiledialog-doesnt-work-with-framework-35.aspx

[Bob Barrows]

Post by r***@gmail.com
I just came across this problem. The solution is to set the
FileDialog::ShowHelp property to true and the dialog will be
displayed.

http://www.aspnet-answers.com/microsoft/Powershell/31776466/openfiledialog-doesnt-work-with-framework-35.aspx

Thamks. Would you mind quoting some of the message to which you are replying
so we have some context? Thanks again.

[Ruben Murphy]

Post by r***@gmail.com

Post by r***@gmail.com

Post by CTB
Hello all,
(what happened to this board? it's been a while since I've been here.
Looks like only one person answering the question that comes in every
1 or 2 months. Used to be a lot busier. Is there a better place to
ask questions?)
I've just recently moved to a Windows 7 Professional machine. We
installed the SQL Server 2005 client tools (BIDS/SSIS/SSMS) and
updated everything. All of our SSIS Packages are designed to be run
in VS/BIDS in debug mode because they require user interaction. The
first item is a Script Task that uses OpenFileDialog to prompt the
user to select a file in the folder that contains all the files that
needs to be imported (folder path is derived from file path of
selected file). On this system, the OpenFileDialog won't open/show.
Anyone have any ideas as to why? Is there any known issues about
this? Is there other components/patches that need to be downloaded/
installed?
I tried creating a brand new blank package with only a script task in
the control...flow and still nothing. MsgBox debugging shows it will
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
Imports System.Windows.Forms
Public Class ScriptMain
Public Sub Main()
MsgBox("Working so far!!!")
Dim pofdSelectFolder As New OpenFileDialog
MsgBox("variable declared")
'pofdSelectFolder.InitialDirectory = "\\Server\Share\"
'MsgBox("Initial Directory set")
'pofdSelectFolder.Title = "Fat the whuck?"
'MsgBox("Title set")
pofdSelectFolder.ShowDialog()
MsgBox("Yaaayyy!!! it works!!!")
Dts.TaskResult = Dts.Results.Success
End Sub
End Class
Everything works fine until I get to ".ShowDialog()". No dialog box
pops up...can't get past it to get the "Yaaayyy!!! it works!!!"
message...script task just remains yellow with no error messages
indicating something is wrong.
MS Win 7 Pro - 6.1.7601 Service Pack 1 Build 7601
Microsoft Visual Studio 2005 - 8.0.50727.867 (vsvista.050727-8600)
Microsoft .NET Framework - 2.0.50727 SP2
Installed Edition: IDE Standard
Microsoft Visual Studio 2005 Premier Partner Edition - ENU Service
Pack 1 (KB926601)
Security Update for Microsoft Visual Studio 2005 Premier Partner
Edition - ENU (KB2251481)
SQL Server Analysis Services - Microsoft SQL Server Analysis Services
Designer - Version 9.00.5000.00
SQL Server Integration Services - Microsoft SQL Server Integration
Services Designer - Version 9.00.5000.00
SQL Server Reporting Services - Microsoft SQL Server Reporting
Services Designers - Version 9.00.5000.00
Update for Microsoft Visual Studio 2005 Premier Partner Edition - ENU
(KB932232)
For what it's worth, I keep getting the following error message that
some others get...doesn't appear to be a fix for this issue
https://skydrive.live.com/?cid=5febb0ee89579911&sc=documents&id=5FEBB0EE89579911%21557
...or...
https://skydrive.live.com/embedphoto.aspx/.Public/Issues/VS2005%20Admin%20Permissions%20Error.png?cid=5febb0ee89579911&sc=documents
...or...
https://skydrive.live.com/self.aspx/.Public/Issues/VS2005%20Admin%20Permissions%20Error.png?cid=5febb0ee89579911&sc=documents
My login should be an admin on this machine, so I don't know what the
issues is.
Thanks for any help anyone can provide,
CTB

I just came across this problem. The solution is to set the
FileDialog::ShowHelp property to true and the dialog will be
displayed.

http://www.aspnet-answers.com/microsoft/Powershell/31776466/openfiledialog-doesnt-work-with-framework-35.aspx
Thamks. Would you mind quoting some of the message to which you are replying
so we have some context? Thanks again.

Of course, quoted message included.

[Bob Barrows]

<snip>

Post by Ruben Murphy

Post by Bob Barrows

Post by r***@gmail.com

Post by CTB
I've just recently moved to a Windows 7 Professional machine. We
installed the SQL Server 2005 client tools (BIDS/SSIS/SSMS) and
updated everything. All of our SSIS Packages are designed to be run
in VS/BIDS in debug mode because they require user interaction.
The
first item is a Script Task that uses OpenFileDialog to prompt the
user to select a file in the folder that contains all the files that
needs to be imported (folder path is derived from file path of
selected file). On this system, the OpenFileDialog won't
open/show.
Anyone have any ideas as to why? Is there any known issues about
this? Is there other components/patches that need to be
downloaded/
installed?

<snip>

Post by Ruben Murphy

Post by Bob Barrows

Post by r***@gmail.com
I just came across this problem. The solution is to set the
FileDialog::ShowHelp property to true and the dialog will be
displayed.

http://www.aspnet-answers.com/microsoft/Powershell/31776466/openfiledialog-doesnt-work-with-framework-35.aspx

Post by Ruben Murphy

Post by Bob Barrows
Thamks. Would you mind quoting some of the message to which you are
replying so we have some context? Thanks again.

Of course, quoted message included.

lol :-)
An operative word was "some". No need to quote the whole thing ... just the
part that clarifies what you're talking about.
Anyways, that helped refresh my memory, so thanks. :-)

[Ruben Murphy]

Glad that could help :)