I have a script transform object that is creating XML to be inserted into a SQL 2005 database.
It seems only an N_TEXT can be inserted, but N_TEXT is read-only in the script task. The only way I've found to make this work is to have the script transform produce the XML into a DT_STR(8000) string, then convert that to N_TEXT in a Data Conversion task so it can be inserted.
Now I have a problem in that my XML has exceeded the 8000 byte DT_STR data type. Is there another way to do this
Jay
How to create XML documents over 8000 bytes?
Hot Topic
- Online Data Transform
- Get the Report Model Fields of a particular report?
- Flat Files Containing Dates
- VS 2005/SQL Reporting Services/storedprocedure tmp table problem
- SQL Server
- Installing the SQL server 2005 beta tools problem
- Properties affected by Expressions
- SSIS Conditional Flow?
- ReportingService2005.CreateReport() warning...
- "Prediction steps" has no effect for "Microsoft Time Series" algorithm
SQL Server
- Service Broker neophyte question: conversation_id and conversation handle
- Is there a way to set a variable in a data flow from a SQL statement (like in control flow)
- Periodic backup issues..
- Conditional Container
- where is sql management studio?
- OLE DB Source parameters ignored when subquery?
- How can I create more instances of the Analysis services server?
- SQL Server does not exist or access denied
- Inside a project you lose the control??
- How to Create a Mailing Label Report
How to create XML documents over 8000 bytes?
Fran-1980
The DT_NTEXT can be manipulated in the script task, you just have to work at it a bit. You can't just say Row.Text = "Hello", you have to say Row.Text.AddBlobData(ASCII.GetBytes("Hello")).
Jay
Clinton Cherry