For a start, try using single quotes around your literals ...

--edit:

You may first want to create an sp to help. Something like:

Create procedure [dbo].[s_ExecutePackage]

@FilePath varchar(1000) ,

@Filename ...

bc (5/28/2009)

---

My two cents would be to use the TSQL. I've never tested the ssis Aggregate transform, but would be surprised if it outperformed sql server (of course it...

Yuk, I am amazed that anyone would provide you with a file of this quality.

Is it true that your field delimiter is a space? But then that there is also...

sachinvinod2k (5/28/2009)

---

I can add derived columns but there are so many such values and so its tough to change all of them. do you know how to use conditional split...

Maybe add a couple of derived columns, cSex and cDOB (or whatever) which are set correctly and use these.

If there's not enough flexibility in there, a script component could easily...

Does the SQL Agent user have permissions to access the files?

Delay validation should be set to True, not False, if the source file does not exist until run-time.

You could approach this a different way. Set up a hard-coded connection to,...

You have made a statement without asking any questions!

Please describe what the package does and at what stage it hangs.

Or you could use OpenRowset to do it directly from T-SQL.

How does this accommodate the dynamic file-name requirement?

Sounds like you want to stream out an OleDbDataReader to a text file. I'm no VB.NET guru, but that is certainly possible. You may have some formatting issues, but in...

OK, we're getting there.

So, sounds like we need to get your dataset into a data source and feed that data source into a script component.

The script component will read the...

This looks like a T-SQL question to me - if so, this is the wrong forum. But as you're new here, that's OK 🙂

The error message actually tells you the...

I did not write my question very clearly, my apologies.

What I meant was, if record 1 in your dataset requires a file to be created called \\AB01\03\ZXY.csv, where does the...

Ahhh, makes sense.