DSXchange

Job Fails After 5 min from starting it and first line of Error is : [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (recv()) and above mentioned error as second line. However I am running the same procedure in SQL SERVER manually then it runs fine without any problem. I asked about ...

Hi All, One of my job is aborting from last two days and giving the error: [Microsoft][ODBC SQL Server Driver][Shared Memory] General network error. Check your network documentation. I am Executing SQL Server Procedure by using DRS Stage and the Job is taking more than two hours to complete everyday...

Hi Everyone,

What is the Reason of failing Monitoring Services Frequently?

and What we need to do to get rid off it?
Same warning :Failed to initialize Job Monitoring.

I know how to restart the monitoring services but i want to know the exact reason of failing it.

Thank.
Rajneesh.

Thanks jwiles,

I Practiced and found the answer of my Query .
Conversion should be Like Below :

StringToDecimal(<Input Column>,'2').

2 is the Precision Place in case of Decimal, but in String Format.

Thanks :D ,
Rajneesh.

Try this :-

StringToTimestamp(<input Column Name>,"%d-%mmm-%2000yy")

You will get Date as '2010-04-17 00:00:00'. I Tried it in my Project.

Thanks,
Rajneesh.

Hi All,

What is mean by rtype in Type Conversion Function
StringToDecimal(%string%,[%rtype%])??

suppose my input is sal=126540 and i need output like 126540.00

Can Anybody Explain with Example ???


Thanks,
Rajneesh.