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.

Can you just use UNC paths?

Yes, though you may have to script it.

What will the files contain?

stricknyn (5/26/2009)

---

Hello all,

This seems pretty straight forward but I can't figure out why it's happening for the life of me. I have a package which has a script task....

If this is something that you are running regularly, the export wizard doesn't give you what you want. I suspect that the package validation is giving you problems.

One possible way...