This isn't exactly the same as the file open dialog box but it might do the trick.

 DIM FileName

 FileName = InputBox("Enter file to open:", "File Open")

You can re-use your connection with the execute statement. I normally create and open my connection then populate a sql query string and do a oCN.Execute sqlstring

hope this helps.

There are also a series of "sys" tables in MSDB that you could check against.

Jonathan,

I think you are on the right path about the security. I just tried your code on my local box and a server. As long as the user has permissions...

Jonathan,

Don't know if this will help you but...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vsfctcreateobject.asp

Binesh,

Here is another site you might find interesting.

http://www.knowledgestorm.com/sol_summary_52136.asp

Excellent article and the timing couldn't have been better! I am in the process of checking into these exact issues! Keep up the good work.

In the properties of the transformation task on the last Tab "Options" there is an option under SQL Server to use a Fast Load which is the same as a...

Also check the Fast Load option in the package - if it is checked it is doing a Bulk copy insert.