On the SQL Server side, use the profiler to watch what is happening.

Does the IBP OLEDB provider have a trace function?

Set up a log file on the dts package.

Norman Kelm

DTS...

Try playing around with SET XACT_ABORT { ON | OFF }

I had to do this when I was using a linked server to AS400 a long time ago. I can't...

Mike,

Have you tried setting the DelayValidation property on the file connection manager(s) to True?

Norman Kelm

DTS Package Search

http://www.dtspackagesearch.com/

SSIS packages must be accessed via the SMO and .Net.

The SQLDMO DTS class is only for DTS Packages. While this is valid code to run against a 2005 server it...

Is the Client Access ODBC driver installed on the server where the job is scheduled and is there a dsn of that name created?

Norman Kelm

DTS Package Search

http://www.dtspackagesearch.com/

Great examples here: http://www.sqldts.com/292.aspx

Here is code that opens a file for append

strFile = "c:\output.txt" ' e.g. c:\output.txt

' ------ END CONFIGURATION ---------

const ForAppending = 8

set objFSO = CreateObject("Scripting.FileSystemObject")

set objFile...

Hi Debra,

The technique that I have seen is to write the trailer data to a separate file and concatenate the files at the DOS level. You could also use the...

CCSID 35 would be a the connection level. Each character column in the table can have a different CCSID. Search the internet for CCSID DB2, there are many different ids.

Do...

Sorry for the delay in answering.

What is the CCSID of the column on the AS400?

What is the data type of the destination column in the SSIS package?

Norman Kelm

DTS Package Search

Hi Prasad,

Two of the ways to do this are:

Create the package in the DTS Designer and save it as VB Code. You can open the code file and integrate it...

Hi Art,

Yes, use the FileSystemObject in the ActiveXScript task.

The following articles give detailed examples:

http://www.sqldts.com/246.aspx

http://www.sqldts.com/304-2.aspx

FileSystemObject documentation is available on msdn.

Norman Kelm

DTS Package Search

http://www.dtspackagesearch.com/

Hi Gary,

I assume that there is a query in the Exec SQL Task that returns one row. Get rid of all ?

Click on the parameters button, then the Output Parameters...

Yes, that is how it should work if the error handling is configured that way.

Row(s) are probably being missed.

Direct the error output to a flat file to see the rows...

Yes that is what I meant.

Is all the data being pulled from table or are you using a query?

If you use a query you might solve the problem by using...

I see, you are using the Import Export Wizard. Sorry I missed that.

Not much you can do there.

I think it's time to jump in and create an SSIS package to...