Hi,

Seeking help on automating the restoring of dts visual basic file into sql server as dts package.

I am looking for a solution where in a vb/vb.net code will accept the .bas file as input parameter and restore the dts package in sql server. If anyone has ever worked on such a thing please let me know.

Thanks,

Dishant Sharma:)

You cannot do this once the dts has been stored as vb. You lose some package display information which cannot be recreated.