|
I'm fairly sure that's not true, otherwise why would there be a separate download for the legacy DTS runtime? SSIS is effectively the next version of DTS (in development and Beta it was still called DTS and the process is called MsDtsServer.exe), but is not fully compatible with 2000's DTS.
Yes, if targetting SQL Server 2000 and optionally 2005, use DTS. Otherwise use SSIS.
SQL Server 2005 Express Edition doesn't have SSIS. That's only included in Standard and Enterprise Editions (and of course Developer Edition which is Enterprise with a restricted licence, the capability to run on client Windows operating systems, and autoshrink turned on). DTS was also not present in MSDE 2000.
|
|
|
|
|
Mike Dimmick wrote: I'm fairly sure that's not true, otherwise why would there be a separate download for the legacy DTS runtime?
It is a rebranded DTS. As you pointed out they rebranded it for SQL Server 2005 half way through the development cycle - hence there are references to DTS in the code.
Mike Dimmick wrote: SQL Server 2005 Express Edition doesn't have SSIS. That's only included in Standard and Enterprise Editions (and of course Developer Edition which is Enterprise with a restricted licence, the capability to run on client Windows operating systems, and autoshrink turned on). DTS was also not present in MSDE 2000.
True. I made an assumption that it was one of the full server or developer products that was being used.
|
|
|
|
|
HI all,
my application is to read a access dtbase tables which has the same format of columns. but it gives an update statement Syntax error. please help
OleDbConnection con = new OleDbConnection();
OleDbDataAdapter da = new OleDbDataAdapter();
OleDbCommand selcom = new OleDbCommand();
OleDbCommand upcom = new OleDbCommand();
DataSet ds = new DataSet();
private void button1_Click(object sender, EventArgs e)
{
string path = txtSelectLoc.Text;
processTables(path);
//UpdateMethod(path, "GRO");
}
void processTables(string path)
{
DataTable dt = new DataTable();
dt = sqlConnection().Tables[0];
foreach (DataRow dr in dt.Rows)
{
UpdateMethod(path,"WWA");
}
}
DataSet sqlConnection()
{
SqlCommand sqlSelect = new SqlCommand();
SqlConnection SQLcon = new SqlConnection("data source=Ruwandi;initial catalog=MIS;user id=sa");
SqlDataAdapter SQLda = new SqlDataAdapter();
sqlSelect.CommandText= "Select Alias from mfLocation where Alias<>''";
sqlSelect.Connection=SQLcon;
SQLda.SelectCommand = sqlSelect;
SQLda.Fill(ds);
return ds;
//dataGridView1.DataSource = ds.Tables[0];
}
private void UpdateMethod(string path,string tbName)
{
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path +
";Jet OLEDB:Database Password=sanuja";
DataTable dt = SelectMethod(tbName).Tables[0];
upcom.Connection = con;
con.Open();
int x = 0;
foreach (DataRow dr in dt.Rows)
{
x = x + 1;
string str = dr["CATEGORY"].ToString();
dr.AcceptChanges();
upcom.CommandText = "update CON_"+ tbName +" set BGT_APR=0,BGT_MAY=0,BGT_JUN=0,BGT_JUL=0,BGT_AUG=0,BGT_SEP=0,BGT_OCT=0,BGT_NOV=0,BGT_DEC=0,BGT_JAN=0,BGT_FEB=0,BGT_MAR=0,BUDGETED=0,BUDGET_PES=0," +
"NET_APR=0,NET_MAY=0,NET_JUN=0,NET_JUL=0,NET_AUG=0,NET_SEP=0,NET_OCT=0,NET_NOV=0,NET_DEC=0,NET_JAN=0,NET_FEB=0,NET_MAR=0," +
"LYNET_APR=" + dr["NET_APR"] + ",LYNET_MAY=" + dr["NET_MAY"] + ",LYNET_JUN=" + dr["NET_JUN"] + ",LYNET_JUL=" + dr["NET_JUL"] + ",LYNET_AUG=" + dr["NET_AUG"] + ",LYNET_SEP=" + dr["NET_SEP"] + ",LYNET_OCT=" + dr["NET_OCT"] + ",LYNET_NOV=" + dr["NET_NOV"] + ",LYNET_DEC=" + dr["NET_DEC"] + ",LYNET_JAN=" + dr["NET_JAN"] + ",LYNET_FEB=" + dr["NET_FEB"] + ",LYNET_MAR=" + dr["NET_MAR"] + "," +
"ADJ_APR=0,ADJ_MAY=0,ADJ_JUN=0,ADJ_JUL=0,ADJ_AUG=0,ADJ_SEP=0,ADJ_OCT=0,ADJ_NOV=0,ADJ_DEC=0,ADJ_JAN=0,ADJ_FEB=0,ADJ_MAR=0," +
"LYADJ_APR=" + dr["ADJ_APR"] + ",LYADJ_MAY=" + dr["ADJ_MAY"] + ",LYADJ_JUN=" + dr["ADJ_JUN"] + ",LYADJ_JUL=" + dr["ADJ_JUL"] + ",LYADJ_AUG=" + dr["ADJ_AUG"] + ",LYADJ_SEP=" + dr["ADJ_SEP"] + ",LYADJ_OCT=" + dr["ADJ_OCT"] + ",LYADJ_NOV=" + dr["ADJ_NOV"] + ",LYADJ_DEC=" + dr["ADJ_DEC"] + ",LYADJ_JAN=" + dr["ADJ_JAN"] + ",LYADJ_FEB=" + dr["ADJ_FEB"] + ",LYADJ_MAR=" + dr["ADJ_MAR"] +
" where CATEGORY=\'" + str + "\'";
da.UpdateCommand = upcom;
upcom.ExecuteNonQuery();
}
dt.AcceptChanges();
dataGridView1.DataSource = dt;
}
DataSet SelectMethod(string tbName)
{
selcom.CommandText = "select * from CON_"+tbName;
selcom.Connection = con;
da.SelectCommand = selcom;
da.Fill(ds);
return ds;
}
private void butSelectLoc_Click(object sender, EventArgs e)
{
DialogResult result = openFileDialog1.ShowDialog();
if (result == DialogResult.OK)
{
string path = openFileDialog1.FileName;
txtSelectLoc.Text = path;
}
}
regards
ruwandi
rkherath
|
|
|
|
|
|
hi,
thanks. I will do that.
regards
ruwandi
rkherath
|
|
|
|
|
Hi, ALL!
in MySQL I could execute this "show tables" and i got a list of tables in database. can I get a list of tables in a MS SQL database and how?
thanx!
--
"Success is simple. Do what's right, the right way, at the right time."
best regards,
tradakad
|
|
|
|
|
select * from INFORMATION_SCHEMA.TABLES
Gautham
|
|
|
|
|
Yep, i mean exactly this thing..
thank you, bro!
--
"Success is simple. Do what's right, the right way, at the right time."
best regards,
tradakad
|
|
|
|
|
welcome anytime bro!
Gautham
|
|
|
|
|
I am working on Windows mobile platform using C#. I am using Merge Replication to do synchronization between SQL Server2000 and SQL Server 2005 Mobile edition and t is working fine.
The Server Tables are copied in the Client DB. It works fine with one way, i.e., server pushing data to Client Database (in PDA), but when i tried to update from PDA database, server keeps over writting PDA databse.
The requirement is that before adding our PDA database as subscriber,there are some tables with same name and structure as in Server with some records. After that i added it as subscriber and sycnchronized.The tables in the server are going to overrite the records in PDA.My requirement is to not overrite the records and it should update the existing table.Is it possible....Can Any one Help meeeeeeeeeeeee plzzzzzzzzzz.
Ayyappa Konakalla
|
|
|
|
|
Hi i want to know exact hour and minute of two times...,
i used this query:
"SELECT '2007-03-14 12:50:55.070' as login,'2007-03-14 13:00:55.070' as logout,DATEDIFF(hour, '2007-03-14 12:50:55.070', '2007-03-14 13:00:55.070') AS hours,DATEDIFF(minute, '2007-03-14 12:50:55.070', '2007-03-14 13:00:55.070') AS minut"
But i am getting value as 1 hour 10 minute like...,
But actual output is 10 minute only...,
And suppose the second time will be in some other day means...,
the logout time will be '2007-03-14 13:00:55.070' as logout
for this also i want to calculate exact hours and minutes like that any query is there in sqlserver???
Advance thanks...
Magi
|
|
|
|
|
take the difference in minutes only and then convert the minutes into hours & minutes
SELECT '2007-03-14 12:50:55.070' as login,'2007-03-14 13:00:55.070' as logout,
cast(DATEDIFF(minute, '2007-03-14 12:50:55.070', '2007-03-14 14:00:55.070') / 60 as int) AS h,
DATEDIFF(minute, '2007-03-14 12:50:55.070', '2007-03-14 14:00:55.070') -
cast((DATEDIFF(minute, '2007-03-14 12:50:55.070', '2007-03-14 14:00:55.070') / 60) as int) * 60 AS m
Regards
KP
|
|
|
|
|
Oh god sorry man really its working cool...,
once again sorry man..........,
Thank u frd
Magi
|
|
|
|
|
|
hi,
I am having a Access table which does not have a primary key.
i wanna change data in all the rows. my coding has no errors . but when i try to update it writes the same value for all the rows per field. please help me i am stuck with this.
here is the coding
void oledbConnection(/*string path, string CONstr*/)
{
//OleDbTransaction trans;
OleDbCommand OLEDBSelectCom = new OleDbCommand();
OleDbCommand OLEDBupdateCom = new OleDbCommand();
OleDbCommand OLEDBDeletecom = new OleDbCommand();
OleDbCommand OLEDBInsertCom = new OleDbCommand();
OleDbConnection OLEDBcon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\yearEndExe\\WmsFoodCityPerformance" +
".mdb;Jet OLEDB:Database Password=sanuja");
OLEDBcon.Open();
OleDbTransaction trans;
trans = OLEDBcon.BeginTransaction();
OleDbDataAdapter OLEDBda = new OleDbDataAdapter();
OLEDBSelectCom.Transaction = trans;
OLEDBSelectCom.UpdatedRowSource = UpdateRowSource.Both;
OLEDBSelectCom.CommandText = "Select * from CON_MIN";
//OLEDBDeletecom.CommandText = "Delete from CON_KPT";
OLEDBupdateCom.Connection = OLEDBcon;
OLEDBSelectCom.Connection = OLEDBcon;
DataSet ds = new DataSet();
OLEDBda.SelectCommand = OLEDBSelectCom;
OLEDBda.UpdateCommand = OLEDBupdateCom;
OleDbCommandBuilder combil = new OleDbCommandBuilder(OLEDBda);
OLEDBda.Fill(ds);
DataTable dt = new DataTable();
dt = ds.Tables[0];
int x=0;
dataGridView1.DataSource = dt;
MessageBox.Show("Select completed");
foreach (DataRow dr in dt.Rows)
{
//MessageBox.Show(dr["NET_JUL"].ToString());
//MessageBox.Show(dr["LYNET_JUL"].ToString());
dr.BeginEdit();
dr["BGT_APR"] = 0;
dr["BGT_JUN"] = 0;
dr["BGT_JUL"] = 0;
dr["BGT_AUG"] = 0;
dr["BGT_SEP"] = 0;
dr["BGT_OCT"] = 0;
dr["BGT_NOV"] = 0;
dr["BGT_DEC"] = 0;
dr["BGT_JAN"] = 0;
dr["BGT_FEB"] = 0;
dr["BGT_MAR"] = 0;
dr["BUDGETED"] = 0;
dr["BUDGET_PES"] = 0;
dr["LYNET_APR"] = dr["NET_APR"];
dr["LYNET_JUN"] = dr["NET_JUN"];
dr["LYNET_JUL"] = dr["NET_JUL"];
dr["LYNET_AUG"] = dr["NET_AUG"];
dr["LYNET_SEP"] = dr["NET_SEP"];
dr["LYNET_OCT"] = dr["NET_OCT"];
dr["LYNET_NOV"] = dr["NET_NOV"];
dr["LYNET_DEC"] = dr["NET_DEC"];
dr["LYNET_JAN"] = dr["NET_JAN"];
dr["LYNET_FEB"] = dr["NET_FEB"];
dr["LYNET_MAR"] = dr["NET_MAR"];
dr["NET_APR"] = 0;
dr["NET_JUN"] = 0;
dr["NET_JUL"] = 0;
dr["NET_AUG"] = 0;
dr["NET_SEP"] = 0;
dr["NET_OCT"] = 0;
dr["NET_NOV"] = 0;
dr["NET_DEC"] = 0;
dr["NET_JAN"] = 0;
dr["NET_FEB"] = 0;
dr["NET_MAR"] = 0;
dr["LYADJ_APR"] = dr["ADJ_APR"];
dr["LYADJ_JUN"] = dr["ADJ_JUN"];
dr["LYADJ_JUL"] = dr["ADJ_JUL"];
dr["LYADJ_AUG"] = dr["ADJ_AUG"];
dr["LYADJ_SEP"] = dr["ADJ_SEP"];
dr["LYADJ_OCT"] = dr["ADJ_OCT"];
dr["LYADJ_NOV"] = dr["ADJ_NOV"];
dr["LYADJ_DEC"] = dr["ADJ_DEC"];
dr["LYADJ_JAN"] = dr["ADJ_JAN"];
dr["LYADJ_FEB"] = dr["ADJ_FEB"];
dr["LYADJ_MAR"] = dr["ADJ_MAR"];
dr["LYADJ_APR"] = 0;
dr["LYADJ_JUN"] = 0;
dr["LYADJ_JUL"] = 0;
dr["LYADJ_AUG"] = 0;
dr["LYADJ_SEP"] = 0;
dr["LYADJ_OCT"] = 0;
dr["LYADJ_NOV"] = 0;
dr["LYADJ_DEC"] = 0;
dr["LYADJ_JAN"] = 0;
dr["LYADJ_FEB"] = 0;
dr["LYADJ_MAR"] = 0;
dr.EndEdit();
//MessageBox.Show(dr["NET_JUL"].ToString());
//MessageBox.Show(dr["LYNET_JUL"].ToString());
OLEDBupdateCom.CommandText = "Update CON_MIN set NET_APR=0,LYNET_APR=@LYNET_APR,NET_MAY=0,LYNET_MAY=@LYNET_MAY,NET_JUN=0,LYNET_JUN=@LYNET_JUN,NET_JUL=0,LYNET_JUL=@LYNET_JUL,NET_AUG=0,LYNET_AUG=@LYNET_AUG,NET_SEP=0,LYNET_SEP=@LYNET_SEP,NET_OCT=0,LYNET_OCT=@LYNET_OCT,NET_NOV=0,LYNET_NOV=@LYNET_NOV";
OLEDBupdateCom.Transaction = trans;
x = 10+ x;
OLEDBupdateCom.Parameters.Add(new OleDbParameter("@LYNET_APR", x));
OLEDBupdateCom.Parameters.Add(new OleDbParameter("@LYNET_MAY", dr["LYNET_MAY"]));
OLEDBupdateCom.Parameters.Add(new OleDbParameter("@LYNET_JUN", dr["LYNET_JUN"]));
OLEDBupdateCom.Parameters.Add(new OleDbParameter("@LYNET_JUL", dr["LYNET_JUL"]));
OLEDBupdateCom.Parameters.Add(new OleDbParameter("@LYNET_AUG", dr["LYNET_AUG"]));
OLEDBupdateCom.Parameters.Add(new OleDbParameter("@LYNET_SEP", dr["LYNET_SEP"]));
OLEDBupdateCom.Parameters.Add(new OleDbParameter("@LYNET_OCT", dr["LYNET_OCT"]));
OLEDBupdateCom.Parameters.Add(new OleDbParameter("@LYNET_NOV", dr["LYNET_NOV"]));
//OLEDBupdateCom.ExecuteNonQuery();
//dr.AcceptChanges();
}
OLEDBda.Update(dt);
//dt.AcceptChanges();
//OLEDBda.UpdateCommand = combil.GetUpdateCommand();
//OLEDBda.Update(ds);
trans.Commit();
ds.AcceptChanges();
}
plzzzzzzzzz help
Regards
ruwandi
rkherath
|
|
|
|
|
How can I update columns of three tables in on sql statement
|
|
|
|
|
Wrap it in a transaction - That way either all updates work, or if one fails then they all fail. From the point of view of any other process querying the database it will only see the complete set of changes, or no change at all.
|
|
|
|
|
Specify which table you want to update by using a JOIN. Here is an example of 4 tables, and an UPDATE to three of them.
CREATE TABLE people
( personID INTEGER
, personame VARCHAR(40)
, jobID INTEGER
);
CREATE TABLE addresses
( addressID INTEGER
, address VARCHAR(80)
);
CREATE TABLE jobs
( jobID INTEGER
, employerID INTEGER
, jobname VARCHAR(25)
);
CREATE TABLE employers
( employerID INTEGER
, employername VARCHAR(50)
, addressID INTEGER
);
UPDATE ((( people AS P
INNER JOIN jobs AS J ON P.jobID=J.jobID )
INNER JOIN employers AS E ON J.employerID=E.employerID)
INNER JOIN addresses AS A ON E.addressID=A.addressID)
SET jobname='Dishwasher'
, employername='McDonalds'
, address='510 Broadway'
WHERE personame='John Doe';
Hope this helps.
David
|
|
|
|
|
I am new to sql
Please help in writing INSERT and UPDATE triggers
for five tables, of which 4 has primary key and one has foriegn key
Samples would help a lot
Thanks
Sathi
|
|
|
|
|
Have you even looked at the documentation? The standard documentation for SQL Server (known as "Books On-Line") includes many examples.
From the SQL Server Books On-Line: Create Trigger[^]
|
|
|
|
|
Thanks a lot
It was really helpfull
|
|
|
|
|
Does anyone know how to push a Basic (VBA) module into Access using an SQL interface?
I have:
- A utility I wrote that runs raw SQL commands against an (already existing) Access database. It uses ADODB.
- An SQL file that builds all my tables and indexes.
- An SQL file that builds my views and procedures.
- An SQL file that populates the database.
All I'm missing is a way to programatically (via my utility and a file of commands) push my VBA modules and my forms and reports into the database. Right now I have to manually import them or drag them from the old version to the new version.
Any ideas?
DQNOK
|
|
|
|
|
i am creating a basic web application to try and further understand the asp.net that i have been learning in my course..
i have got a month to wait before i get onto the next section of the course and want to get stuck in..
does anyone know.. or could anyone donate some code in the meantime for the following..
i have a basic user sign up webform with ;
first name
second name
email address
band name
password
d.o.b
i eventually want the user sign up to be written to my version of sql server express 2005
so i can have a record of the users and so i can enable users to sign in.. greet them with their name and bandname and then further post any gigs that they wish onto a calender..
i dont know where to start or how complicated a task it actually is.. i think i will also have to create some form of admin for the database to manage and delete records etc..
any advice or help would be fantastic..
but for now i will just keep scouring the web
cheers...
John Michael Kinsella
kinsellajohn@hotmail.com
|
|
|
|
|
Hello,
Is it possible to link to a server though SQL Server's Linked Server capabilities from another Server?
If so, what do I need to do?
I am using MS SQL 2005 Dev.
Rad
rad
|
|
|
|
|
Hi Guys,
Please,help with this.I am using bulk insert to upload a text file but i receive the following error message :
System.Data.SqlClient.SqlException was caught
Message="Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 2, column 13 (EFFECTIVE_DATE).\r\nBulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 3, column 13 (EFFECTIVE_DATE).\r\nBulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 4, column 13 (EFFECTIVE_DATE).\r\nBulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 5, column 13 (EFFECTIVE_DATE)."
Thanks in Advance.
|
|
|
|
|