Executing a DTS package in VB. -- sql server dts

GlennHaworth
10/31/2003 10:47:17 AM

Hi,

I've created a DTS package that reads data from a source text file and
then a task inserts that data into a table within a SQL server 2k
database. Now the name of the source will change daily, so I've
written a little program in VB that changes the data source property of
the source file connection and the SourceObjectName property of the
data pump.

Every time I execute the package I receive the following error: -

Failed

Error: -2147467259

Source: Microsoft Data Transformation Services Flat File
Rowset Provider

Description: Error opening datafile: The device is not ready.

Also, i'm running the VB app on my pc with the SQL server database and
package being on a separate box.

Thanks

Glenn.

--

Peter Scott
10/31/2003 3:59:30 PM

Hi

I took your advice and used dtsrun and it works.

thanks.

Peter

[quoted text, click to view]

sql server dts : Executing a DTS package in VB.