Fix table and column names as needed:

SELECT uz.*

FROM User_Zips uz

LEFT JOIN Zip z ON uz.zip_code = z.zip_code

WHERE ...

ashley.wardell (5/28/2012)

---

Hi all

I have a list of file i want to Bulk insert using the Bulk Insert command.

I also have an XML format file for the data.

I want to...

Correct.

Is the format of the spreadsheet the same for each district manager? If so, the simplest way to handle the...

You could try using an OLE DB Source instead of a DataReader source. Or you could try a different Oracle driver.

I have to ask though, why can't you change the...

That means the mail server accepted it from Database Mail. You'll need to check with the email server admin to see why the email delivery process ended inside the mail...

That is a derivation based on the query you're sending. The Oracle driver is reading that a Unicode string of length 4000 will be returned from the query. You'll need...

You should be fine.

EDIT: forgot to...

In your delete trigger this will retrieve the name of the...

Use this as an opportunity to learn a new technique, you won't be sorry 😉

Your XSD file should probably be crafted by hand. Some tools (SSMS included) can reverse-engineer an XSD based on an XML file however it is only a "best guess", i.e....

Try using the SQLCLR to implement web requests. There is no practical limit within .NET (2GB string) for response sizes.

Please do not cross-post. It just fragments replies and wastes people's time. Direct all replies here:

http://www.sqlservercentral.com/Forums/Topic1307785-364-1.aspx

I would use a For Loop Container (FLC) to poll for data in Oracle using an Execute SQL Task and then sleep for n-seconds in between tries.

Press Ctrl+K+D to reformat the XML into something more readable.

Look into DT_NTEXT.

Integration Services 2005 Data Types