Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Import/Export Wizard Weird Behavior in SQL Server 2008R2 Expand / Collapse
Author
Message
Posted Sunday, December 16, 2012 11:54 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, June 20, 2014 6:41 PM
Points: 88, Visits: 60
Hi All,

I saw some weird behavior of Import/Export wizard in SQL Server 2008R2. I made a video of it please check the following link,

https://docs.google.com/open?id=0B90-ZdnuCV_4V1FlRmdVZF9CT0k

Can someone will explain is am i missing something to understand or it is bug?

Thanks in Advance,
Santosh.
Post #1397103
Posted Monday, December 17, 2012 9:00 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:06 AM
Points: 1,166, Visits: 1,192
skpanuganti (12/16/2012)
I saw some weird behavior of Import/Export wizard in SQL Server 2008R2. I made a video of it please check the following link,

https://docs.google.com/open?id=0B90-ZdnuCV_4V1FlRmdVZF9CT0k

Can someone will explain is am i missing something to understand or it is bug?


Rather than asking us to download some unknown .zip file from an unknown source from an unknown person; why don't you describe the weird behavior you're describing?

Rob
Post #1397304
Posted Monday, December 17, 2012 9:57 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
Hate to say it, but this is the Internet. No way I'm opening an unknown file from an unknown source. I seriously hope nobody is dumb enough to do that.

If this is a valid issue, please explain it. You can, if need be, put images in your post and show screen shots, instead of a video.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1397333
Posted Monday, December 17, 2012 11:17 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, June 20, 2014 6:41 PM
Points: 88, Visits: 60
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.
Post #1397356
Posted Monday, December 17, 2012 11:36 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:06 AM
Points: 1,166, Visits: 1,192
skpanuganti (12/17/2012)
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.

Firstly, I'm glad you solved your issue.

Secondly, I don't think any of your responders were offended or impolite. There are just too many things (trojans, viruses, etc...) floating around the internet to open something from an unknown source. Obviously I do not know everyone on the planet (this is a fallacious argument called 'Reductio ad Absurdum'), but my point still stands. If you don't agree with me, I know a Nigerian prince who has a website offering you some money.

You are correct -- these forums are to help people. You easily can ignore my tiny contributions to these forums; but if you do not think GSquared hasn't helped hundreds/thousands of people here on SSC, then you don't visit particularly often.

Rob
Post #1397368
Posted Monday, December 17, 2012 11:50 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
Seriously? You really think it's just fine to open zip files on the internet? Ones that you don't personally know were verified clean before they were posted?

This isn't about being polite. This is about doing something incredibly ignorant.

There are literally thousands of "basic security guidelines" websites out there, and every single one of them warns against opening files that you either get through e-mail/chat, or that you download from non-secured sites.

Why not download and open a zip file? Because it can contain viruses, trojans, spyware, etc. You say it's just a video, but do I personally know you? Can I verify that you are who you claim to be? Can I verify that the file was properly scanned and cleaned before it was posted? Can I verify that the file hasn't been tampered with in-transit?

No, to all four of those questions.

Honestly, if this is your reaction to simple security basics like this, I would suggest that you go out and learn a little bit about IT before you start doing any sort of work in the world of computers.

You can choose to be offended by this. It would be chilldish of you to do so, but it's certainly one of your options. Or you can wake up, realize that you need to seriously learn IT basics, including security, if you're going to use computers at all, much less in any sort of professional capacity.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1397372
Posted Monday, December 17, 2012 7:27 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, June 20, 2014 6:41 PM
Points: 88, Visits: 60
Seriously? You really think it's just fine to open zip files on the internet? Ones that you don't personally know were verified clean before they were posted?

This isn't about being polite. This is about doing something incredibly ignorant.

There are literally thousands of "basic security guidelines" websites out there, and every single one of them warns against opening files that you either get through e-mail/chat, or that you download from non-secured sites.

Why not download and open a zip file? Because it can contain viruses, trojans, spyware, etc. You say it's just a video, but do I personally know you? Can I verify that you are who you claim to be? Can I verify that the file was properly scanned and cleaned before it was posted? Can I verify that the file hasn't been tampered with in-transit?

No, to all four of those questions.

Honestly, if this is your reaction to simple security basics like this, I would suggest that you go out and learn a little bit about IT before you start doing any sort of work in the world of computers.

You can choose to be offended by this. It would be chilldish of you to do so, but it's certainly one of your options. Or you can wake up, realize that you need to seriously learn IT basics, including security, if you're going to use computers at all, much less in any sort of professional capacity.

- GSquared, RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon


I can continue arguing with you, but i don't want to waste my time doing that. A real professional will talk about the subject rather that getting into unwanted arguments.
Post #1397513
Posted Monday, December 17, 2012 8:39 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 9:00 PM
Points: 587, Visits: 2,838
No, a real professional will understand IT security and never expect anyone else to open a zip file from an unknown source.


Post #1397524
Posted Tuesday, December 18, 2012 6:26 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
skpanuganti (12/17/2012)
Seriously? You really think it's just fine to open zip files on the internet? Ones that you don't personally know were verified clean before they were posted?

This isn't about being polite. This is about doing something incredibly ignorant.

There are literally thousands of "basic security guidelines" websites out there, and every single one of them warns against opening files that you either get through e-mail/chat, or that you download from non-secured sites.

Why not download and open a zip file? Because it can contain viruses, trojans, spyware, etc. You say it's just a video, but do I personally know you? Can I verify that you are who you claim to be? Can I verify that the file was properly scanned and cleaned before it was posted? Can I verify that the file hasn't been tampered with in-transit?

No, to all four of those questions.

Honestly, if this is your reaction to simple security basics like this, I would suggest that you go out and learn a little bit about IT before you start doing any sort of work in the world of computers.

You can choose to be offended by this. It would be chilldish of you to do so, but it's certainly one of your options. Or you can wake up, realize that you need to seriously learn IT basics, including security, if you're going to use computers at all, much less in any sort of professional capacity.

- GSquared, RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon


I can continue arguing with you, but i don't want to waste my time doing that. A real professional will talk about the subject rather that getting into unwanted arguments.


To anyone reading this besides the original poster: Based on the above, I think it's safe to assume the posted zip file contains malware, and this is a phishing attempt aimed at, most likely, some form of botnet installation.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1397752
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse