There are two ways to do this that I can see:

1) run a "prefix" job scheduled either before all the one ones or on a frequent schedule.  (How frequent depends...

There are basically two ways to do what you want to do:

1) control the position of the temporary file (use System.IO.Path.GetTempPath() or whatever to find someplace you can expect...

Well, you seemed to have found your own answer here -- and you definitely know more about OpenXML than I do <g> --

But, FWIW and for future reference for...

Hi Todd,

There are several reasons why somebody might ask you to do this. Some are technical, some are not. Some are good (I don't mean to equate "good" with "technical" btw). Some...

You absolutely can convert dates and integers, but it's important to know how the system from which you are converting treats its date of origin.  For SQL Server, that's in...

>>

Thank you for your help. It is not a big deal for me either, is just that I want to group the columns together according to its content, as you said...

To be honest, Kim, I have no idea whether the mistakes are yours or the book's.  I don't have the book (or any other book on this subject, FWIW!). 

But...

Kim -- this is my third attempt to post an answer in this thread. Excuse me for being brief this time <g>.

The individuals on the thread were telling you to...

Hi there,

On #3, don't get too fussed about the "call and parameters go in the body".  This is true of some SOAP messaging styles and not others.  The important thing...

From http://www.chriskempster.com/tipsandhints.html

>>

(this post may appear twice)

I did a little experimenting and, if I set up a scratch database with a collation of SQL_Latin1_General_Cp1_CI_AS, I don't see the difference.  I'm pretty sure...

This might have something to do with our base collations.  Mine is Latin1_General_CS_AI. What's yours?

>L<

It's probably not a bug, rather a collation issue.  That's why some people can see it and others can't (I can).  Try this (including the people who couldn't repro with...

Here you go.  As the first person who recommended this script uses the second method (from page 2 of the article), that is the method I have revised below.  Search for...

> The problem can't be permissions because i'm running the program as an administrator

That's true.  I thought you were running the task in the Task Scheduler, however, not by double-clicking...