Almost got this working now:

I used a script component as a source to access the details in the data in the ADO record set.

However, one problem still remains.

Once...

I think the best thing way to set up configuration is to set a primary package configuration to point to your local SQL server.

then subsequently set up your connections in...

just reading, some of the other posts another thing that may also be worth checking is folder permissions. (i've been caught out before, be incorrect folder permission and of course...

what does the rest of the configuration table look like?

as an example, this is the value for each column in my config table for a connection:

ConfigurationFilter: Connections

ConfigureValue: Data Source=localhost;Initial Catalog=ssct_dw;Provider=SQLNCLI.1;Integrated...

have you tried opening the file from somewhere like c:\file.txt

I might be misunderstanding this, but have you configured your package configurations in SSIS to connect to SSIS directly?

To use package configurations successfully, you will need to set a connection...

P Jones (12/5/2008)

---

If your package is saved to sql server msdb rather than file system then you can make life simple and set "Rely on server security" rather than Encrypt...

hi thanks, i tried that, but SSIS is complaining that it doesn't have an Input to the derived columns.

Also another issue now I can see whats coming out a script...

found this and very very quickly skimmed over it, but it might be worth a look for you.

Extending SSIS Part 1 - Creating a Custom Data Flow Transformation Component

http://www.sqlservercentral.com/articles/SSIS/63877/

Extending SSIS...

Hi Mark, thanks for the reply.

I'll check out that video as it sounds like it might be useful.

I have resolved this though (forgot to add another post entry). Basically,...

I found a BUG!

I stumbled across this post, trying to find other examples to see if I'd missed something.

This post verifies the problem (which is dynamically setting the ServerName doesn't...

Hi all,

this is actually simplier than I thought, now i've had a little more time to look at it.

I can do it by setting a string variable at the pack...

SSIS is not based on T-SQL, so you can't use T-SQL staments in the expression editor.

I think to acheive the result you want, you will have to break...

thanks - I give this a go.

Thanks Michael - I didn't realise the sort component could do that, it's just what I need.

I'll look into the ODBC stuff, but I'm not sure if it can be...