Crackberries don't stand up vs the VX6800 with touch screen, full QWERTY slide out keyboard, and support for 8GB storage card. But it is Windows Mobile, so make sure...

I think what you're looking for is:

INSERT INTO [Linked Server Name].catalog.[my_sql_table_name] (my_sql_columns)

SELECT [MS SQL SERVER columns]

FROM [Your MS SQL SERVER table]

I believe you can use a three part identifier...

I have not tried this with SQL Server 2000. However, if you are able to get it to work, please post your findings.

Thanks,

jim

Definitely 32 bit. I couldn't find a 64 bit driver.

Thanks,

jim

Make sure that you stop SQL Server Agent before you initiate the single-user mode and then restore the master from backup using SQLCMD. I've run into the same error...

Don't give up so easily, post your error messages and the kind folks on this forum will help you out!

Have you enabled remote connections?

How are you trying to connect?

What error...

Anytime, glad I could help! Have fun moving data!

To import a .csv file, you use the same steps I outlined above, but you use a Flat File source instead of an Excel source.

Good Luck!

Sorry, I'm on 2000 Pro and out of ideas. Good Luck resolving your problem!

I have mine opening with my audio card, not Windows Media Player

Start->Control Panel->Sounds and Multimedia

Audio tab

Sound Playback

Preferred device

My sound card is selected from the drop down menu.

Can you hear any "Windows" sounds?

Make sure your SQL Agent has permissions on the files and that you are providing full UNC paths to the files. \\ServerName\Folder\file.txt, not C:\file.txt

what do your logs have...

If you have the option set in SSMS and you can "listen" to music on your headphones and you have opened a new query window since you made the adjustment...

Have you tried setting up a DSN for connecting to FoxPr on the machine you are running the DTS package from. I ported over a FoxPro db to SQL...

I've found CTE's to be one of the better methods to use to report on aggregates. My code is the same as Ramesh, but utilizes a CTE, my favorite...