XML Config is always better as when u r deploying ur packages u can edit the values and deploy it

If no other way to skip then you should use script component as source

I think using SCD component will also do the job.

try it out if you don't get it jus shoot out an email to me. @ emailsv@gmail.com

Priya: Just trying to get...

Well as far as my understanding goes using ssis will always help us b'coz ssis uses some of the resources which are not allocated to sql server 2005 and finally...

It is always better if we build and install using the deployment utility but even the way u did also works

so not a problem.

I assume that if the user is incoming record he is active otherwise he is inactive

well then in the flow add a derived column transformation and update it in...

I Use XMl Config which is simple

Using Sql to do the job will try to commit all the rows at a single so it'll block the server for a few minutes and if there are...

you can skip the header row that shouldn't be a problem but skipping a last row is difficult

probably you can try to delete the footer using the script task...

Can you post the table structures creation script (please include the current indexes creation script also)

As i've observed there are too many joins

I would suggest why not try breaking up...

Use Transaction Isolation Levels

If that doesn't work then seperate them into two seperate tasks

In execute Sql Task options

Set the followng options

Result Set: Single Row

In the parameter mapping tab

map the result set to a variable

The variable will be assigned with the number...

try this

(DT_DATE)(SUBSTRING(DT,5,2) + "-" + SUBSTRING(DT,7,2) + "-" + SUBSTRING(DT,1,4))

it worked for me

As long as all the excel files have the same structure these files can be imported using a for each loop. If not it is not possible.

So please check the...

Rightclick on the database..Select option to detach the database..

move the file to D Drive

Attach it back