Thanks Phil, I've been looking for a resource like that...lol

• This reply was modified 4 years, 5 months ago by  dndaughtery.

Multi tenant didnt work due to business contract rules. We only have 3 clients. I do have a question though. Would using the other enviroment in the SQL agaent job...

Ok, thanks Phil.

Not sure if i read it correctly but look into STRING_AGG or STRING_SPLIT

I think its on my side. My SSMS crashes and restarts. As of now we dont have src control where im at. We're in the process of setting it up.

I figured it out. I changed Varchar(Max) in my code to Varchar(5000)

Thanks Phil, that Got'r Dun.

I'm saving the value in an ssis variable and the only date datatype is Datetime. I tried setting it as string and have the same issue.

I created an expression for Argument and that worked

Tried setting

Still getting error:

[Execute Process Task] Error: In Executing "C:\Users\DaughteryDa\AppData\Local\Programs\Python\Python38-32\python.exe" "C:\Users\DaughteryDa\Documents\My Received Files\teststring.py Whats" at "", The process exit code was "2"...

Also, I'm using SQL Server 2014.

Answered my own question. You cant do it that way. Also, you could use an expression task to replace placeholders in a query as long as the max length of...

Phil: not sure yet......Hey ya'll watch this...lol

Oh, ok thanks

Figured out to do it. I passed the XML in as a parameter

EXEC sp_ExecuteSQL @Dynamic_Insert, N'@XMLResponse XML', @XMLResponse = @XMLResponse