You can use Environmental variable. The environmental variable will point to the Test.xml when you are into Test environment. When you are into production, your environment variable will point to...

Correcting at the source is most logical thing.

But, on the other hand you can validate your flat file before loading data into database. You load the good data into table....

May be you can query the separate column and store it in a variable. Add that variable in the Derived column as 31st column.

You can use either of the approach to solve this:

1. Use a For each Loop container to load the text files and then move them to archive or delete them.

2....

The solution is applicable to 32-bit machine.

To successfully use the ACE driver for 64-bit machine there are few things which I would like to clarify.

1. If you want to use...

How do you want to pass the data to web service? Row by Row or in a batch or the entire data at once. Do you expect to return anything...

You can use the Get External Data feature of Excel to do this. I do not know your exact requirement but the simple way to do this is to use...

If you could share your design of SSIS that might be helpful to resolve this. A different approach that you can try is SSIS: How to load multiple excel files...

To read range from Excel in SSIS you can refer this:

SSIS: Read single cell values in excel using RANGE name

You can try the solution listed here.

SSIS: How to load multiple excel files into multiple SQL tables?

When you are saying the flat files are in decrypted. do you mean to say the contents/data in the file is in encrypted form or just the flat files are...

This should help you to solve this. Let me know if you had any issue dealing with this.

SSIS: How to load multiple excel files into multiple SQL tables?

SSIS: How to...

This is what you can do the solve this.

1. Add a Conditional Split Task

2. in the Conditional Split Task editor window drag the My_Date window to order/outputname row.

3. In the...

Try this

declare @janflag as varchar(56)

declare @febflag as varchar(56)

BEGIN

set @janflag ='y'

set @febflag ='y' --[ SELECT TOP 1 febfl FROM saupdate ]

<<ALLL your udpate statements here>>

End

You can use following:

RIGHT([Business Unit],6)