kbnyny (4/16/2014)

---

Error msg say " The data type for input column "Copy of XML_f52e2b61-18a1"(330)" is DT_NTEXT.

When I change encoding to unicode and the data type DT_NTEXT to that this is...

Can you add it to your post as an attachment instead of embedded into the post? All I can see is a place holder and I've used 2 different computers...

kbnyny (4/16/2014)

---

Sorry Brandie, I did not make myself clear enough. I can change the data type but the problem is when I do change it to anything beside Unicode...

That's not what I asked. You said you were having problems changing the...

Your XML document may be malformed. Are you sure you have your hierarchy designed correctly?

And are you looking for a full XML document or just a fragment?

EDIT: Are you changing...

Another question. Once I finish writing up the Powershell script, how do I make it part of the SSIS package or the SQL Server Agent job?

Is it as simple as...

Thanks.

GAH.

Is this Powershell error normal?

It gives me a link for execution polices on...

Powershell will do this?

ROCK ON. I've been looking for an excuse to learn this. Thanks for the links and the reference.

I'm assuming so. The link they point to in their help document is http://www.w3.org/TR/html4/interact/forms.html.

It tells me to have...

Beyond repeating what I've told you about permissions and SQL Server Browser Service, the only other thing I can recommend is that you call your software vendor or go to...

Jeff Moden (4/16/2014)

---

Brandie Tarvin (4/16/2014)

---

I answered the OP before I fully read your post. Searching your error on Google, I found this article from TechNet. Does it help resolve your...

Does it not give you the option of entering your own server name?

If not, double-check that SQL Server Browser Service is enabled on the server (if it's a new server,...

Shawn Melton (4/16/2014)

---

If the vendor also offers secure FTP you could use SSIS to do this but would require a third party add-on or script since SSIS FTP task does...

That won't work. A file connection manager does not give me the option of using a user name and password to connect to the HTTPS server.

Thanks for the suggestion, though.