DSXchange

What about WSMQ.MSGID field? Are you using this field from Source and moving it to target in DTS?

Use this

TimestampFromDateTime(StringToDate(lnk_Date.Date,"%mm/%dd/%yyyy"),"00:00:00")

Use TimestampFromDateTime(ink_InputDate,"00:00:00")

I installed IIS 8.5 and IIS 8.7 on XP Pro. SP3 and both are working fine... so it seems that you CAN install on XP Pro

Hi Sahana,
You should get the empno not present in emp_2 table by using this query. Nothing wrong in sql.
What is your requirement?

Yes Suma.
It is ok to leave the length value as empty for Varchar field.

Please follow these steps:

1.Open your dsx file using any text editor like notepad++
2. Click Edit and change EOL Conversion to Windows Format.
3. Save your dsx.

Try importing it and it will work.

Do this. 1. Read Oracle source. 2. Use Copy stage to split the rows in Two links as St_Dt and Ed_Dt. 3. Use Remove Duplicate Stage. Sort and Partition on ID and Sort only on St_Dt with Ascending and keep First Row. 4. Use Remove Duplicate Stage. Sort and Partition on ID and Sort only on Ed_Dt with A...

Will use all the nodes mentioned in config file

Can you please detail input and desired output with example?

Please open this page and search for Setting up a C++ compiler

You installed C++ compiler on your 64-bit OS but you are pointing to 32-bit path in system variables for LIB and INCLUDE INCLUDE=d:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\INCLUDE;c:\Program Files (x86) \Microsoft SDKs\Windows\v7.0A\include; LIB=d:\Program Files (x86)\Microsoft Visual St...

Its XP Pro 32 bit and compiler is Express Edition.

I installed IIS 8.7 on XP Pro. VM with MS VC++ 2010 with these settings in Syatem Variables:

INCLUDE=C:\Program Files\Microsoft SDKs\Windows\v7.0A\Include
LIB=C:\Program Files\Microsoft SDKs\Windows\v7.0A\Lib

My 8.7 installation is working absolutely fine.

Yes.. you can use LIKE condition in Filter