When using the Fast Load option, is the Keep Identity checkbox checked or not?

When the package is done, you'll be notified with a message at the bottom.

Maybe re-installing BIDS will help?

You can check the data in hexadecimal format, so that you can ensure yourself what symbols are actually there.

Euh... wut?

Is it me and I'm going blind, but aren't the first and the second answer exactly the same?

The second and the third resultset are just swapped around (and why...

If you add IMEX=1 to the connectionstring and set the TypeGuessRows registry property for the JET provider to 0 (meaning it will scan all the rows to determine the data...

Nice question, thanks.

Both expressions seem the same to me.

I find it a good question.

You must of course be able...

I think the most efficient and maintainable option is to create a regular expression (if you know how, I certainly don't) to validate the zip code and use it in...

Boo indeed.

If you have .NET skills, you could use a script component transformation instead.

You can use ISNUMERIC there 🙂

An example:

http://msdn.microsoft.com/en-us/library/ms136114.aspx

Check the following thread about the "ORA-12560: TNS:protocol adapter error" issue:

http://forums.oracle.com/forums/thread.jspa?threadID=74240&tstart=0

Nils Gustav Stråbø (5/13/2011)

---

"-Extents can be owned by only one object"

False, since they can be a mixed extent (or even an extent that has not been allocated). Perhaps it's your...

Check this thread out:

http://social.msdn.microsoft.com/forums/en-us/sqlintegrationservices/thread/947FA27E-E31F-4108-A889-18ACEBCE9217

Phil Parkin (5/12/2011)

---

Damn right. I really feel like I'm doing valuable work when I'm chest deep in obtuse XML hierarchies.

Perhaps I should withdraw the post and take a few minutes...

I don't remember exactly how it works, but maybe you could look into the "job tokens".

http://msdn.microsoft.com/en-us/library/ms175575.aspx

I don't know if they're the solution, but you could give it a try...