In my case I was connecting through IP ...don't know the exact reason behind this problem yet....Any suggestions from experts out there ?

we are on the same network and when I browse for all servers...It just shows small no.of network servers....but I can connect to other servers which are not listed in...

Nope..

Sorry for that....I was in a hurry and just cipoed the error message as it is....anyway firewall on my local machine is off...

oops I am sorry but could you please edit your previous post to change the servername to XXXX...

Thats the servername and am connecting to default instance...As I have mentioned in...

This is the error I get when I connect to server with servername..

TITLE: Connect to Server

------------------------------

Cannot connect to XXXXX

------------------------------

ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to...

Did that...It shows the server name I have to connect....interesting

Is there a way I can fix that DNS issue ?

No I didn't open it in excel...But I think the problem is when the package runs for the first time it opens ..BUt If I run it second time it...

But, I was able to open the file just couple of minutes back...and I have made a small modification in the derived column transformation after the excel source ..and I...

Error: 0xC0202009 at EBSKoboUSTAXFileImport, Connection manager "Excel Connection Manager": SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available. Source:...

Thanks Elliott...I think that is the best solution.....

Thanks to Elliott and everyone who reponded.

Here is a brief description of my problem

Initially my destination(reference) table is empty... I am trying to load data from my staging table into...

Thanks it is working with result set....but I had to change my vb script a little though...

Thanks Phil for ur response....

Here is my problem...I don'y hav emuch knowledge with vb...So I am trying to add the ssis variable value during the initialization of my counter vb...