Yeah... I guess we strayed quite a bit. Sorry...

I've never seen that type of problem occur... If I do and I can actually fix it, I'll try to find...

keerthy.vishweshwarachar (6/24/2008)

---

Hi,

Can any one help me to copy the file from ftp server to local server using xp_cmdshell.

Note: I wanted to do this through procedure.

Simple copy command is working...

Juergen.Guenther (6/24/2008)

---

Hello.

i have the same problem with Dell Latitude D830 - unfortunatly changing the video card is no option for my laptop 🙁

Disabling the hardware acceration worked - but is...

And, THAT is why I tell folks that every...

Saroj (6/24/2008)

---

Below is the desc:-

Authors Books

Pk Author ...

balasach82 (6/12/2008)

---

I am Balaji new to this discussion. My Code is::

exec xp_cmdshell 'copy C:\templates\BALAJI1.xls C:\export\BALAJI1.xls'

insert into OPENROWSET(

'Microsoft.Jet.OLEDB.4.0',

...

Did anyone ever find an answer on this? If not, does anyone know the answer for this?

The answer is "Yes"... both can be done. Create a view in SQL Server to look at the data you want and then create a spreadsheet to use "External...

So, Bob! Just curious... did Jack's code work or what?

Is it tomorrow yet? 😉

Just teasing... did you ever get this figured out, Paul?

You...

The code you have posted is not meant to be executed by you... things like sp_cursoropen are SQL Server code that appears when SQL Server actually runs a stored proc.

This old trick using a Tally table may help... I did not modify it to match your tables... see the link in my signature if you want that 😉

--===== This...

I don't know of a direct method... but can you have MySQL export to either a Tab Delimited or CSV file? From there, it's easy to import into SQL...

Constraints are meant to protect the data.... little things like Primary Keys and Foreign keys as well as some data level constraints in columns keep people from entering garbage into...