Mitch,

What is wrong with the "SQL Command from Variable" approach?

-Jamie

With a flat file source its easy to define the format of the file (delimited, fixed width etc...) if its XML, how do you want the data outputted? An XML...

Then it seems as though the problem is in the source. Do you get the same behaviour if you execute the query in SSMS?

If so, I would check out the...

You're not doing the conversion in SSIS (currently) so how exactly is it SSIS that is making this more difficult?

-Jamie

Some links here that may help:

http://blogs.conchango.com/jamiethomson/archive/2006/02/20/2902.aspx

http://www.sqljunkies.com/WebLog/knight_reign/archive/2005/05/05/13523.aspx

-Jamie

What's the error?

-Jamie

First of all you need to get more information from the job execution. This explains how: http://wiki.sqlis.com/default.aspx/SQLISWiki/ScheduledPackages.html

-Jamie

I posed this question so I just want to pop this up here in case someone wants to answer a question.

-Jamie

David,

I still don't quite understand why you seemed to think that the purchase of ProClarity reflected badly on Analysis Services. If my interpretation of what you said is wrong then pardon me!

This is a bit...

David Grover,

Well said! I couldn't agree more! Its what you do that counts, not how you do it!

-Jamie

Hi David,

"I also looked at SQL 2005 Analysis Services, but dismissed it when I read MS had bought ProClarity and was repackaging it for release next year.  So their...

IMO the waters are a little muddied when it comes to describing what BI actually is. I tend to think of BI as just knowing what's going on in your...

Fast Load is an implementation of BULK INSERT (http://msdn2.microsoft.com/en-us/ms188365.aspx)

Hence, you may need to set various flags in order that it works. I remember coming across a similar problem onec...

Interesting stuff. It does infuriate me when I click on a help button and it takes me to something only barely related to what I really wanted. Will that ever...

Terry,

Do you have any thoughts as to how it could be "more" intuitive?

Regards