Not working with a lot of data here, but I appreciate the 2nd solution. Always nice to have that in your back pocket 🙂

kramaswamy (7/12/2011)

---

Something like this maybe? Adapted to fit your needs of course, but I think this should work.

DECLARE @Message VARCHAR(MAX)

DECLARE @ResultsTable TABLE

(

ID INT IDENTITY PRIMARY KEY,

[Message] VARCHAR(MAX)

)

INSERT INTO @ResultsTable ([Message])

VALUES...

Ahh, you are right, was missing a character 🙂

My issue now is, other users running it can not connect to the Target SQL Server Database.

Are credentials stored in the package?