I've actually written some C# code to dynamically create a package with a data flow and dynamic column mappings but it just doesn't feel right. For one it's not flexible....

Is it possible to create a script task that is detached from everything else and call it from anywhere I want?

I just realised that I had set the batchsize to something greater than the number of rows in the input file, hence why multiple errors were being put into the...

It turns out that I'm blind and the single error event that gets raised sends all of the errors in the ErrorDescription variable. So I just need to parse the...

I already have logging set up to redirect the errors to a flat file.

problem is only the first error is getting thrown.

As has been said before, it depends on why need the web service in the first place. IMHO you shouldn't be calling a web service that can take a while...

Yes, you can ignore the .NET 3.0 installation. It is basically .NET 2.0 plus a few extra things.

Thanks for the help everyone.

Yes, the column definitions seems to be a big problem.

I'll stick with the VB.NET code as it seems the most simple to understand (good for future...

Actually what I want to do is export all tables to separate files. E.g. Table1 goes to Table1.csv, Table2 goes to Table2.csv, etc.

I'm actually going to take it a little...

Yep, almost identical.  Thanks.

Got it, thanks to the suggestion of using charindex and substring. Oh and also a CASE.

Whoops, forgot to mention that sometimes the filed may not have 2 numbers.

So sometimes it's like: '19 & 133'

And other times is's just: '19'

I need to make it work for...

Yep, the format will always be:

number1 space ampersand space number1

I want number1 only.

Nevermind, got it.  Added the link server retrieval stuff into the SELECT list in the view and it's all working fine.

Thanks for all your help.

Sorry I dont understand what you mean.

The data I need to get comes from Server1.DB1 (e.g. employee name, address, phone) and Server2.DB2 (e.g. salary, DOB).

Where should I create the VIEW and...