file is missing. can you send xml file.

I have posted one more Q and the topic is in this forums - "import xml using SSIS"

please help me, if you have any idea on that.

I tried doing that. But I am not finding Excel 2007 to instal on my machine. we dont have lincensed s/w in our company.

even not able to find the free...

thanks on your reply.

But Interop is 11.0.0.0 which we used inside the package as a reference in both the environments.

I guess this is what mainly used by package for the...

Thanks on your reply

Development box

CPU Usage (Task Manager):10-20%

OS:Win XP Pro

Processor Speed:2.8GHz

RAM:2 GB

Excel Version: MS Office Excel 2003

Client box

CPU Usage (Task Manager):10-20%

OS: ...

you could make the connection dynamic (ie., can change its value (servername & DB name) at runtime).

there is a video here which tells you on changing the value dynamically...

but I do have to maintain the relation here. banking center ID to AssociateInfo.

ex: for banking center ID:14213, I have two records of Associates Info

<AssociatesInfo>

<AssociateInfo>

<FRST_NM>ANA I</FRST_NM>

<LST_NM>Kary</LST_NM>

</AssociateInfo>

<AssociateInfo>

<FRST_NM>ANA II</FRST_NM>

<LST_NM>Lou</LST_NM>

</AssociateInfo>

</AssociatesInfo>

I dont think if...