I've installed SQL Server Express and I need to import data into my new database. From searching around forums I read that DTSWizard is the way to go but it did not come with my install of SQL Server Express. One post said to install version with SP1 and it would be included. I tried this and it is still missing. What do I need to install to get the wizard? Do I need the toolkit? Kind of hard to use the database without the ability to import data.
View 27 RepliesHey, i'm trying to use the dtswizard.exe program in MS SQL Server Express 2005 to move a database from one computer on my home network to another.- Both SQL servers are using Windows Authentication. -I've turned off all firewalls-I've done all the Surface Area Config stuff and enabled both types of remote connections But i'm still getting a "Login Failed for user 'BASEMENT/Guest'. (Microsoft SQL Native Client)" error. Any ideas? Thanks!
View 9 Replies View RelatedCan someone try and explain to me how a sql query can run fine and return data, yet when I try to run it in dtswizard, while the "preview" view shows the data, actually running it returns zero rows?
This is on SQL2005 express and since I can't get dtsrun or dtexec to work, I'm using auto-it to simulate my actually stepping through the process. Very kludgy, but "when all you've got is a hammer...."
Hi Folks,
I've been looking through these pages at posts regarding the installation and use of the DTSWizard for importing/exporting files to/from SQL Server Express.
Lots of good, if sometimes contradictory, advice.
I had SSEE installed on my previous PC and (once I was told where to look for it!) also had the use of the dts wizard which made working with SSEE a breeze.
Unfortunately, that PC is no longer with us care of a lightning strike (yes, I have surge protection, no I forgot to unplug the modem...).
I've installed SQL Server Express with Advanced Features SP1 on the new PC and lo and behold - no DTS Wizard!
I've also tried installing the ToolKit and still no wizard.
I know it is supposed to be installed to the following folder:
"C:Program FilesMicrosoft SQL Server90DTSBinn"
However, despite repeated uninstalls/installs my folder structure is:
"C:Program FilesMicrosoft SQL Server90Binn"
Note, no "DTS" folder and no DTSWizard!
Could someone from MS please confirm whether this item is still available (somewhere) in the downloads for SQL Server Express and if so, how the heck can I install it please?
If it isn't available this has to be a huge shoot-yourself-in-the-foot gotcha!
When importing data from an xls file, only first column of first row is returned??? Am I missing something???
View 5 Replies View RelatedI have installed SP2 of Sql Express, installed the tools, but I cannot find the Import/Export tool (called DTSWizard.exe) is located at "C:Program FilesMicrosoft SQL Server90DTSBinnDTSWizard.exe".
View 1 Replies View RelatedI've installed SQL Express SP1 on a Windows 2003 server and I'm trying to get a new MySQL datasource to be recognized in the DTSWizard. A MySQL database needs to be moved over to a MS SQL server due to software requirements (which weren't looked at before the site was created). I've installed the ODBC Connector/MySQL software and created the System DSN (named "MySQL DB Import) in the Administrative Tools/Data Sources (ODBC) tool. When I start up the DTS wizard for SQL Express however, I do not get my new data source in the selection options for data sources. I am following the instructions on this page: http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/mysql.mspx#ERJAE What am I missing?
View 2 Replies View RelatedI am using dtswizard to export my db but it doesn't export triggers and all stored procedures. Am I doing anything wrong or is there a better way to do an exact copy of my DB? I am not able to use backup/restore because my db is on a server to which I don't have admin-right, and I have to pay my hoster to create a backup and email me. TIAThomas
View 8 Replies View Related