The issue was the anitvirus software, it was blocking some ports. Uninstalled it, and SSRS is working like a champ now. thanks!

That worked and gave me the expected results. Thank you very much!

Yes, that worked, thank you so much!

I'm manually executing the SSIS via a .cmd file using dtexec.

Where in package properties, do I set run In 64bit = false?

Thank you very much! Really appreciate it.

some other records also come in w/o a pipe as the first character, so I don't want to strip off the first character if its not a pipe.

Wow! That is awesome, Thank you very much. Works perfectly.

Getting closer:

Using

SELECT

ID,

[Description] =...

Unfortunately, my boss wants me to do this at the database level. The problem is, I won't know how many rows I'll get. So how do i concatenate row description...

Whats the visibility setting?

Please provide create statement of the table structure, and some sample data of what exactly it is you're trying to do.

Thanks!

I was not able to fix the issue. The workaround I put in place is time based. So at a certain, I have a Move-IT task (Third party tool to...

I set this up with execute process task.

Basically, All I'm trying to do is merge all the data from Stage to TEST on ServerA.

Please Help..