Thank you. Although I am quite familiar with most of the things covered here, I'm going to have a look at the nonclustered index section and its INCLUDE paragraph.

Regards,

Greg

Hi,

Thanks for the reply. I'm gonna be talking with a developer of the application and see exactly what the plans for the data are. I got a general idea (e.g....

Hi there,

Thanks for the reply. If I wanted I could easily code one in .NET and either package it as a custom component or maybe even use directly the script...

Hi,

Well, Microsoft will always do things in many different ways based on what they're trying to show/prove. For instance, when they try to show benchmarks etc. (e.g. the 1TB in...

Hi there,

This is a very interesting question that I was actually about to post... I am currently in a situation where I could either use a data flow task to...

Not sure this answers your question but replacement for isql would be osql and for dtsrun use dtexec in 2005.

Hope this helps,

Greg

I second the wrox book I use SSIS 2005 but the information is still very valuable because it walks through a whole process very well. for a more conceptual approach,...

Mark Pratt (9/1/2009)

---

I did this recently to determine if a row needed to be updated. I put a checksum column in the table using the values that could possibly...

Hi,

Thanks for the answer. Well, that might have been a possibility but not in the situation I am in unfortunately.

What I want is to give a certain number of...

Hi,

Just thought I'd post an update. I could not get this to work using a flowr so what I did is that I used a count() in xquery and set...

Hi there,

Not sure this might help you out but in a project I'm working on, we have decided to go with an MD5 hash that is computed via a script...

John Rowan (8/27/2009)

---

I see from your link that :

It must just do a basic structural validation....

Hi John,

Yes I have read about XML schema collections but thanks for the hint. I don't know if I'll be using them though since we control both ends of the...

Hi there,

Just a quick update to this post for the folks who'd be interested. I started a few quick tests to start replacing my XML source transform.

I tried to achieve...

Hi,

Well, using a data viewer, I clearly see that the rows are sent in sequence based on the order of the conditions when the data viewer makes the process halt,...