i have a vb application connected to an sqlserver database. I created a dts package that reads data from an excel document and inserts it into a table. The package worked just fine when i created it a couple of weeks ago, i tested it well for a few days.
When i tried to run the package today, nothing happened! The package is saved in VB and i stepped through it - no error messages but no data was inserted. What is wrong? It's like VB doesn't read the code at all, cause when i removed the excel document i still didn't receive an error message.
Somebody please help me, getting desperate here!!!!