SSIS Export Data To MySQL
Sep 7, 2007I need to export tables to a MySQL database. I created an ODBC data source for the MySQL database however not sure how to develop a package to export SQL Server data to MySQL.
Any suggestions?
Thanks
ADVERTISEMENT
Param For MySQL Data Source In SSIS 2005
Apr 18, 2007Hi experts,
I 'm trying to get countNumber from a select statement in MySQL source. Something likes this:
select @countNumber = count(*) from tableName where condition_1 = xxx
I use ExecuteSQLTask to get the result set with result name @countNumber along with ADO.NET connection type.
I 've installed mysql-connector-net-5.0.5 cause the source is MySQL 5x.
And I got a task failed error which is described below:
[Execute SQL Task] Error: An error occurred while assigning a value to variable "new_process": "Result binding by name "@new_process" is not supported for this connection type. ".
Please help me to fix this error, thanks alot
Best reguards,
Creating SSIS Package To Extract Data From MySQL And Append To SQL 2005
Apr 26, 2007Hi guys,
I'm a newbie DBA and i'm trying to create a package that would extract data from MySQL and inserts them to a SQL 2005 Server. I'm quite new to this SSIS and would like to ask help from you to help me go through with this.
I hope you guys can help me with this.
Hoping to hear from you soon.
Thank you so much.
Kind regards,
Neil
How To Export SQL Data To XML Via SSIS
Jun 13, 2005Hi,
View 20 Replies View RelatedSSIS SQL Server-&&>Excel Data Export Error
Jun 28, 2007Hi , I am facing constant errors while trying to do a simple Export from SQl server database table to Excel File. I am unable to Do any mapping from teh table to the Excel File , if the Column Headers in teh Excel File are not present. Do you have any inputs on how to proceed with the Data Transfer, without having any headers in the Excel File. My requirement doesnt need to have Column headers in teh Excel.
Any help is appreciated!
Thanks,
Deepti
Using SSIS To Export Data From SQL 2005 To Excel 2007
Apr 3, 2008Hello,
I made a package in SSIS to copy some data from SQL server 2005 SP2 to Excel 2007. The package works fine, but generate errors. If I replace the OLE DB destination for Excel 2007 with a Excel destination for Excel 2003 then they errors don't appear. The problem is that I have to use Excel 2007 because the data contains more than 65000 records. I thought maybe it was to much date, but if I limit the amount of data with top 100 it also generate errors.
The errors are:
SSIS package "Package.dtsx" starting.
Information: 0x4004300A at Declaratiegegevens NZDF naar Excel, DTS.Pipeline: Validation phase is beginning.
Information: 0x4004300A at Declaratiegegevens NZDF naar Excel, DTS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Declaratiegegevens NZDF naar Excel, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Declaratiegegevens NZDF naar Excel, DTS.Pipeline: Pre-Execute phase is beginning.
Information: 0x4004300C at Declaratiegegevens NZDF naar Excel, DTS.Pipeline: Execute phase is beginning.
Information: 0x40043008 at Declaratiegegevens NZDF naar Excel, DTS.Pipeline: Post Execute phase is beginning.
Error: 0xC0047018 at Declaratiegegevens NZDF naar Excel, DTS.Pipeline: component "Source Declaratiegegevens uit NZDF op NED_NDFSQL01" (1) failed the post-execute phase and returned error code 0x80004002.
Error: 0xC0047018 at Declaratiegegevens NZDF naar Excel, DTS.Pipeline: component "Source Declaratiegegevens uit NZDF op NED_NDFSQL01" (1) failed the post-execute phase and returned error code 0x80004002.
Information: 0x40043009 at Declaratiegegevens NZDF naar Excel, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at Declaratiegegevens NZDF naar Excel, DTS.Pipeline: "component "Destination Excel 2007" (142)" wrote 353858 rows.
Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "Package.dtsx" finished: Failure.
I hope someone gots a answer...
Thanks in advantage!
Michaël
Export Sql Server Data To Excel Dynamically In SSIS
May 23, 2008
Hi All..
I have an issue where I'm trying to export data from Sql Server tables (or from a result set in a SP or view) into Excel Spreadsheets. Normally I would use a simple data flow to do this. However, I need to do this on-the-fly because the schema of the Sql data is not static. The table could be a different one or the result set would have column schema that is not always the same.
The constant in all of this is that the spreadsheet columns and the table (or result set) column schema is identical. It's just that the column count and column names are not defined at design time, but would need to be defined at runtime.
Going from Excel to Sql Server is simple as I used a Script Task and the SQLBulkCopy class to dynamically transfer the data. However, BOL says that it's only one way (Data to Sql Server). Basically I need the to go the opposite direction now.
I have all of the information (SQL Table server, database, schema, and name and the Excel file path and name) already set up in variables and running through a ForEach container and I can dynamically change the variable information. I just need to figure out how to dynamically map the columns, create the spreadsheet file, and load the data into the spreadsheet. I'm sure this has been tossed around before. If someone could point me in the right direction I would most grateful.
Thanks.
Lee.
SSIS Import And Export Wizard Data Sources
Dec 30, 2005I'm just beginning to use SSIS (bracing for a steep learning curve due to lack of helpful documentation) and am starting out trying use the Import and Export Wizard. On the "Choose a Data Source" page there is a dropdown for the Data Source. I see a list of possible data providers, but not one of "Microsoft OLE DB Provider for ODBC drivers," which is the one I wanted to use because I'm trying to connect to an obscure database. So I figured that I need to use ".Net Framework Data Provider for Odbc." Unfortunately, regardless of what I enter for the Connection string or the Dsn or the Driver I invariably get an error, although it's somewhat dependent on that I have entered for those three items.
Either this (when I type in a DSN)
Cannot get the supported data types from the database connection "Dsn=Terrascan_Okanogan_WA".
or this (if I enter a full connection string and a driver)
The operation could not be completed.
------------------------------
ADDITIONAL INFORMATION:
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
of this (if I enter a DSN and a driver)
Cannot get the supported data types from the database connection "Dsn=Terrascan_Okanogan_WA;Driver={SmartWare Driver}".
------------------------------
ADDITIONAL INFORMATION:
Specified cast is not valid. (System.Data)
So I have a couple questions. First, why doesn't "Microsoft OLE DB Provider for ODBC drivers" appear in the list of data sources, and secondly, when using the ".Net Framework Data Provider for Odbc" data source what inputs are expected because whatever I'm doing doesn't seem to work?
SQL Server 2012 :: Local SSIS Package Run And Export Data Except In Job
Jun 23, 2014Using server 2012 on local machine, I created an SSIS package that will execute in integrated services and Visual Studio solution but will not work when creating a job. Other solutions work well except when exporting data. The program pulls data from query and exports into .csv file. The messages I get are -
Data flow task 1:error:destination- Stage.csv failed the pre-execute phase and returned code 0xC020200E
and
Data flow task 1:error:Cannot open the datafile "pathStage.csv".
Version-
Microsoft SQL Server Management Studio11.0.3128.0
Microsoft Analysis Services Client Tools11.0.3128.0
Microsoft Data Access Components (MDAC)6.1.7601.17514
Microsoft MSXML3.0 6.0
Microsoft Internet Explorer9.11.9600.17041
Microsoft .NET Framework4.0.30319.18444
Operating System6.1.7601
SSIS Package Error : Export Data From SQL Server 2005 To Access 2003.
Oct 9, 2007
I am exporting 350 tables data from SQL Server 2005 to Access 2003.and getting the below error.
SSIS package "Package2.dtsx" starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.
Error: 0xC0202009 at Package2, Connection manager "DestinationConnectionOLEDB": SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".
Error: 0xC020801C at Data Flow Task, Destination 64 - CLIMBINGEXP [8065]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DestinationConnectionOLEDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Error: 0xC004701A at Data Flow Task, DTS.Pipeline: component "Destination 64 - CLIMBINGEXP" (8065) failed the pre-execute phase and returned error code 0xC020801C.
Any clue?
SQL Server Compact Edition Sdf As Data Source In SSIS Import And Export Wizard - Error
Jul 31, 2007
Should I be able to use a SQL Server Compact Edition sdf file as the data source for the SSIS Import and Export Wizard?
When I select the .net Framework Provider for compact Edition from the data source drop down, I get a message box with "An error occured which the SSIS Wizard was not prepared to handle. Exception has been thrown by the target of an invocation. (mscorlib) Specified method is not supported. (System.Data.SqlServerCe)"
We have a user with a sdf file that will no longer sync, so we wanted to get her data from sdf file tables into SQL Server tables quickly and easily. Since the SSIS wizard wouldn't work with the sdf data source, we copied SQL Server Mgmt Studio query results into an Excel spreadsheet via the Clipboard, them imported those records with SSIS. But we need a repeatable process in case this happens in the future.
We tried to reinitialize her merge replication subscription with SQL Server Mgmt studio, and with C# code, but none of that would work.
How many MS data provider options are available for SQL Server compact edition? I see ".Net Framework Data Provider for Microsoft SQL Server Compact Edition" in the SSIS data source drop down, but shouldn't I also see an OLE-DB Provider for SQL Server Compact Edition?
This is all on my XP workstation where I can successfully write C# code for SQL Server Compact data access with Assembly = System.Data.SqlServerCe = C:Program FilesMicrosoft Visual Studio 8Common7IDEPublicAssembliesSystem.Data.SqlServerCe.dll. So I think I have the proper tools installed.
Thanks.
SSIS From SQL2K5 To MySQL
Apr 13, 2006Hi,
We recently migrated from a SQL 2K to 2K5. We had an automatic DTS scheduled every night that would transfer data to a MySQL server on one of our client€™s machine. It worked like a charm in SQL 2K.
I am trying to figure out how I can connect to a MySQL data source using SSIS in 2K5 as I don€™t see an ODBC Destination anywhere in the Data Flow Task; and run the same transfer using 2K5.
Do I have to add a reference of some kind or does 2K5 doesn€™t support ODBC destinations?
Thanks
MySql 64 Bit Driver And SSIS
Aug 27, 2007If anyone have been able to install the MySql ODBC driver on XP 64 bit and get it to work with SSIS, PLEASE tell me how you accomplished it.
View 1 Replies View RelatedConnection To MySql In SSIS
Aug 25, 2007
I have a process that copies data from a MySql database to Sql Server. This process has worked fine on another server but is failing on a new server. I created an ODBC connection to the MySql database which works fine. In the job, it has a Connection Manager object to the MySql database which Tests successfully. The job has a Datareader source with a very simple SQL command in it. When I run the job, I get the following error:
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Error: 0xC0047062 at Data Flow Task, DataReader Source [1]: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager90.AcquireConnection(Object pTransaction)
at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper90 wrapper, Object transaction)
Error: 0xC0047017 at Data Flow Task, DTS.Pipeline: component "DataReader Source" (1) failed validation and returned error code 0x80131937.
Error: 0xC004700C at Data Flow Task, DTS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation.
It says that the Data Source Name Not Found. If this was so, how is the connection manager test succeeding?
I am running the MySql driver version 3.51.12.
Any ideas what might be causing this to fail will be greatly appreciated!
How Can I Export Foreing Key And Primary Key With SQL2005 Management Studio/Database/Tasks/Export Data Wizard.
Jan 4, 2008How can I Export Database with foreing Key and primary key.
Operation is that
SQL2005 Management Studio/Database/Tasks/Export Data
Before Version is SQL2000 we can Selected Copy Object and data between server and then Use Default Options click checked and Select Copy Index, Copy Foreing Primary key vs vs
But this options is not found in the SQL2005 Management Studio/Database/Tasks/Export Data wizard or I can't found it.
How can I export foreing Key and primary key with SQL2005 Management Studio/Database/Tasks/Export Data wizard.
Best Regards,
Athena.
MySql SSIS Hangs With ODBC Drivers
Mar 2, 2006Hi, we are writting a SQL Server Integration Services package to import data from a MySql database to a Sql Database.
We are using ODBC 3.51 Drivers to connect to the MySql Database in SSIS. The package runs perfectly in design mode. When we schedule the package to run, the package seems to hang about 1/3 of the times.
What can this be. We used to the package and ran it from a Sql Server 2005 to a Sql Server 2005 database. This setup works perfectly. When i'm doing MySql to Sql Server 2005, 1/3 of the times, it does not work.
Can anyone help me with this?
Giovan Gentile
Ayuda Media Systems
Linked Server To MYSQL Using OLEDB Provider For MYSQL Cherry
Feb 12, 2007Good Morning
Has anyone successfully used cherry's oledb provider for MYSQL to create a linked server from MS SQLserver 2005 to a Linux red hat platform running MYSQL.
I can not get it to work.
I've created a UDL which tests fine. it looks like this
[oledb]
; Everything after this line is an OLE DB initstring
Provider=OleMySql.MySqlSource.1;Persist Security Info=False;User ID=testuser;
Data Source=databridge;Location="";Mode=Read;Trace="""""""""""""""""""""""""""""";
Initial Catalog=riverford_rhdx_20060822
Can any on help me convert this to corrrect syntax for sql stored procedure
sp_addlinkedserver
I've tried this below but it does not work I just get an error saying it can not create an instance of OleMySql.MySqlSource.
I used SQL server management studio to create the linked server then just scripted this out below.
I seem to be missing the user ID, but don't know where to put it in.
EXEC master.dbo.sp_addlinkedserver @server = N'DATABRIDGE_OLEDB', @srvproduct=N'mysql', @provider=N'OleMySql.MySqlSource', @datasrc=N'databridge', @catalog=N'riverford_rhdx_20060822'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'rpc', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'rpc out', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'use remote collation', @optvalue=N'false'
Many Thanks
David Hills
In SSIS Execute SQL Task, Single-row Result From Querying Mysql Binding With A Variable
Jul 20, 2007I set up a connection to mysql using ADO.NET's ODBC Data Provider. And I'm running a simple query to return one table's maximum ID(int32 unsigned). There is no problem to achieve that.
But when I bind the result to a variable and excute task. It gives out error message: "An error occurred while assigning a value to variable "MaxAuditLogID": "Result binding by name "MaxID" is not supported for this connection type. "
I tried to change the type of variable around but with no luck.
Could anyone help with this issue? Thanks!
How To Import Data To Mysql Db?
Mar 16, 2007I need to import data to mysql,
and idea abt that?
thanks
Migrating Data From MySQL
Feb 12, 2007Hello
I am looking for a way to migrate my data from a MySQL database to a SQL2005 Express data base. All of my MySQL Schemas only have 1 or 2 tables in them so I would imagine that it isn't that hard to do. I treid just exporting it to a CSV file with the intention of just using import/export in MSSQL but in the express edition, it ain't there. Like I stated all of my schemas are only 1 or two tables none are linked in any way they are independant table and the most records any one of the tables contain is around 250. Any suggestions?
How To Migrate Data Over From MySql Into SQL Server
Sep 4, 2007Hi All,
We will replace our website which currently build in php and mysql into .net and sql server 2005. What is the best way to migrate all the user account from current database in mysql into sql server, also considering that there is different database table and fields?
Thanks in advance.
Sql, Sql Express, Access Or Mysql For Data
Mar 30, 2008If this has been discussed before i apologise as i am fairly new to the asp forum and was not sure where to search for threads.
I am upgrading to a new web plan that supports asp and i noticed that godaddy supports all of the above databases. I was curious if there are any advantages to using one db over the others as far as web is concerned?
What i am looking to do is handle guestbook, logins for registered users which would control access to certain downloads and possibly pages as well. And it was also advised that i look into using a database to store and display dynamic information in my master page to only show the updated information instead of a complete new page each time. This would save on having to manage so many pages.
So i would really appreciate any advice on the databases as i will be making my decision to go with a specific web host based on this. I would also appreciate any advice on a good web host for asp and database support.
Thank you Jeff
I'm Looking To Import Data From SQL Server Into MySQL ...
Mar 28, 2008problem is I don't have unfettered access to the MS SQL Server(7), so I need to send instructions on how to do it to a client.
After reading up a little, I figured "select view into ##tmp_table", and then dump the table, which, if I'm right, means I'll have an SQL dump that I can quite easily import into MySQL.
Problem,: What's the syntax to dump that temp table, or is there a better way to import the data into MySQL
TIA
Import Data From MySQL To SQL Server
Sep 18, 2006Hi All
I'm trying to import data from mySQL database to SQL server 2005. I installed mySQL odbc driver (3.51) and configured system DSN. However when I start SQL server import/export wizard mysql is not an option in data source dropdown.
What do I miss?
Thanks,
Vlad.
What What Is The Best Way To Transfer Data To MySQL Periodically
Aug 1, 2007Hi everyone, here is my situation and what I am hoping to accomplish.
I want some data from my msSQL to be seen on my website but I do not want a website to access the msSQL database due to performance etc (the database is not intended for website use).
Innitially I was thinking of exporting the data every 24hours to a text file that the website would access, but now I am thinking it would be better to have some data sent to a mySQL database that I have from my webhost.
I am not really sure what the best way to do this is, any help please?
thank a lot
Get Data Using Openquery() From Mysql To Sql 2005
Oct 27, 2007I'm trying to use linked server to import big amount of data(around 9 million rows) from mysql to a sql 2005 table.
I plan to create a stored procedure and use job agent to run it at off-peak time everyday. The SP is like:
.....
Truncate table sqltblA;
Insert Into sqltblA(col1, col2, col3)
Select col1, col2, col3
From OpenQuery('mysql', 'Select col1, col2, col3 From mytblB')
.....
But when I tried to CREATE the above SP from management studio, seems the sql server was trying to get all data from table mytblB and ended up with failure after several minutes hang. The error message is sth. like "running out memeory". BTW, during that several minutes hang, I can't query mytblB using mysql's tool as well. it seems to me that table got locked.
However if i try to change the returned result to 100,000 rows by changing script to
Insert Into sqltblA(col1, col2, col3)
Select col1, col2, col3
From OpenQuery('mysql', 'Select col1, col2, col3
From mytblB Limit 100000')
The SP could be created without any problem and running the SP could get the data in table sqltblA.
But that's not what I want, I need all rows instead of a certain amount of rows.
Does anyone know what's going on there when I try to CREATE that SP and any solution to it?
Plus I tried to use SSIS as well. When I'm configuring the DataReader source, which uses ADO.NET's ODBC option to connect to mysql, if its sqlcommand is "select * from mytblB" without the Limit key word, then the configuration page will hang there as well and table mytblB is not accessible by using mysql tool. I'm just sick of wasting time on that and that's why I chose to use SP istead of SSIS. But same result. :-(
How Do I Replicate Data From MySQL Into SQL-Server
Jul 23, 2005Hello group,i am relatively new to SQL-Server database, but i have lots ofexperience with DB2 and Oracle Database. One of my tasks is setting upa replication between a Mysql-Database running on Linux and one of ourSQL-Servers.How do i achieve this ?If i understand the documentation correctly you have to program thereplication mechanism for yourself or you have to use some third partytool.Could anyone please outline, how to set up the replication mechanism(pointing me to some web-site should be enough) and also tell me ifthere is any third party tool.Thanks in advance and greetings from ViennaUli
View 1 Replies View RelatedData Replication From MSSQL To MYSQL
Jul 20, 2005Hi all.I need to set a oneway replication of some data from MSSQL (running underWindows 2000 server) to MYSQL (running under Linux).Do you have some ideas to solve the problem?Thank youLuca
View 1 Replies View RelatedGetting Data Out Of Mysql Using Linked Server
Feb 27, 2007Good Morning
the available oledb providers for mysql don't seem to work with sqlserver 2005.
So whats the best way these days of exposing data from within sql server from a mysql data base.
What I wanted to do was create a linked server connection to the mysql server using either oledb or odbc, but neither seem to work.
There is a .net provider for mysql, but that won't work to create a linked server connection.
any ideas appreciated.
What I want to do is write some scheduled proceedual sql from within sql server to query some tables in mysql and update some sqlserver tables.
thanks
David Hills
Importing Data From MySql To MS SQL 2005
Feb 13, 2008
Please help - I am dealing with data transfer from multiple tables to multiple tables - what is the best practice to get this done? So far I have my connection to MySql figured out and I am using a DataReader source to get the data. What is the approriate Data Flow Transformation to pump data into three different tables in MS Sql 2005 database from three different tables in MySlq database? So far I was able to figure out how to do this for one table only...
Thanks,
Galina
Adding A MySQL Data Source
Aug 22, 2006I'm attempting to create a new GUI for an existing MySQL database I have. I would like to program this application using Visual Studio 2005 using the Visual C++ or C# language.
I'm having trouble connecting to the database though. When I attempt to add it as a data source I get the following error: "Could not retrieve schema information for table or view"
I'm using the MySQL ODBC driver version 3.51 and MySQL versoin 5.0. Visual Studio 2005 Professional Edition.
Can someone help me get this project started? How do I connect to my database?
Thanks!
Unable To Add Data From MySQL Into Text Field
Apr 17, 2007hey guys... i have some problem here... i am trying to display data out on the text field and these are the codes that i have added... i have a few pages with the same codes but onli this particular page can't work...
when the webpage first load, it will load all the username onto ListBox1... when the user choose a data from ListBox1 and click button3, it will show all the data of that particular user that the user had selected and display them on the text fields provide... but the data could not display the data... is there something wrong with my codings??
These are my coding:
Imports System.Data
Imports System.Data.SqlClient
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Label6.Text = Session("Un")
Dim connSel As New SqlConnection("data source=localhost; initial catalog=Sourcing; integrated security=true")
Dim adapSel As SqlDataAdapter
Dim mySQL As String
mySQL = "select UserName from Users "
adapSel = New SqlDataAdapter(mySQL, connSel)
connSel.Open()
Dim dsSel As New DataSet
adapSel.Fill(dsSel)
ListBox1.DataSource = dsSel
ListBox1.DataTextField = "UserName"
ListBox1.DataValueField = "UserName"
ListBox1.DataBind()
connSel.Close()
End Sub
Protected Sub Button3_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim conn As New SqlConnection("data source=localhost; initial catalog=Sourcing;" & "integrated security=true")
Dim cmd As New SqlCommand("select * from Users where UserName = '" & ListBox1.SelectedValue & "'", conn)
conn.Open()
Dim dr As SqlDataReader
dr = cmd.ExecuteReader()
Do While dr.Read()
UserTxt.Text = dr("UserName")
PwdTxt.Text = dr("Password")
BranchTxt.Text = dr("Branch")
CountryTxt.Text = dr("Country")
PriTxt.Text = dr("Priority")
Loop
dr.Close()
conn.Close()
End Sub
End Class
Converting Data From MySQL To SQL Server 2005
Jun 28, 2007Hello,
Finally making the move to ASP.NET! I've been advised that to begin with it is probably best to start using SQL Server 2005 with ASP.NET. All my sites are currently using MySQL. Can anyone advise a way for me to import all the data from a MySQL database to a SQL Server 2005 database. Apologies if this isn't directly related to ASP.NET but any help would be greatly appreciated.
Thanks