We do it like this:

Dim oFS

Dim gFile

Dim sFile

Dim oFolder

Set oFS = CreateObject("Scripting.FileSystemObject")

 ' Instatiate the Bulk Load object

 Set objXMLBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.3.0")

objXMLBL.ConnectionString = "provider=SQLOLEDB.1;data source=(local);database=your database name;integrated security=SSPI"

 objXMLBL.KeepIdentity = False

 objXMLBL.CheckConstraints =True

 objXMLBL.SchemaGen =...

You could also try something like this,

INSERT INTO TABLENAME(COLUMN LIST)

SELECT * FROM OPENROWSET('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};

DefaultDir=Path to File Here;','SELECT * FROM File Name Here ')

If this is...

Congrats Frank,

With all the posts you've put out I wasn't sure you had time for that 🙂

Four boys of my own (youngest being 10) and I can agree the time...

Carl,

Here is a example from the Microsoft VBScript site that uses the Timer function. With a little modification it might do the trick for you.

The following example uses the Timer...

I haven't found anything yet that prevents execution of packages other than the password options. I would be very interested if someone does have a simple solution to this also.

Good...

Another option would be to use an ActiveX transform. In the transform use a Lookup query to validate the Brochure Code. Have an Error Function using an ADO connection to...

Here is a sample of how to do it (I hope it fits your needs).

FUNCTION MAIN() 'This would be the start of your function

DIM oPkg

DIM stpRecipient

 Set oPkg = DTSGlobalVariables.Parent

 'CREATE A...

This site has an example of passing Global Variables between packages - I use this method a good bit myself.

http://www.sqldts.com/default.aspx?215

Take a look at this site.

http://www.sqldts.com/default.aspx?225

If you don't have access to VB and it is an ActiveX Script you can use the MsgBox to display values at given points.

If these are the only files in that folder I would setup a Global Variable to hold the path to the directory and then use the FileSystemObject to read in...

Tiago,

I did miss a ")" in the sample - sorry bout that.

Try this,

 IF IsNull(DTSSource("Fld1")) = cBool(True) THEN 

            DTSDestination("Fld1") = "  "

 ELSE

            DTSDestination("Fld1") =...

Ramesh,

There is also a handy little tool available from http://www.sqldts.com called DTSBackup 2000, and the price is just right

Soumil,

There is some information concerning string lengths at http://www.sqldts.com that should help you.

Ritesh,

The DTS wizard is copying (or at least trying to :angry the logins along with the tables. I would create a new DTS package...