Unfortunately the ISNULL in DTS uses vbScript not SQL so the use should be like this

IF ISNULL(DTSSourceColumnName) THEN

        DTSDestinationColumn = " "

ELSE

        DTSDestinationColumn = DTSSourceColumn

END IF

Hope this helps!

Try this:

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

           DTSDestination("Fld1") = "  "

ELSE

           DTSDestination("Fld1") = DTSSource("Fld1")

END IF

Ray, you could try something like this.

 sOutString = Day(Now)  & Hour(NOW)   & Minute(Now)  & Second(Now)

and then append sOutString as part of the file name

I always try to use the SET oRecordset = oConnection.Execute(strSQL) - seems to give me less headaches.

Marcelo,

Can you run the DTS package directly without receiving an error?

I created a proc that accepts one input parameter and returns one output parameter. I created two Global Parameters (one for input and one for output - I could have...

Matt,

From the Output parameters tab select the "Create Global Variables" option. This will let you choose the type of output expected (IE single value, recordset...).

Hope this helps

Simon,

If you are running on XP take a look at the thread on this site entitled "XP SP2 screwing up DTS transform on Text field" If that doesn't help...

Jay,

Do both the SourceShare and WorkingDir contain a fully qualified path and filename?

Try changing this line from True to False

objBL.SGDropTables = True (False)

If you are running it on your local SQL server then use this (local) for the datasource. If you have the option I would install SQLXML 3.0 on your machine...

Try this:

'*************

'** Changed **

'*************

'Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")

'**************

'** NEW Line **

'**************

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

'*************

'** Changed **

'*************

'objBL.ConnectionString = "provider=SQLOLEDB.1;datasource=JMRSQLBI;database=MyDatabase;uid=test;pwd=test"

'**************

'** NEW Line **

'**************

objBL.ConnectionString = "provider=SQLOLEDB.1;datasource=JMRSQLBI;database=MyDatabase;integrated security=SSPI"

'***************

'** NEW Lines **

'***************

 objBL.KeepIdentity = False

 objBL.CheckConstraints =True

 objBL.SchemaGen =...

James,

Does the text file get generated anywhere on the server? Can you find the file?

Jean-Marie,

I have done a little with the XML import so I don't know how much I can help - could you post some of the code so I can look...

Robert,

Try wrapping each Bit field with CINT - sString = CINT(Output field)