Resolved but not happy:angry:

from the command line I have to use the /conf[iguration] switch to specify the location of the config file which will then override the location specified in...

OK, update.

opening the dtsx in notepad on the deployed version shows the dtsconfig path as being the full path of my laptop (the development machine). When I change...

Nice one Phil,

Worked a treat. I am up against it today but I will post a full solution later to help others.

Obiron

Thanks Phil, That was a useful lesson.

Unfortunately I can't see how to assign the value to a variable without using a script. I have tried sending the output...

Staging tables?

What is this - SQL7? 😛

I have thought of a solution to the variable pass through - which is a horrible workaround...

Write the value that I want to pass through to a table. Take...

The other option to consider is Triggers on the source table that fire a replication script. How is the source table updated (e.g. Bulk load or data import from...

@OPC

Sorry for the delay in answering. It was running against the OLEDB datasource (SQL server 2005).

I eventually fudged it by creating the SELECT statement as a view in the...

@anthony.

Do you mean change the FlatFileConnection on each loop (i.e. 10 FFCs and choose each one dynamically) or do you mean one FFC and change it's source in...

Thanks opc.

Each file is different but the load process is the same: reset the validto date, then load the new data and default the valid to date to the end...

The short answer is yes 😀

Are the files going into the same table, if so is there any need to identify which file or folder they came from. If...

Welcome to the world of pain that is EAV tables. Entity-Attribute-Value seems like a neat way to get round storing properties of entities until you try to retrieve the...

@opc

That sounds like exactly what i am looking for. I have written the usp now but will have a play with that in my dev system.

As company S1 has offices in UK,US and IN. how is SQL supposed to know that you want the US office instead of one of the others.

Unless you specify an...

I'll start by replying to my own post.

When making the leap from RDBMS to OOP it is generally a good place to start to think of a row of data...