February 2, 2008 at 8:31 pm
I created a VB file from the Import Data Wizard in SQL Server 2k Enterprise Manager, and I need to be able to use this VB code inside an application written in Visual Basic 2005. Everytime I try to include this VB file in my VB 2005 project, I get the following error:
interface 'DTS.OleDBProperties' cannot be indexed because it has no default property
Does this mean that VB 2005 cannot run this file at all? The DTS objects are unrecognized?
Please advise.
February 5, 2008 at 8:36 am
[font="Arial Black"]Hello,
From the error message I would suspect that DTS is using the Ole data functionality to attempt to access the file. It's not finding a default index or key field in the data file definition.
Not knowing what you table looks like or contains, I would recommend if it's possible, to add a indexable row id field to the file. Like a identity field in SQL.
Hope this helps.
Regards,
Terry
[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply