Let's see if it is really the snapshot isolation level, or just your DTC configuration.

Create a second ExecuteSQL task in the package and set the package to require transaction as...

Look at the osql and isql command line utilities.

Just watch out for performance problems. If you are doing all of your filtering after you get the recordset, you will not see any additional performance problems, but if...

It already looks like somewhere you are using ISNULL or COALESCE to convert your NULLS to "Other". Do that before your filter criteria is applied and include the "Other"...

I guess I do not understand. You need the date, but you need it returned in a way that nobody can figure out what the date actually is.

I do...

I think what you are saying is you have a table with some fields including a date field. You want to return records based on the date, but do...

Not directly, but you have a couple of options.

First, if you want to literally do what you are suggesting, you could create your own SQL job to do this. ...

It's not even important that a table fit into memory, the UNION ALL still has to be pasted together. If I remember the behavior correctly, it needs to collect...

I don't have a sample set I can work with to reproduce what you are talking about, but I would guess it is the UNION ALL of each of these...

You should narrow down your replication needs first. An understanding of how much data there is overall, how many changes there will be to this data, the performance of...

XML Files, batch import, different names, picked up from an FTP site.

SSIS will do all of this and allow you to schedule the job from the server to make it...

Well, probably not great documents, but it should get you through it.

http://sqljunkies.com/WebLog/knight_reign/archive/2006/01/05/17769.aspx

http://mohansmindstorms.spaces.live.com/Blog/cns!69AE1BEA50F1D0E7!213.entry

Start the job, close the popup window, right-click on the job and view history. The history builds as the job runs, so if you keep hitting refresh, or have...

Well, you could do it the same way you did the old one, but I wouldn't. Why don't you want to shell out to run it?

My first response would...

I'm not sure where I ended up calling it an asynchronous trigger, but apparently I am not the only one. Here is a really simple sample of using service...