Hi All,

For anyone who's interested, the fix seems to be to develop your SSIS packages from a (virtual) XP machine. Sad.

Cheers,

-m

Hi Andy,

Great intro article on SSIS! I've been working with it for over two years, but had never tried anything similar to your "data probe" technique. It makes...

bilx10 (10/26/2008)

---

I know my data very well and also that ADO in excel doesn't handle columns with mixed data. A cell with numeric data will be taken as numeric...

David (10/24/2008)

---

From what I've seen, importing data from excel can be very hazardous so I avoid it whenever possible. The import process will interpret your data type by sampling the...

Hey Again,

I'm out of the office today, but I'll try to post my code tomorrow.

Cheers,

-Matthew

>>My point was to take away the "IN" clause and use a join or like some one else pointed out use "exists".

I hate to be a "me too" kinda person,...

Hi All,

Great article, I've been using the MDB / linked table method in very limited circumstances for a few users for some time now, and it's worked well. I...

[OT]

What would have been really cool (instead of the image of the DVD box from the movie Witness)?

An image of the *game* The Witness from Infocom.

I really want to thank Sean McCown for this article. I've been the only SQL DBA at my small company for about 5 years. When we first got...

I have to admit, I'm a disciple of  Erland Sommarskog's teachings, that's why I was leaning toward #3 in the first place.  I admit that it's partially because of familiarity...

Hi All,

Thanks for your input!  I'm going with #3 because we already have some UDFs written here to work with this method.

 

Cheers,

 

-m

Hey JR,

Thanks for your reply!  I'm not sure this speaks to my question, however.  I did find a post online that has answered my question though:

http://www.mcse.ms/message279800.html

This states that a...

Hey All,

We've got an active/passive SQL 2000 cluster whose principal function is to connect to two Web servers on IIS 6 running ColdFusion MX.  Our CF consultant is insistent about using...

What about DTS packages?  I've had developers add columns and forget to tell me, then they wonder why things aren't working correctly when we push to production.  Maddening.

Cheers,

-m