Hi All,

Not sure why you guys are getting offended to unzip a simple .avi file. Anyways i thought of instead of uploading series of screen shots or writing long story it would better to capture video and upload it. Ok, here comes the issue, when i open the Import/Export wizard by rt. click on the database->Tasks->Import Data. From flat file to SQL Server, it is getting imported successfully. But if i open Import/Export wizard through Run->dtswizard, and selecting appropriate Source (Flat File) & Destination (SQL Server 2008), the job is failing.

After several analyses/self investigation for the root cause of the issue, i found the answer to my problem. In first case it is getting successfully imported because it is opening the right Import/Export wizard. Where as in the second case when i typed "DTSWIZARD" in the "RUN", it is opening the Import/Export wizard (of 2005 which was not uninstalled/removed properly).

I believe, this forum is genuinely for the people who wants to share their experiences/knowledge so that everyone will get benefited out of it. Don't get everybody wrong just as you know everyone on this planet or at least you could have said even some polite manner.

Thanks.