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?

This is difficult to answer without seeing sample before-and-after data, but it sounds like a merge join might give you the results you need.

Accepted 🙂

In future, you could consider building your packages entirely in code. Then you would get the review features you desire, but it adds a significant layer of complexity to...

Not sure - try it and see what happens!

For testing purpose, I usually just do a "SELECT TOP 5 * ..." as my datasource - makes things fast.

Phil

My question was an honest one - as you're only new here, how am I supposed to make any assessment of your experience and knowledge? If I treated everyone like...

Good practice dictates that you should name your target fields:

insert into t_RowCount(f1, f2) ....

Other than that, looks like it should work.

If you mean: "How do I get back to design mode?" the answer is...

Your BLOB field on SQL Server will come into SSIS as data type text stream [DT_TEXT] and that is what it will remain through the pipeline, before it is output...

Nice sample code, cheers Tim.