Matt you're right.

They need to send this file to a big company that

maintains their data in Mainframe. But still

I cannot produce ASCII fixed-length position based file

with different length in the...

Hi Ed,

I constructed a script and ran it.

Looks good Ed.

It's just these guys who set the requerements for file layout I think

are a bit out of their minds.

Apparently they...

Ed,

You're not a Newbie!

You know sime stuff... Ah?

Thanks fro you help.

I'll try quick SQL script right now and see if the positions in output file

is what i need.

Robert

You mean something like:

SELECT Field1+'.......'+CUSTOMER_NAME+'.......'+

But how do I force SQL to generate an output file

where for example CUSTOMER_NAME starts at position 12?

ASCII fixed-length file all organised by line number

and column. How...

Hi Loner,

You seem to know more about this stuff.

How exactly I generate a format file?

Do you mean format file for BCP?

It looks like this:

8.0

4

1       SQLCHAR       0      ...

Ed,

DTS generates fixed length file but ....

you dont' have any control

over which position the columns are in. For example,

you need your CUSTOMER_NUMBER at position (12-18).

It means column should start at...

Don't worry Jeff.

I changed my real username and password.

So OSQL. I thought it's only a utility to execute SQL from a command line.

I never thought about it as a transformation/loading...

VIEW!

I can only do it throught the VIEW now.

OK

I tried OSQL. it didn't work.

This works:

C:\Sybase\bin\>isql -Uxxx -Pxxx -Sxxxx

1>:r Script1.sql

2>go

3>:r Script2.sql

4>go

Set cn = Server.CreateObject("ADODB.Connection")

cn.Provider = "Sybase.ASEOLEDBProvider.2" 

cn.Properties("Initial Catalog").Value = "picard"

cn.Properties("Server Name") = "riscdev1"

cn.Properties("Server Port Address") = "2050"

cn.Properties("User ID") = "xxxxxxx"

cn.Properties("Password") = "xxxxxx"

----------------------------------------

this works.

Another challenge for...

Solution:

In ActiveX Task switch to Perl Scripting language

and type this, for example:

#**********************************************************************

# Perl ActiveX Script

#************************************************************************

sub Main()

{

 print "PERL WILL PRINT!";

 return 0;     # DTSTaskExecResult_Success;

}

Now to to DOS and run DTSRun command.

You should...

That's not what I want.

I want CUSTOMIZED output.

I know I can give unique names to Tasks and Steps

and then DTSRun will show

<TaskName> starting...

<TaskName> finished...

Lets' say I need to output:

"INSERT:...

SprocKing,

Right Click in Designer , Properties, Loggigng

gives you an option to log to SQL Server,Even Viewer.

But what I need is in DOS window

have output that I want,

not only default messages...

Guys!

I'm not using SQL Server Agent (Scheduler).

It's a batch file that has DTSRUN command

and that batch is being scheduled in Tivoli Workload Scheduler by IBM.

So, is there any way during...

Sometimes you need to ask a question in order to find an answer yourself.

I just generated script for all SP's and seacrhed for "RegProdType".

Easy.