DSXchange

Hi
i have used MS SQL server load stage as my target. After executing the job, only few records got loaded in it. Am getting warning as OLE DB provider error: Unspecified error. Why its so. plz help me to overcome the warning and to load all the data into DB

Thnks

chulett wrote:Don't know SQL Server but what is the data type of the target column in the actual table? (not the job) ...

Its numeric column.

Hi , I have a job in which target is SQL server database.And we are SQL server bulk stage for the target. I have two columns in source with datatype Numeric and length 15 Performing some calculations and populating to target column of length 6. And the warning in log file shows as below CustLoadHist...

chitravallivenkat wrote:could you please give the SQL statement used in that stage?

No sql statements in tht stage
Data is finely passing till the transformer that is before target stage.
am using MS SQL Server Load stage in target. the problem is i cant load into it. its throwing error.

Hi,
Am getting the following warning while running the server job.

Load: OLE DB provider error: The statement has been terminated.

Please Help me in solving this...

Thanks n advance.

data is from seq file. So in transformer i have to give any condition to retrieve the column name in which the value is present. Where is the data sourced from? If the source is a database, you may be able to do this. For sequential files, you may have to reference the metadata by position or other ...

Only in few columns data will be present. rest are null values.. I used pivot stage to merge multiple columns to a single one. In which am taking only the values and ignoring the nulls etc. i need to know in which column that data is present. i can use the If condition in transformer. but large no. ...

chulett wrote:Correct, you'd need to write a custom routine to leverage that. Plus convert all those commas to Field Marks or Value Marks or some kind of dang marks first. ...

Thank you all...I will try to write routine for that

can anyone tell me how to get positon of value in a list??

ex, A is an input having value like (1,2,3,4), i want to get the position of 2 in it...how can i implement this? Thanks in advance

Pagadrai wrote:Hi,

Did you try passing the filepath value as a string to the routine.
Or Can you please give more details about the method you are following and the error encountered?

Thanks... now its working

when i am trying to give filepath as a argument in server routine, it shows Parameter format not correct. Anyone tell me how can i pass filepath as argument??Thanks in advance

The command will execute in the DataStage project directory, if the file name is not qualified. You probably need DEL /F X:\folder1\folder2\A*.* ... Thanks all for ur support. I mentioned the filepath in the job properties where the bat file present and also where it goes to check the empty file .....

What is the command you are giving in ExecDOS ?? Are you giving absolute path ? Thank you all...del A*.*, this is the command i worte in bat file. I gave filepath as a parameter .I will give the path while runtime. Once the job ran, ExecDOS routune have to go to that path and delete the file start ...

i am trying to delete file using ExecDOS , this command searching the file in default datastage directory like C:\Ascential\DataStage\Projects\Practice1.If file is present in it , it ll be deleted. But i want to search it in given directory while runtime, (ex, c:\Folder) like this.Anyone tell me wha...

You don't need a routine, just use ExecDOS after job and issue the del command from there, which is the DOS 'delete file' command. ... Thanks.. I executed in DOS successfully.But i am in need of deleting the file depends on one input. ex.if col.A='DOS' then delete A.txt file else if col.A='Unix' th...