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...

If you are new to SSIS, how do you know that you need to add something to the toolbox as, presumably, you are not familiar with all of the existing...

Can you provide some sample data? If it's not ASCII, what is it?

Is the Resultset property of the Execute SQL task set to None?