Hi, how bout this?

using System;

using Microsoft.SqlServer.Dts.Runtime;

namespace RunFromClientAppCS

{

class Program

{

static void Main(string[] args)

{

string pkgLocation;

...

Lets say your dataflow is returning the following dataset with five records to the sql command statement:

ID FirstName LastName

1 Tom Smith

2 Frank Thomas

3 Fred Simpson

4 Jackie Robinson

5 Debra McMillian

You can...

Hello,

Here is the solution I used:

Basically instead of defining blank columns in my SQL statement, I was able to simply define extra fields in the flat file destination task. ...

Hello,

Thanks for your assistance. And yes I'll gladly post my solution

Strick

Yes, my source is a SQL statement. In my Note: I mentioned that I was trying to avoid putting blank colums in my SQL statement. I want the...

Great, that's exactly what I was looking for.

Thanks!

Strick

You may actually want to consider doing all this in 1 data flow task. Doing this will do it all in one pop. You wouldn't even have to...

I think if I'm understanding you correctly you have information that you want to append to the top of the file instead of at the end. I believe the...

Yep you were right the task executes successfully. Thanks. But now I have a new issue stemming from this

The execute SQL task which runs the statement exec...

Sweet thanks! I've extensively used the script compont in the control flow using vb.net, but not inside the dataflow task as a source dataflow, transformation, or destination data flow....

Also, do you know of any really good articles that talk about

using Script Task can act as a control flow component, a data flow source, a transformation, and a data...

Hmmm this is very interesting. Can you elaborate a little more on the "output to a buffer" comment you made? How would I go about doing this? ...

Great thanks! I'm going to look into the merge join. One question though, can't a comma delimited or tab delimited text file be connected to as an oledb source?...

Thanks so much, this is great! One question though. The second subset (which is the questionable subset) needs to be compared to a third subset which is a...

I actually went completely back to square 1. I went into my Add and remove programs menu, then I uninstalled everythin that said SQL Server 2005. I did...