Desperately need some help! DTS Packages

  • 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.

  • [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