0

I have an SSIS job that queries Active Directory and saves user account records into our database. It uses a Script Component to execute the required LDAP queries, and loads the user account values into variables defined in the Output Buffer which lives in the Script Component. Once processed, I take the results from the Output Buffer and use an OLE DB Destination Editor to map the values into a table.

Currently, I am loading the XML into a "Unicode string [DT_WSTR]" variable, but it has a maximum upper limit of 4000 characters. As such, I cannot process XML larger than 4000 characters (yet)...but I want to.

I'm still new to SSIS...and I have tried various online examples to no avail.

How can I parse XML larger than 4000 characters into something the Output Buffer can use and the OLE DB Destination Editor understands?

Improve this question
2
  • You could implement this in a tool that doesn't have this limit, i.e. Powershell, VBScript. Are you simply dumping the XML output into a column in a table or are you shredding it before it goes into a table? This link has a powershell script to load SQL Server with SPN's. Users should just be a different AD query: mssqltips.com/sqlservertip/3167/… Commented Mar 20, 2014 at 2:04
  • All the other fields are easy. The 2 fields I transform into XML are the Manager and DirectReports. And...Manager will probably not exceed the 4000 character limit. However, DirectReports is a list of UserAccount nodes which "could" easily exceed the 4000 character limit. Commented Mar 21, 2014 at 11:49
Related questions
0
Loading an XML file into a dataset using SSIS
1
Load XML Using SSIS
2
SSIS 2008 - import xml file contents into sql server
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.