I just change Administrator password. All services of SQL Server were
started, but my Databases became suspend. How can I solve this problem.
Thx,r u running in windows authentication or sql authentication'
--
Shaju Thomas
"Saroeurn Long" <saroeurn_long@.nida.gov.kh> wrote in message
news:u#HPcrboDHA.3288@.tk2msftngp13.phx.gbl...
> I just change Administrator password. All services of SQL Server were
> started, but my Databases became suspend. How can I solve this problem.
> Thx,
>|||I run in sql authentication
"Shaju" <answer@.hotmail.com> wrote in message
news:O0HZ44doDHA.2272@.tk2msftngp13.phx.gbl...
> r u running in windows authentication or sql authentication'
> --
> Shaju Thomas
> "Saroeurn Long" <saroeurn_long@.nida.gov.kh> wrote in message
> news:u#HPcrboDHA.3288@.tk2msftngp13.phx.gbl...
> > I just change Administrator password. All services of SQL Server were
> > started, but my Databases became suspend. How can I solve this problem.
> >
> > Thx,
> >
> >
>|||Is it suspend or suspect
--
Shaju Thomas
"Saroeurn Long" <saroeurn_long@.nida.gov.kh> wrote in message
news:#sw3raeoDHA.2000@.TK2MSFTNGP10.phx.gbl...
> I run in sql authentication
>
> "Shaju" <answer@.hotmail.com> wrote in message
> news:O0HZ44doDHA.2272@.tk2msftngp13.phx.gbl...
> > r u running in windows authentication or sql authentication'
> >
> > --
> > Shaju Thomas
> > "Saroeurn Long" <saroeurn_long@.nida.gov.kh> wrote in message
> > news:u#HPcrboDHA.3288@.tk2msftngp13.phx.gbl...
> > > I just change Administrator password. All services of SQL Server were
> > > started, but my Databases became suspend. How can I solve this
problem.
> > >
> > > Thx,
> > >
> > >
> >
> >
>|||Hello,
Did you have any jobs running on the old userid /
password ?
If so cancel them, as what could be happening is your db
was going though with a job when the password change come
up.
Check in managment your current processors.
>--Original Message--
>I just change Administrator password. All services of SQL
Server were
>started, but my Databases became suspend. How can I solve
this problem.
>Thx,
>
>.
>
Showing posts with label services. Show all posts
Showing posts with label services. Show all posts
Tuesday, March 27, 2012
Sunday, March 11, 2012
database attach error
fellows,
I have some problems!!!!!! I was given a database that is in rough shape. here are the particulars. SQL 2000 RTM. The SQL Services wouldn't start the database when the engine came up. Here is where it gets shaky. They say that they dettached the database
when it was in "emergency" mode now they have nothing. No service packs, no maintenance, and a datbase that won't start. When I try to attach i get this nasty error.
Server: Msg 3624, Level 20, State 1, Line 1
Location: recbase.cpp:1378
Expression: m_offBeginVar < m_SizeRec
SPID: 55
Process ID: 2068
Connection Broken
I have tried sp_attach_single_file_db but do not have the same directory structure so it continues to error out.
Does any one have any ideas on how to attach just so I can read or script? Then maybe I can export / import ?
I think you're going to have to call MS support... When you get a debug
error you know something really bad has happened.
"detroit" <sbowman@.broward.org> wrote in message
news:72CB734D-6E7E-482C-A09B-F1BEE2AAE948@.microsoft.com...
> fellows,
> I have some problems!!!!!! I was given a database that is in rough shape.
here are the particulars. SQL 2000 RTM. The SQL Services wouldn't start the
database when the engine came up. Here is where it gets shaky. They say that
they dettached the database when it was in "emergency" mode now they have
nothing. No service packs, no maintenance, and a datbase that won't start.
When I try to attach i get this nasty error.
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recbase.cpp:1378
> Expression: m_offBeginVar < m_SizeRec
> SPID: 55
> Process ID: 2068
> Connection Broken
> I have tried sp_attach_single_file_db but do not have the same directory
structure so it continues to error out.
>
> Does any one have any ideas on how to attach just so I can read or script?
Then maybe I can export / import ?
>
|||Create a new database with the same name and file names in a different
directory than the current MDF and LDF files. After you create the new
database, stop SQL Server and copy the old database files over the top of
the new ones. SQL Server will recognize the database. It may set the
suspect status but then you can put it in emergency mode and try to extract
whatever data out of it. Or run DBCC Checkdb and see if it can be repaired.
Rand
This posting is provided "as is" with no warranties and confers no rights.
I have some problems!!!!!! I was given a database that is in rough shape. here are the particulars. SQL 2000 RTM. The SQL Services wouldn't start the database when the engine came up. Here is where it gets shaky. They say that they dettached the database
when it was in "emergency" mode now they have nothing. No service packs, no maintenance, and a datbase that won't start. When I try to attach i get this nasty error.
Server: Msg 3624, Level 20, State 1, Line 1
Location: recbase.cpp:1378
Expression: m_offBeginVar < m_SizeRec
SPID: 55
Process ID: 2068
Connection Broken
I have tried sp_attach_single_file_db but do not have the same directory structure so it continues to error out.
Does any one have any ideas on how to attach just so I can read or script? Then maybe I can export / import ?
I think you're going to have to call MS support... When you get a debug
error you know something really bad has happened.
"detroit" <sbowman@.broward.org> wrote in message
news:72CB734D-6E7E-482C-A09B-F1BEE2AAE948@.microsoft.com...
> fellows,
> I have some problems!!!!!! I was given a database that is in rough shape.
here are the particulars. SQL 2000 RTM. The SQL Services wouldn't start the
database when the engine came up. Here is where it gets shaky. They say that
they dettached the database when it was in "emergency" mode now they have
nothing. No service packs, no maintenance, and a datbase that won't start.
When I try to attach i get this nasty error.
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recbase.cpp:1378
> Expression: m_offBeginVar < m_SizeRec
> SPID: 55
> Process ID: 2068
> Connection Broken
> I have tried sp_attach_single_file_db but do not have the same directory
structure so it continues to error out.
>
> Does any one have any ideas on how to attach just so I can read or script?
Then maybe I can export / import ?
>
|||Create a new database with the same name and file names in a different
directory than the current MDF and LDF files. After you create the new
database, stop SQL Server and copy the old database files over the top of
the new ones. SQL Server will recognize the database. It may set the
suspect status but then you can put it in emergency mode and try to extract
whatever data out of it. Or run DBCC Checkdb and see if it can be repaired.
Rand
This posting is provided "as is" with no warranties and confers no rights.
database attach error
fellows,
I have some problems!!!!!! I was given a database that is in rough shape. he
re are the particulars. SQL 2000 RTM. The SQL Services wouldn't start the da
tabase when the engine came up. Here is where it gets shaky. They say that t
hey dettached the database
when it was in "emergency" mode now they have nothing. No service packs, no
maintenance, and a datbase that won't start. When I try to attach i get this
nasty error.
Server: Msg 3624, Level 20, State 1, Line 1
Location: recbase.cpp:1378
Expression: m_offBeginVar < m_SizeRec
SPID: 55
Process ID: 2068
Connection Broken
I have tried sp_attach_single_file_db but do not have the same directory str
ucture so it continues to error out.
Does any one have any ideas on how to attach just so I can read or script? T
hen maybe I can export / import ?I think you're going to have to call MS support... When you get a debug
error you know something really bad has happened.
"detroit" <sbowman@.broward.org> wrote in message
news:72CB734D-6E7E-482C-A09B-F1BEE2AAE948@.microsoft.com...
> fellows,
> I have some problems!!!!!! I was given a database that is in rough shape.
here are the particulars. SQL 2000 RTM. The SQL Services wouldn't start the
database when the engine came up. Here is where it gets shaky. They say that
they dettached the database when it was in "emergency" mode now they have
nothing. No service packs, no maintenance, and a datbase that won't start.
When I try to attach i get this nasty error.
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recbase.cpp:1378
> Expression: m_offBeginVar < m_SizeRec
> SPID: 55
> Process ID: 2068
> Connection Broken
> I have tried sp_attach_single_file_db but do not have the same directory
structure so it continues to error out.
>
> Does any one have any ideas on how to attach just so I can read or script?
Then maybe I can export / import ?
>|||Create a new database with the same name and file names in a different
directory than the current MDF and LDF files. After you create the new
database, stop SQL Server and copy the old database files over the top of
the new ones. SQL Server will recognize the database. It may set the
suspect status but then you can put it in emergency mode and try to extract
whatever data out of it. Or run DBCC Checkdb and see if it can be repaired.
Rand
This posting is provided "as is" with no warranties and confers no rights.
I have some problems!!!!!! I was given a database that is in rough shape. he
re are the particulars. SQL 2000 RTM. The SQL Services wouldn't start the da
tabase when the engine came up. Here is where it gets shaky. They say that t
hey dettached the database
when it was in "emergency" mode now they have nothing. No service packs, no
maintenance, and a datbase that won't start. When I try to attach i get this
nasty error.
Server: Msg 3624, Level 20, State 1, Line 1
Location: recbase.cpp:1378
Expression: m_offBeginVar < m_SizeRec
SPID: 55
Process ID: 2068
Connection Broken
I have tried sp_attach_single_file_db but do not have the same directory str
ucture so it continues to error out.
Does any one have any ideas on how to attach just so I can read or script? T
hen maybe I can export / import ?I think you're going to have to call MS support... When you get a debug
error you know something really bad has happened.
"detroit" <sbowman@.broward.org> wrote in message
news:72CB734D-6E7E-482C-A09B-F1BEE2AAE948@.microsoft.com...
> fellows,
> I have some problems!!!!!! I was given a database that is in rough shape.
here are the particulars. SQL 2000 RTM. The SQL Services wouldn't start the
database when the engine came up. Here is where it gets shaky. They say that
they dettached the database when it was in "emergency" mode now they have
nothing. No service packs, no maintenance, and a datbase that won't start.
When I try to attach i get this nasty error.
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recbase.cpp:1378
> Expression: m_offBeginVar < m_SizeRec
> SPID: 55
> Process ID: 2068
> Connection Broken
> I have tried sp_attach_single_file_db but do not have the same directory
structure so it continues to error out.
>
> Does any one have any ideas on how to attach just so I can read or script?
Then maybe I can export / import ?
>|||Create a new database with the same name and file names in a different
directory than the current MDF and LDF files. After you create the new
database, stop SQL Server and copy the old database files over the top of
the new ones. SQL Server will recognize the database. It may set the
suspect status but then you can put it in emergency mode and try to extract
whatever data out of it. Or run DBCC Checkdb and see if it can be repaired.
Rand
This posting is provided "as is" with no warranties and confers no rights.
Thursday, March 8, 2012
Database adapter?
So what exactly is a database adapter? There is a company that wants to
provide reporting services to our customers using a proprietary technology,
but all they will tell us is they use an adapter and a listener through
ODBC. Seems to me that an adapter is just a fancy way of saying a wrapper
over ODBC and the listener must be installing some type of triggers or
something. I am psychotically opposed to any third party application
installing any objects into our databases. "Adapter" is a pretty darned
generic term and I'm not really comfortable with their explanation. I need
to be able to ask better questions.
Bob Castleman
DBA PoseurIt is possible that they have an ADO.NET DataAdapter. If so, it lives in
their application and not in your database. And yes, it's basically a
wrapper that encapsulates database-specific connection properties and
methods. But that's just a wild guess as to what *they* mean by "data
adapter".
-HTH
"Bob Castleman" <nomail@.here> wrote in message
news:eKI2vPRbFHA.2420@.TK2MSFTNGP15.phx.gbl...
> So what exactly is a database adapter? There is a company that wants to
> provide reporting services to our customers using a proprietary
> technology, but all they will tell us is they use an adapter and a
> listener through ODBC. Seems to me that an adapter is just a fancy way of
> saying a wrapper over ODBC and the listener must be installing some type
> of triggers or something. I am psychotically opposed to any third party
> application installing any objects into our databases. "Adapter" is a
> pretty darned generic term and I'm not really comfortable with their
> explanation. I need to be able to ask better questions.
> Bob Castleman
> DBA Poseur
>|||The adapter part seems obvious to me, but what is not at all clear is how
this can *sense* updates to the database without installing triggers.
Hmmmm.
Bob
"Jeffrey Todd" <Me@.Somewhere.net> wrote in message
news:OTpcBmRbFHA.2212@.TK2MSFTNGP14.phx.gbl...
> It is possible that they have an ADO.NET DataAdapter. If so, it lives in
> their application and not in your database. And yes, it's basically a
> wrapper that encapsulates database-specific connection properties and
> methods. But that's just a wild guess as to what *they* mean by "data
> adapter".
> -HTH
>
> "Bob Castleman" <nomail@.here> wrote in message
> news:eKI2vPRbFHA.2420@.TK2MSFTNGP15.phx.gbl...
>|||<< not at all clear is how this can *sense* updates to the database >>
Maybe they use classes in the System.Voodoo namespace in conjunction with
their ADO.NET DataAdapter.
without knowing more, and grasping for possibilities, maybe they
periodically query the db and compare against values in the application's
memory or perhaps compare to values persisted to a local disk where the app
is running... but that gets ugly quickly if they're doing it that way.
Can you tell us more about what they plan to actually install, and where it
gets installed? This "listening" thing is puzzling. Are they installling a
Windows Service that will broadcast on some port that gets listened to? Are
they setting up some custom TCP Server?
-JT
"Bob Castleman" <nomail@.here> wrote in message
news:uZ5ml4RbFHA.720@.TK2MSFTNGP15.phx.gbl...
> The adapter part seems obvious to me, but what is not at all clear is how
> this can *sense* updates to the database without installing triggers.
> Hmmmm.
>
> Bob
> "Jeffrey Todd" <Me@.Somewhere.net> wrote in message
> news:OTpcBmRbFHA.2212@.TK2MSFTNGP14.phx.gbl...
>|||Well it turns out that after beating them upside the head they finally
admitting to using triggers. I have no clue why they were so freaking
secretive.
This brings up my next question. Would any DBA worth anything ever allow a
third party application to install triggers? In my mind, my database is
sacred and NOBODY outside of my organization can change it. Technically, a
trigger isn't a schema change, but I have real problems with somebody else
sticking objects in my databases.
Bob
"Jeffrey Todd" <Me@.Somewhere.net> wrote in message
news:OJbRvDTbFHA.3240@.TK2MSFTNGP12.phx.gbl...
> << not at all clear is how this can *sense* updates to the database >>
> Maybe they use classes in the System.Voodoo namespace in conjunction with
> their ADO.NET DataAdapter.
> without knowing more, and grasping for possibilities, maybe they
> periodically query the db and compare against values in the application's
> memory or perhaps compare to values persisted to a local disk where the
> app is running... but that gets ugly quickly if they're doing it that way.
> Can you tell us more about what they plan to actually install, and where
> it gets installed? This "listening" thing is puzzling. Are they
> installling a Windows Service that will broadcast on some port that gets
> listened to? Are they setting up some custom TCP Server?
> -JT
>
> "Bob Castleman" <nomail@.here> wrote in message
> news:uZ5ml4RbFHA.720@.TK2MSFTNGP15.phx.gbl...
>|||"Bob Castleman":
> Well it turns out that after beating them upside the head they finally
> admitting to using triggers. I have no clue why they were so freaking
> secretive.
> This brings up my next question. Would any DBA worth anything ever allow a
> third party application to install triggers? In my mind, my database is
> sacred and NOBODY outside of my organization can change it. Technically, a
> trigger isn't a schema change, but I have real problems with somebody else
> sticking objects in my databases.
> Bob
Personally, I wouldn't allow it: I don't like allowing in-house personnel to
add triggers :)
One thing: is this solution for auditing all database activity? If that's
what you're looking for, you can try Lumigent. I like their Log Explorer
product, but they also have a full-blown activity audit product called (I
think) Entegra: obviously it's a lot more expensive.
Their products are based on proprietary technology that examines the SQL
Server log files, so no triggers or any other schema change. (Log Explorer
does need it's own database, so I assume Integra does as well).
Craig|||It's just a reporting application. What bugs me is that we have an XML based
API but the refuse to use it.
The log explorers are something I've looked at briefly for auditing.
Especially in light of SOX, they might be useful. It could be a convenient
way to maintain audit trails.
Bob
"Craig Kelly" <cnkelly@.spamnomore.worldnet.att.net> wrote in message
news:z14qe.302594$cg1.243213@.bgtnsc04-news.ops.worldnet.att.net...
> "Bob Castleman":
>
> Personally, I wouldn't allow it: I don't like allowing in-house personnel
> to add triggers :)
> One thing: is this solution for auditing all database activity? If that's
> what you're looking for, you can try Lumigent. I like their Log Explorer
> product, but they also have a full-blown activity audit product called (I
> think) Entegra: obviously it's a lot more expensive.
> Their products are based on proprietary technology that examines the SQL
> Server log files, so no triggers or any other schema change. (Log
> Explorer does need it's own database, so I assume Integra does as well).
> Craig
>
provide reporting services to our customers using a proprietary technology,
but all they will tell us is they use an adapter and a listener through
ODBC. Seems to me that an adapter is just a fancy way of saying a wrapper
over ODBC and the listener must be installing some type of triggers or
something. I am psychotically opposed to any third party application
installing any objects into our databases. "Adapter" is a pretty darned
generic term and I'm not really comfortable with their explanation. I need
to be able to ask better questions.
Bob Castleman
DBA PoseurIt is possible that they have an ADO.NET DataAdapter. If so, it lives in
their application and not in your database. And yes, it's basically a
wrapper that encapsulates database-specific connection properties and
methods. But that's just a wild guess as to what *they* mean by "data
adapter".
-HTH
"Bob Castleman" <nomail@.here> wrote in message
news:eKI2vPRbFHA.2420@.TK2MSFTNGP15.phx.gbl...
> So what exactly is a database adapter? There is a company that wants to
> provide reporting services to our customers using a proprietary
> technology, but all they will tell us is they use an adapter and a
> listener through ODBC. Seems to me that an adapter is just a fancy way of
> saying a wrapper over ODBC and the listener must be installing some type
> of triggers or something. I am psychotically opposed to any third party
> application installing any objects into our databases. "Adapter" is a
> pretty darned generic term and I'm not really comfortable with their
> explanation. I need to be able to ask better questions.
> Bob Castleman
> DBA Poseur
>|||The adapter part seems obvious to me, but what is not at all clear is how
this can *sense* updates to the database without installing triggers.
Hmmmm.
Bob
"Jeffrey Todd" <Me@.Somewhere.net> wrote in message
news:OTpcBmRbFHA.2212@.TK2MSFTNGP14.phx.gbl...
> It is possible that they have an ADO.NET DataAdapter. If so, it lives in
> their application and not in your database. And yes, it's basically a
> wrapper that encapsulates database-specific connection properties and
> methods. But that's just a wild guess as to what *they* mean by "data
> adapter".
> -HTH
>
> "Bob Castleman" <nomail@.here> wrote in message
> news:eKI2vPRbFHA.2420@.TK2MSFTNGP15.phx.gbl...
>|||<< not at all clear is how this can *sense* updates to the database >>
Maybe they use classes in the System.Voodoo namespace in conjunction with
their ADO.NET DataAdapter.
without knowing more, and grasping for possibilities, maybe they
periodically query the db and compare against values in the application's
memory or perhaps compare to values persisted to a local disk where the app
is running... but that gets ugly quickly if they're doing it that way.
Can you tell us more about what they plan to actually install, and where it
gets installed? This "listening" thing is puzzling. Are they installling a
Windows Service that will broadcast on some port that gets listened to? Are
they setting up some custom TCP Server?
-JT
"Bob Castleman" <nomail@.here> wrote in message
news:uZ5ml4RbFHA.720@.TK2MSFTNGP15.phx.gbl...
> The adapter part seems obvious to me, but what is not at all clear is how
> this can *sense* updates to the database without installing triggers.
> Hmmmm.
>
> Bob
> "Jeffrey Todd" <Me@.Somewhere.net> wrote in message
> news:OTpcBmRbFHA.2212@.TK2MSFTNGP14.phx.gbl...
>|||Well it turns out that after beating them upside the head they finally
admitting to using triggers. I have no clue why they were so freaking
secretive.
This brings up my next question. Would any DBA worth anything ever allow a
third party application to install triggers? In my mind, my database is
sacred and NOBODY outside of my organization can change it. Technically, a
trigger isn't a schema change, but I have real problems with somebody else
sticking objects in my databases.
Bob
"Jeffrey Todd" <Me@.Somewhere.net> wrote in message
news:OJbRvDTbFHA.3240@.TK2MSFTNGP12.phx.gbl...
> << not at all clear is how this can *sense* updates to the database >>
> Maybe they use classes in the System.Voodoo namespace in conjunction with
> their ADO.NET DataAdapter.
> without knowing more, and grasping for possibilities, maybe they
> periodically query the db and compare against values in the application's
> memory or perhaps compare to values persisted to a local disk where the
> app is running... but that gets ugly quickly if they're doing it that way.
> Can you tell us more about what they plan to actually install, and where
> it gets installed? This "listening" thing is puzzling. Are they
> installling a Windows Service that will broadcast on some port that gets
> listened to? Are they setting up some custom TCP Server?
> -JT
>
> "Bob Castleman" <nomail@.here> wrote in message
> news:uZ5ml4RbFHA.720@.TK2MSFTNGP15.phx.gbl...
>|||"Bob Castleman":
> Well it turns out that after beating them upside the head they finally
> admitting to using triggers. I have no clue why they were so freaking
> secretive.
> This brings up my next question. Would any DBA worth anything ever allow a
> third party application to install triggers? In my mind, my database is
> sacred and NOBODY outside of my organization can change it. Technically, a
> trigger isn't a schema change, but I have real problems with somebody else
> sticking objects in my databases.
> Bob
Personally, I wouldn't allow it: I don't like allowing in-house personnel to
add triggers :)
One thing: is this solution for auditing all database activity? If that's
what you're looking for, you can try Lumigent. I like their Log Explorer
product, but they also have a full-blown activity audit product called (I
think) Entegra: obviously it's a lot more expensive.
Their products are based on proprietary technology that examines the SQL
Server log files, so no triggers or any other schema change. (Log Explorer
does need it's own database, so I assume Integra does as well).
Craig|||It's just a reporting application. What bugs me is that we have an XML based
API but the refuse to use it.
The log explorers are something I've looked at briefly for auditing.
Especially in light of SOX, they might be useful. It could be a convenient
way to maintain audit trails.
Bob
"Craig Kelly" <cnkelly@.spamnomore.worldnet.att.net> wrote in message
news:z14qe.302594$cg1.243213@.bgtnsc04-news.ops.worldnet.att.net...
> "Bob Castleman":
>
> Personally, I wouldn't allow it: I don't like allowing in-house personnel
> to add triggers :)
> One thing: is this solution for auditing all database activity? If that's
> what you're looking for, you can try Lumigent. I like their Log Explorer
> product, but they also have a full-blown activity audit product called (I
> think) Entegra: obviously it's a lot more expensive.
> Their products are based on proprietary technology that examines the SQL
> Server log files, so no triggers or any other schema change. (Log
> Explorer does need it's own database, so I assume Integra does as well).
> Craig
>
Database Access over Internet
I was wondering if any body has used Internet as a WAN (Wide Area
Network) to provide database access. I know about web services but I
like to experiment with using Internet as a extended network (web
server behind one router and database behind another). Any ideas on
where to look for this?
Network) to provide database access. I know about web services but I
like to experiment with using Internet as a extended network (web
server behind one router and database behind another). Any ideas on
where to look for this?
ThanksHi
Are you talking about a VPN? Check on whether your firewall(s) will support
this.
Also:
http://support.microsoft.com/defaul...kb;en-us;323441
John
<le_mo_mo@.yahoo.com> wrote in message
news:1129345377.971147.100230@.f14g2000cwb.googlegr oups.com...
>I was wondering if any body has used Internet as a WAN (Wide Area
> Network) to provide database access. I know about web services but I
> like to experiment with using Internet as a extended network (web
> server behind one router and database behind another). Any ideas on
> where to look for this?
> Thanks|||<le_mo_mo@.yahoo.com> wrote in message
news:1129345377.971147.100230@.f14g2000cwb.googlegr oups.com...
>I was wondering if any body has used Internet as a WAN (Wide Area
> Network) to provide database access. I know about web services but I
> like to experiment with using Internet as a extended network (web
> server behind one router and database behind another). Any ideas on
> where to look for this?
> Thanks
Not the internet, but I used a wide area network a few years ago to
replicate a large SQL Server database across. The WAN ran at 64kbps, and it
struggled but we were replicating across half a dozen production sites.
So be aware that there may be a serious performance hit - it depends a lot
on the upload and download speeds at both ends of the connection and the
types of queries that you might be doing. Timeouts may also be an issue. Do
a serious assessment of the volumes of data you are likely to be moving.
As John has rightly pointed out, use a VPN.
Hope this helps.
--
Brian Cryer
www.cryer.co.uk/brian|||le_mo_mo@.yahoo.com wrote:
> I was wondering if any body has used Internet as a WAN (Wide Area
> Network) to provide database access. I know about web services but I
> like to experiment with using Internet as a extended network (web
> server behind one router and database behind another). Any ideas on
> where to look for this?
> Thanks
Interesting idea,
Personally, I wouldn't trust public access without being able to filter
traffic though a PIX and a web service but please let me know how you
get on.
Regards
Jon
Saturday, February 25, 2012
data ware housing
Hai
i have just started to learn about the concepts of dataware housing. i
came to know there are about 5 services in data warehousing.
Namely, 1.Analytical services 2.Integerating services 3 Data Mining 4
Notification services and 5 Reporting services.my doubt i that is there any
order of studying these services or just start with any of the services and
complete one by one.
Thank youYou are mentioning the tools and leaving out the concepts. Here is the order
you should probably focus your studies:
1) Dimensional Modeling
2) ETL Concepts (type 1, type 2, etc.)
3) SSIS (integration services)
4) SSAS (analysis services)
5) SSRS (reporting services)
6) Notification Services
-=Steve
"vidhya" wrote:
> Hai
> i have just started to learn about the concepts of dataware housing. i
> came to know there are about 5 services in data warehousing.
> Namely, 1.Analytical services 2.Integerating services 3 Data Mining 4
> Notification services and 5 Reporting services.my doubt i that is there an
y
> order of studying these services or just start with any of the services an
d
> complete one by one.
>
> Thank you
>
>
i have just started to learn about the concepts of dataware housing. i
came to know there are about 5 services in data warehousing.
Namely, 1.Analytical services 2.Integerating services 3 Data Mining 4
Notification services and 5 Reporting services.my doubt i that is there any
order of studying these services or just start with any of the services and
complete one by one.
Thank youYou are mentioning the tools and leaving out the concepts. Here is the order
you should probably focus your studies:
1) Dimensional Modeling
2) ETL Concepts (type 1, type 2, etc.)
3) SSIS (integration services)
4) SSAS (analysis services)
5) SSRS (reporting services)
6) Notification Services
-=Steve
"vidhya" wrote:
> Hai
> i have just started to learn about the concepts of dataware housing. i
> came to know there are about 5 services in data warehousing.
> Namely, 1.Analytical services 2.Integerating services 3 Data Mining 4
> Notification services and 5 Reporting services.my doubt i that is there an
y
> order of studying these services or just start with any of the services an
d
> complete one by one.
>
> Thank you
>
>
Tuesday, February 14, 2012
Data Trasformation Services
Hello All,
Can anyone tell me.. is that I can't create DTS if i'm using 4 field for Primary Key?
Can you explain a little more? Seems like you are using DTS to move data from one place to anotehr? You have a table with 4 columns in the primary key? what is that DTS is not letting you do?|||Thanks Euan,
:D Sorry babe!!!
Yups.. I want to move data from tableA to tableB.. but in the same database.. I have a table with 4 columns primary keys.. I've got this :-
Violation of PRIMARY KEY constraint 'tableB'. Cannot insert duplicate key in object 'tableB'. The statement has been terminated.
|||You have invalid data in tablea, are you sure the keys are the same in the 2 tables? The error is basically saying that you have a row that violates the primary key constaint of table b.|||Yes, I'm sure the keys are the same in the 2 tables.. but if tableB doesn't have keys.. DTS running successfully.. but later my data will be duplicate..|||Are you running the load more than once, with the keys off perhaps? Can you count the rows in the 2 tables to make sure the counts are the same.Data Trasformation Services
Hello All,
Can anyone tell me.. is that I can't create DTS if i'm using 4 field for Primary Key?
Can you explain a little more? Seems like you are using DTS to move data from one place to anotehr? You have a table with 4 columns in the primary key? what is that DTS is not letting you do?|||Thanks Euan,
:D Sorry babe!!!
Yups.. I want to move data from tableA to tableB.. but in the same database.. I have a table with 4 columns primary keys.. I've got this :-
Violation of PRIMARY KEY constraint 'tableB'. Cannot insert duplicate key in object 'tableB'. The statement has been terminated.
|||You have invalid data in tablea, are you sure the keys are the same in the 2 tables? The error is basically saying that you have a row that violates the primary key constaint of table b.|||Yes, I'm sure the keys are the same in the 2 tables.. but if tableB doesn't have keys.. DTS running successfully.. but later my data will be duplicate..|||Are you running the load more than once, with the keys off perhaps? Can you count the rows in the 2 tables to make sure the counts are the same.Data Transformation Services Revisited
I am trying to export a table from SQL Server to Oracle8i home edition. I want to schedule the export package to run at a certain time. The package gets created, but when the time is reached for the package to execute, it doesn't execute. There are no errors at all. It just doesn't run. The package is there because I see it in the Data Transformation Services->Local Packages list. Any ideas? Thanks.If you scheduled the package to run you should see it Enterprise Manager under the server in Management/SQL Server Agent/Jobs.
There you will see last run status among other things.
Of course the SQL Server Agent needs to be running.|||Its not in the list of jobs. I got no error that the SQL Server Agent isn't running. How do I check to make sure it is running?
Thanks|||Originally posted by exdter
Its not in the list of jobs. I got no error that the SQL Server Agent isn't running. How do I check to make sure it is running?
Thanks
Do a refresh on the jobs. If it isn't there, then that is your problem. After you right-click the DTS package and do schedule, you should see the job in the "Jobs" panel.|||I don't think you would get an error that it is not running
In Enterprise Manage you see if it is running by the small green "play" icon on it. You can start it from there with right clicking on it.
Or you can start it with Service Manager.
It would probably be a good thing to set it to always start automatically.|||The jobs were there, all with error messages. The Server Agent is running as well.|||Then you know the schedule works at least :-)
Can you run the task manually, and does it work without errors then?
Originally posted by exdter
The jobs were there, all with error messages. The Server Agent is running as well.|||Originally posted by exdter
The jobs were there, all with error messages. The Server Agent is running as well.
OK, that's a different error than what you were seeing before (no jobs).
Try double-clicking the job, click the "steps" tab, select the only step, click edit, cut and paste the command to a command prompt and see what you get.
That will probably fail and give you a more detailed error. Otherwise, you probably have a permissions issue.|||Manually the job works. Thanks for your help.|||When I put the line in a command prompt, everything worked. The table was created in Oracle.|||Originally posted by exdter
When I put the line in a command prompt, everything worked. The table was created in Oracle.
If the job reliably fails when automated and reliably works when executed manually, it is almost definitely a permissions issue. Right-click the job, do "Start Job", wait a few minutes, do a refresh, and check if the job does reliably fail when scheduled.
Check who owns that job. Try changing that to sa or local Admin. You also may want to try deleting and recreating the job (I've seen that help).|||I created the job logged in as administrator. I deleted and recreated the job more than once, and it still doesn't run on a schedule. Thanks for your help.|||The scheduled job will run under the credentials the SQL Server Agent has if using Windows integrated security.
For the connection with Oracle I guess you set that in the Oracle connection in the DTS package. (I don't know much about Oracle security).|||I did set the connection to Oracle also in the DTS. Its strange that the package will run manually and not on the schedule.|||Originally posted by exdter
I did set the connection to Oracle also in the DTS. Its strange that the package will run manually and not on the schedule.
This is an almost sure sign of a permissions issue. Did you look at the Windows Event Log? The error message for scheduled jobs should be in there.|||I couldn't find anything in there about it.|||Just to make sure: Have you installed (Oracle) SQL*Net on the SQL Server? SQL*Net is similar to Client Connectivity in SQL Server. It installs all the underlying DLL's, executables, and such that any application (DTS included) would need to connect to an Oracle Database.
If so, can you do a TNSPing to the SID that you are trying to reach? DTS is horribly client bound, so running the package manually would mean that you are running the package from your lap/desk-top.|||I didn't have the SQL* Net installed. Thanks.
There you will see last run status among other things.
Of course the SQL Server Agent needs to be running.|||Its not in the list of jobs. I got no error that the SQL Server Agent isn't running. How do I check to make sure it is running?
Thanks|||Originally posted by exdter
Its not in the list of jobs. I got no error that the SQL Server Agent isn't running. How do I check to make sure it is running?
Thanks
Do a refresh on the jobs. If it isn't there, then that is your problem. After you right-click the DTS package and do schedule, you should see the job in the "Jobs" panel.|||I don't think you would get an error that it is not running
In Enterprise Manage you see if it is running by the small green "play" icon on it. You can start it from there with right clicking on it.
Or you can start it with Service Manager.
It would probably be a good thing to set it to always start automatically.|||The jobs were there, all with error messages. The Server Agent is running as well.|||Then you know the schedule works at least :-)
Can you run the task manually, and does it work without errors then?
Originally posted by exdter
The jobs were there, all with error messages. The Server Agent is running as well.|||Originally posted by exdter
The jobs were there, all with error messages. The Server Agent is running as well.
OK, that's a different error than what you were seeing before (no jobs).
Try double-clicking the job, click the "steps" tab, select the only step, click edit, cut and paste the command to a command prompt and see what you get.
That will probably fail and give you a more detailed error. Otherwise, you probably have a permissions issue.|||Manually the job works. Thanks for your help.|||When I put the line in a command prompt, everything worked. The table was created in Oracle.|||Originally posted by exdter
When I put the line in a command prompt, everything worked. The table was created in Oracle.
If the job reliably fails when automated and reliably works when executed manually, it is almost definitely a permissions issue. Right-click the job, do "Start Job", wait a few minutes, do a refresh, and check if the job does reliably fail when scheduled.
Check who owns that job. Try changing that to sa or local Admin. You also may want to try deleting and recreating the job (I've seen that help).|||I created the job logged in as administrator. I deleted and recreated the job more than once, and it still doesn't run on a schedule. Thanks for your help.|||The scheduled job will run under the credentials the SQL Server Agent has if using Windows integrated security.
For the connection with Oracle I guess you set that in the Oracle connection in the DTS package. (I don't know much about Oracle security).|||I did set the connection to Oracle also in the DTS. Its strange that the package will run manually and not on the schedule.|||Originally posted by exdter
I did set the connection to Oracle also in the DTS. Its strange that the package will run manually and not on the schedule.
This is an almost sure sign of a permissions issue. Did you look at the Windows Event Log? The error message for scheduled jobs should be in there.|||I couldn't find anything in there about it.|||Just to make sure: Have you installed (Oracle) SQL*Net on the SQL Server? SQL*Net is similar to Client Connectivity in SQL Server. It installs all the underlying DLL's, executables, and such that any application (DTS included) would need to connect to an Oracle Database.
If so, can you do a TNSPing to the SID that you are trying to reach? DTS is horribly client bound, so running the package manually would mean that you are running the package from your lap/desk-top.|||I didn't have the SQL* Net installed. Thanks.
Data Transformation Services Migration wizard
i am trying to use the DTS migration wizard in sql server 2005 to migrate some of the DTS packages that i have on sql server 2000.
After entering the source and destination server i get the following error:
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index (mscorlib)
Does anyone know the reson behind this?
Thanks for any help.
I've just installed Server 2005 and am getting the same message. The earlier threads refer to special characters and leading or trailing spaces. I've tried the wizard on a few packages that have nothing but letters in the name, and I get the above message. I tried repairing .NET 2.0 as well (didn't work).
What else should I/we try?
Thanks,
K
|||Found a forum where a user clarified that NONE of the DTS packages can have a leading/trailing space. Well, one out of a hundred or so packages had a space; after I fixed that one, the wizard worked.
Find the spaces (thanks to Joseph Sack's SQL Server blog):
SELECT DISTINCT name
FROM msdb.dbo.sysdtspackages
WHERE name LIKE '% '
and I'd suggest: or name LIKE ' %'
|||Thanks a lot.
I had one package that had a space. After i deleted the space i was able to get a little further. but when i hit finish, All the packages display "Stopped" and none gets transferred.
Thanks
Data transformation services migration problem
I have now SBS 2003 with SQL. I had a SBS2000 with SQL.
I want to do some migrations and tried to migrate Data Transformations.
In Legacy I choose " Data Transformation Services" and rightclick on
"migration wizard"
Everything looks fine and the wizard is telling me verything was ok.
But now I cannot find the new migrated files?
Where can I find these?
Hans
The tables have been copied, no problem, but the Data Transformations does
not work. I also cannot create new data transformations like I did in
SQL2000
Hans
"John Bell" <jbellnewsposts@.hotmail.com> schreef in bericht
news:eTMLA1$nIHA.4848@.TK2MSFTNGP05.phx.gbl...
> "Hans" <info@.tct.nl> wrote in message
> news:48061e52$0$25482$ba620dc5@.text.nova.planet.nl ...
> Hi
> Have you tried backing up the databases and restoring them on the new
> server? Check out http://support.microsoft.com/kb/314546
> John
>
I want to do some migrations and tried to migrate Data Transformations.
In Legacy I choose " Data Transformation Services" and rightclick on
"migration wizard"
Everything looks fine and the wizard is telling me verything was ok.
But now I cannot find the new migrated files?
Where can I find these?
Hans
The tables have been copied, no problem, but the Data Transformations does
not work. I also cannot create new data transformations like I did in
SQL2000
Hans
"John Bell" <jbellnewsposts@.hotmail.com> schreef in bericht
news:eTMLA1$nIHA.4848@.TK2MSFTNGP05.phx.gbl...
> "Hans" <info@.tct.nl> wrote in message
> news:48061e52$0$25482$ba620dc5@.text.nova.planet.nl ...
> Hi
> Have you tried backing up the databases and restoring them on the new
> server? Check out http://support.microsoft.com/kb/314546
> John
>
Data transformation services migration problem
I have now SBS 2003 with SQL. I had a SBS2000 with SQL.
I want to do some migrations and tried to migrate Data Transformations.
In Legacy I choose " Data Transformation Services" and rightclick on
"migration wizard"
Everything looks fine and the wizard is telling me verything was ok.
But now I cannot find the new migrated files'
Where can I find these?
Hans"Hans" <info@.tct.nl> wrote in message
news:48061e52$0$25482$ba620dc5@.text.nova.planet.nl...
>I have now SBS 2003 with SQL. I had a SBS2000 with SQL.
> I want to do some migrations and tried to migrate Data Transformations.
> In Legacy I choose " Data Transformation Services" and rightclick on
> "migration wizard"
> Everything looks fine and the wizard is telling me verything was ok.
> But now I cannot find the new migrated files'
> Where can I find these?
> Hans
>
Hi
Have you tried backing up the databases and restoring them on the new
server? Check out http://support.microsoft.com/kb/314546
John|||The tables have been copied, no problem, but the Data Transformations does
not work. I also cannot create new data transformations like I did in
SQL2000
Hans
"John Bell" <jbellnewsposts@.hotmail.com> schreef in bericht
news:eTMLA1$nIHA.4848@.TK2MSFTNGP05.phx.gbl...
> "Hans" <info@.tct.nl> wrote in message
> news:48061e52$0$25482$ba620dc5@.text.nova.planet.nl...
>>I have now SBS 2003 with SQL. I had a SBS2000 with SQL.
>> I want to do some migrations and tried to migrate Data Transformations.
>> In Legacy I choose " Data Transformation Services" and rightclick on
>> "migration wizard"
>> Everything looks fine and the wizard is telling me verything was ok.
>> But now I cannot find the new migrated files'
>> Where can I find these?
>> Hans
> Hi
> Have you tried backing up the databases and restoring them on the new
> server? Check out http://support.microsoft.com/kb/314546
> John
>|||"Hans" <info@.tct.nl> wrote in message
news:48083b38$0$14782$ba620dc5@.text.nova.planet.nl...
> The tables have been copied, no problem, but the Data Transformations does
> not work. I also cannot create new data transformations like I did in
> SQL2000
> Hans
> "John Bell" <jbellnewsposts@.hotmail.com> schreef in bericht
> news:eTMLA1$nIHA.4848@.TK2MSFTNGP05.phx.gbl...
>> "Hans" <info@.tct.nl> wrote in message
>> news:48061e52$0$25482$ba620dc5@.text.nova.planet.nl...
>>I have now SBS 2003 with SQL. I had a SBS2000 with SQL.
>> I want to do some migrations and tried to migrate Data Transformations.
>> In Legacy I choose " Data Transformation Services" and rightclick on
>> "migration wizard"
>> Everything looks fine and the wizard is telling me verything was ok.
>> But now I cannot find the new migrated files'
>> Where can I find these?
>> Hans
>> Hi
>> Have you tried backing up the databases and restoring them on the new
>> server? Check out http://support.microsoft.com/kb/314546
>> John
Hi
In SQL 2005 (which comes with SBS 2003 R2) you should use SSIS rather than
DTS. These may help answer some of your questions
http://msdn2.microsoft.com/en-us/library/ms345120.aspx
http://msdn2.microsoft.com/en-us/library/ms143706.aspx
John|||Where can I find SSIS program?
Or do you mean that VB .NET ? But that's very complicated for a simple user.
What I still don't understand is:
The migration wizard imports the DTS into the SQL 2005, but I cannot find it
anywhere in the databases? Where is this saved and where can I open the
imported files?
Hans
"John Bell" <jbellnewsposts@.hotmail.com> schreef in bericht
news:%23%23Qke8SoIHA.420@.TK2MSFTNGP02.phx.gbl...
> "Hans" <info@.tct.nl> wrote in message
> news:48083b38$0$14782$ba620dc5@.text.nova.planet.nl...
>> The tables have been copied, no problem, but the Data Transformations
>> does not work. I also cannot create new data transformations like I did
>> in SQL2000
>> Hans
>> "John Bell" <jbellnewsposts@.hotmail.com> schreef in bericht
>> news:eTMLA1$nIHA.4848@.TK2MSFTNGP05.phx.gbl...
>> "Hans" <info@.tct.nl> wrote in message
>> news:48061e52$0$25482$ba620dc5@.text.nova.planet.nl...
>>I have now SBS 2003 with SQL. I had a SBS2000 with SQL.
>> I want to do some migrations and tried to migrate Data Transformations.
>> In Legacy I choose " Data Transformation Services" and rightclick on
>> "migration wizard"
>> Everything looks fine and the wizard is telling me verything was ok.
>> But now I cannot find the new migrated files'
>> Where can I find these?
>> Hans
>> Hi
>> Have you tried backing up the databases and restoring them on the new
>> server? Check out http://support.microsoft.com/kb/314546
>> John
> Hi
> In SQL 2005 (which comes with SBS 2003 R2) you should use SSIS rather
> than DTS. These may help answer some of your questions
> http://msdn2.microsoft.com/en-us/library/ms345120.aspx
> http://msdn2.microsoft.com/en-us/library/ms143706.aspx
> John
>|||"Hans" wrote:
> Where can I find SSIS program?
> Or do you mean that VB .NET ? But that's very complicated for a simple user.
> What I still don't understand is:
> The migration wizard imports the DTS into the SQL 2005, but I cannot find it
> anywhere in the databases? Where is this saved and where can I open the
> imported files?
> Hans
>
> "John Bell" <jbellnewsposts@.hotmail.com> schreef in bericht
> news:%23%23Qke8SoIHA.420@.TK2MSFTNGP02.phx.gbl...
> >
> > "Hans" <info@.tct.nl> wrote in message
> > news:48083b38$0$14782$ba620dc5@.text.nova.planet.nl...
> >> The tables have been copied, no problem, but the Data Transformations
> >> does not work. I also cannot create new data transformations like I did
> >> in SQL2000
> >>
> >> Hans
> >>
> >> "John Bell" <jbellnewsposts@.hotmail.com> schreef in bericht
> >> news:eTMLA1$nIHA.4848@.TK2MSFTNGP05.phx.gbl...
> >>
> >> "Hans" <info@.tct.nl> wrote in message
> >> news:48061e52$0$25482$ba620dc5@.text.nova.planet.nl...
> >>I have now SBS 2003 with SQL. I had a SBS2000 with SQL.
> >> I want to do some migrations and tried to migrate Data Transformations.
> >>
> >> In Legacy I choose " Data Transformation Services" and rightclick on
> >> "migration wizard"
> >> Everything looks fine and the wizard is telling me verything was ok.
> >>
> >> But now I cannot find the new migrated files'
> >> Where can I find these?
> >>
> >> Hans
> >>
> >> Hi
> >>
> >> Have you tried backing up the databases and restoring them on the new
> >> server? Check out http://support.microsoft.com/kb/314546
> >>
> >> John
> >>
> > Hi
> >
> > In SQL 2005 (which comes with SBS 2003 R2) you should use SSIS rather
> > than DTS. These may help answer some of your questions
> > http://msdn2.microsoft.com/en-us/library/ms345120.aspx
> > http://msdn2.microsoft.com/en-us/library/ms143706.aspx
> >
> > John
> >
Hi
Migrated DTS packages will be under the Management\Legacy\Data
Transformation Services See
http://technet.microsoft.com/en-us/library/ms143706.aspx
You should aim to re-write the packages in SSIS (integration services) to
take advantage of the new system. To write a new package you will have to
use BIDS (SQL Server Business Intelligence Development Studio) and create an
Integration Services Project. More information about this can be found in
Books Online also check out http://www.sqlis.com/ and the videos on
http://www.jumpstarttv.com/Channel.aspx?cat=c871236d-8554-42e3-8683-4d422356c0bd
John
I want to do some migrations and tried to migrate Data Transformations.
In Legacy I choose " Data Transformation Services" and rightclick on
"migration wizard"
Everything looks fine and the wizard is telling me verything was ok.
But now I cannot find the new migrated files'
Where can I find these?
Hans"Hans" <info@.tct.nl> wrote in message
news:48061e52$0$25482$ba620dc5@.text.nova.planet.nl...
>I have now SBS 2003 with SQL. I had a SBS2000 with SQL.
> I want to do some migrations and tried to migrate Data Transformations.
> In Legacy I choose " Data Transformation Services" and rightclick on
> "migration wizard"
> Everything looks fine and the wizard is telling me verything was ok.
> But now I cannot find the new migrated files'
> Where can I find these?
> Hans
>
Hi
Have you tried backing up the databases and restoring them on the new
server? Check out http://support.microsoft.com/kb/314546
John|||The tables have been copied, no problem, but the Data Transformations does
not work. I also cannot create new data transformations like I did in
SQL2000
Hans
"John Bell" <jbellnewsposts@.hotmail.com> schreef in bericht
news:eTMLA1$nIHA.4848@.TK2MSFTNGP05.phx.gbl...
> "Hans" <info@.tct.nl> wrote in message
> news:48061e52$0$25482$ba620dc5@.text.nova.planet.nl...
>>I have now SBS 2003 with SQL. I had a SBS2000 with SQL.
>> I want to do some migrations and tried to migrate Data Transformations.
>> In Legacy I choose " Data Transformation Services" and rightclick on
>> "migration wizard"
>> Everything looks fine and the wizard is telling me verything was ok.
>> But now I cannot find the new migrated files'
>> Where can I find these?
>> Hans
> Hi
> Have you tried backing up the databases and restoring them on the new
> server? Check out http://support.microsoft.com/kb/314546
> John
>|||"Hans" <info@.tct.nl> wrote in message
news:48083b38$0$14782$ba620dc5@.text.nova.planet.nl...
> The tables have been copied, no problem, but the Data Transformations does
> not work. I also cannot create new data transformations like I did in
> SQL2000
> Hans
> "John Bell" <jbellnewsposts@.hotmail.com> schreef in bericht
> news:eTMLA1$nIHA.4848@.TK2MSFTNGP05.phx.gbl...
>> "Hans" <info@.tct.nl> wrote in message
>> news:48061e52$0$25482$ba620dc5@.text.nova.planet.nl...
>>I have now SBS 2003 with SQL. I had a SBS2000 with SQL.
>> I want to do some migrations and tried to migrate Data Transformations.
>> In Legacy I choose " Data Transformation Services" and rightclick on
>> "migration wizard"
>> Everything looks fine and the wizard is telling me verything was ok.
>> But now I cannot find the new migrated files'
>> Where can I find these?
>> Hans
>> Hi
>> Have you tried backing up the databases and restoring them on the new
>> server? Check out http://support.microsoft.com/kb/314546
>> John
Hi
In SQL 2005 (which comes with SBS 2003 R2) you should use SSIS rather than
DTS. These may help answer some of your questions
http://msdn2.microsoft.com/en-us/library/ms345120.aspx
http://msdn2.microsoft.com/en-us/library/ms143706.aspx
John|||Where can I find SSIS program?
Or do you mean that VB .NET ? But that's very complicated for a simple user.
What I still don't understand is:
The migration wizard imports the DTS into the SQL 2005, but I cannot find it
anywhere in the databases? Where is this saved and where can I open the
imported files?
Hans
"John Bell" <jbellnewsposts@.hotmail.com> schreef in bericht
news:%23%23Qke8SoIHA.420@.TK2MSFTNGP02.phx.gbl...
> "Hans" <info@.tct.nl> wrote in message
> news:48083b38$0$14782$ba620dc5@.text.nova.planet.nl...
>> The tables have been copied, no problem, but the Data Transformations
>> does not work. I also cannot create new data transformations like I did
>> in SQL2000
>> Hans
>> "John Bell" <jbellnewsposts@.hotmail.com> schreef in bericht
>> news:eTMLA1$nIHA.4848@.TK2MSFTNGP05.phx.gbl...
>> "Hans" <info@.tct.nl> wrote in message
>> news:48061e52$0$25482$ba620dc5@.text.nova.planet.nl...
>>I have now SBS 2003 with SQL. I had a SBS2000 with SQL.
>> I want to do some migrations and tried to migrate Data Transformations.
>> In Legacy I choose " Data Transformation Services" and rightclick on
>> "migration wizard"
>> Everything looks fine and the wizard is telling me verything was ok.
>> But now I cannot find the new migrated files'
>> Where can I find these?
>> Hans
>> Hi
>> Have you tried backing up the databases and restoring them on the new
>> server? Check out http://support.microsoft.com/kb/314546
>> John
> Hi
> In SQL 2005 (which comes with SBS 2003 R2) you should use SSIS rather
> than DTS. These may help answer some of your questions
> http://msdn2.microsoft.com/en-us/library/ms345120.aspx
> http://msdn2.microsoft.com/en-us/library/ms143706.aspx
> John
>|||"Hans" wrote:
> Where can I find SSIS program?
> Or do you mean that VB .NET ? But that's very complicated for a simple user.
> What I still don't understand is:
> The migration wizard imports the DTS into the SQL 2005, but I cannot find it
> anywhere in the databases? Where is this saved and where can I open the
> imported files?
> Hans
>
> "John Bell" <jbellnewsposts@.hotmail.com> schreef in bericht
> news:%23%23Qke8SoIHA.420@.TK2MSFTNGP02.phx.gbl...
> >
> > "Hans" <info@.tct.nl> wrote in message
> > news:48083b38$0$14782$ba620dc5@.text.nova.planet.nl...
> >> The tables have been copied, no problem, but the Data Transformations
> >> does not work. I also cannot create new data transformations like I did
> >> in SQL2000
> >>
> >> Hans
> >>
> >> "John Bell" <jbellnewsposts@.hotmail.com> schreef in bericht
> >> news:eTMLA1$nIHA.4848@.TK2MSFTNGP05.phx.gbl...
> >>
> >> "Hans" <info@.tct.nl> wrote in message
> >> news:48061e52$0$25482$ba620dc5@.text.nova.planet.nl...
> >>I have now SBS 2003 with SQL. I had a SBS2000 with SQL.
> >> I want to do some migrations and tried to migrate Data Transformations.
> >>
> >> In Legacy I choose " Data Transformation Services" and rightclick on
> >> "migration wizard"
> >> Everything looks fine and the wizard is telling me verything was ok.
> >>
> >> But now I cannot find the new migrated files'
> >> Where can I find these?
> >>
> >> Hans
> >>
> >> Hi
> >>
> >> Have you tried backing up the databases and restoring them on the new
> >> server? Check out http://support.microsoft.com/kb/314546
> >>
> >> John
> >>
> > Hi
> >
> > In SQL 2005 (which comes with SBS 2003 R2) you should use SSIS rather
> > than DTS. These may help answer some of your questions
> > http://msdn2.microsoft.com/en-us/library/ms345120.aspx
> > http://msdn2.microsoft.com/en-us/library/ms143706.aspx
> >
> > John
> >
Hi
Migrated DTS packages will be under the Management\Legacy\Data
Transformation Services See
http://technet.microsoft.com/en-us/library/ms143706.aspx
You should aim to re-write the packages in SSIS (integration services) to
take advantage of the new system. To write a new package you will have to
use BIDS (SQL Server Business Intelligence Development Studio) and create an
Integration Services Project. More information about this can be found in
Books Online also check out http://www.sqlis.com/ and the videos on
http://www.jumpstarttv.com/Channel.aspx?cat=c871236d-8554-42e3-8683-4d422356c0bd
John
Data Transformation Services (DTS)(Bulk Insert)
Hi All,
I'm using DTS package, a tool to transfer data from a txt file to database(Bulk Insert).
The Bulk Insert task provides an efficient way to copy large amounts of data into a SQL Server table or view.It seems that the Bulk Insert task supports only OLE DB connections for the destination database. But I want to use sql server authentication as OLEDB connection requires windows authentication.
So can the bulk insert be done using SQLServer authentication ? if yes then please help me.
I have given the code snippet below.
Code Sample:
Dim oPackage As New DTS.Package2()
Dim oConnection As DTS.Connection
Dim oStep As DTS.Step2
Dim oTask As DTS.Task
Dim oCustomTask As DTS.BulkInsertTask
Try
oConnection = oPackage.Connections.New("SQLOLEDB")
oStep = oPackage.Steps.New
oTask = oPackage.Tasks.New("DTSBulkInsertTask")
oCustomTask = oTask.CustomTask
With oConnection
oConnection.Catalog = "pubs"
oConnection.DataSource = "(local)"
oConnection.ID = 1
oConnection.UseTrustedConnection = True
oConnection.UserID = "Tony Patton"
oConnection.Password = "Builder"
End With
oPackage.Connections.Add(oConnection)
oConnection = Nothing
With oStep
.Name = "GenericPkgStep"
.ExecuteInMainThread = True
End With
With oCustomTask
.Name = "GenericPkgTask"
.DataFile = "c:\dts\authors.txt"
.ConnectionID = 1
.DestinationTableName = "pubs..authors"
.FieldTerminator = "|"
.RowTerminator = "\r\n"
End With
oStep.TaskName = oCustomTask.Name
With oPackage
.Steps.Add(oStep)
.Tasks.Add(oTask)
.FailOnError = True
End With
oPackage.Execute()
Catch ex As Exception
MsgBox("Error: " & CStr(Err.Number) & vbCrLf_
& Err.Description, vbExclamation, oPackage.Name)
Finally
oConnection = Nothing
oCustomTask = Nothing
oTask = Nothing
oStep = Nothing
If Not (oPackage Is Nothing) Then
oPackage.UnInitialize()
End If
End Try
This is really a SSIS forum not DTS. There is a newsgroup for DTS, with a web/forum style interface.
Corrected Snippet
oConnection.UseTrustedConnection = False ' Must be false to use SQL SecurityoConnection.UserID = "Tony Patton"
oConnection.Password = "Builder"
Data Transformation Services
How can I make a DTS in MSSQL Server Management Studio Express?
I know how to do that in SQL Server Enterprise Manager.
Is this restricted in the express?
Thanks.
SSIS (aka, DTS) is only available with SQL Server 2005 Standard Edition and above. With Standard Edition, you can use Business Intelligence Studio to make SSIS packages.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
|||I'm not fully certain, but the original poster likely wasn't talking about SSIS. Most people no longer mistakenly call SSIS by the name DTS. The question is "How can I make a DTS in MSSQL Server Management Studio Express?" I took this to mean - "How do I make a DTS package for SQL 2000 using SQL 2005's Managment Studio Express?"
Microsoft has released the Feature Pack for SQL 2005. In it, there is an item called Microsoft SQL Server 2000 DTS Designer Components.
http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
It is unclear whether or not this runs in the Expess studio, but I haven't gotten it to work. I believe it will likley run in the full version of Managment Studio, but I haven't tried. Anyone have any success with DTS Designer Components and the Express edition?
Data transformation services
How to start "Data transformation services" using Remoting (over the net)?
What are you actually trying to do?
DTS is just a set of COM objects, tehre is nothing to start, there are objects which need CoCreated.
Data Transformation Services
How can I make a DTS in MSSQL Server Management Studio Express?
I know how to do that in SQL Server Enterprise Manager.
Is this restricted in the express?
Thanks.
SSIS (aka, DTS) is only available with SQL Server 2005 Standard Edition and above. With Standard Edition, you can use Business Intelligence Studio to make SSIS packages.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
|||I'm not fully certain, but the original poster likely wasn't talking about SSIS. Most people no longer mistakenly call SSIS by the name DTS. The question is "How can I make a DTS in MSSQL Server Management Studio Express?" I took this to mean - "How do I make a DTS package for SQL 2000 using SQL 2005's Managment Studio Express?"
Microsoft has released the Feature Pack for SQL 2005. In it, there is an item called Microsoft SQL Server 2000 DTS Designer Components.
http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
It is unclear whether or not this runs in the Expess studio, but I haven't gotten it to work. I believe it will likley run in the full version of Managment Studio, but I haven't tried. Anyone have any success with DTS Designer Components and the Express edition?
Data Transformation Services
When I use the DTS to export data from SQL Server to Oracle 8i, I have no trouble doing it by exporting a whole table. However, if I try to export to Oracle using an SQL query, the table in Oracle gets created, but the table doesn't get populated by the data in my query. I get an ok on the creation of the table, but on transferring of data, I get an error that the table in Oracle doesn't exist. Any ideas? Thanks.Is the creation of the table and pumping of data separate tasks?
If so can you execute them one at a time in the DTS package designer?
I don't know if there is a good way of debugging DTS packages, if anyone knows of it I would appreciate to know how too.
If so can you execute them one at a time in the DTS package designer?
I don't know if there is a good way of debugging DTS packages, if anyone knows of it I would appreciate to know how too.
Data transformation services
Hi
I was told that using DTS will allow me to schedule stored procedures to keep an sql database up to date. For example if a user registers but does not activate the registration, his details will be removed by a stored procedure which is scheduled to run every 24 hours. I use to use the global.asax file to fire a update by using a file containing a the date of the last update and then by adding 24 hours to it, it would execute a SP to delete unwanted data.
I have tried to install DTS with no success. I am running the following
Visual web studio express
SQL 2005 Express. (From SQLExpr_exe) and I have told it to install all the extra components
Installed SQLEXPR_Toolkit.exe with all its options
Installed SQLServer2005_DTS.MSI
When I go into the sql server using MS SQL Server Management Studio Express. I cannot see the Data transformation services node. I have also just installed server reports which I had no problems installing.
Can somebody please help me.
DTS is a SQL2000 component; SQL2005 hasa totally rewritten equivalent called SSIS. An SSIS (SQL Server Integration Sercvices) job amongst other things will run stored procedures for you. However it is SQL Agent that provides the scheduling capability.
|||Hi
Thanks for the reply. I need to know where to download the ssis installation application. The other thing is my service provider that I use uses SQL2000. Im developing in SQL Express 2005. How will I deploy the scheduled jobs to there server if im using the newer version.
Regards
Data Transformation Services
Does anyone know how to distribute a DTS package to a server that you cannot
connect to? Can it be put on a CD?
You can save a DTS package as a structured storage file (*.dts) and then
ship it however you like. CD, Email, copy/paste, etc.
Simon Worth
"Pete Sklarow" <psklarow@.verizon.net> wrote in message
news:O_k_d.5441$ed6.3413@.trndny06...
> Does anyone know how to distribute a DTS package to a server that you
cannot
> connect to? Can it be put on a CD?
>
|||Thanks
"Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
news:uanCykyKFHA.2640@.TK2MSFTNGP09.phx.gbl...
> You can save a DTS package as a structured storage file (*.dts) and then
> ship it however you like. CD, Email, copy/paste, etc.
> --
> Simon Worth
>
> "Pete Sklarow" <psklarow@.verizon.net> wrote in message
> news:O_k_d.5441$ed6.3413@.trndny06...
> cannot
>
connect to? Can it be put on a CD?
You can save a DTS package as a structured storage file (*.dts) and then
ship it however you like. CD, Email, copy/paste, etc.
Simon Worth
"Pete Sklarow" <psklarow@.verizon.net> wrote in message
news:O_k_d.5441$ed6.3413@.trndny06...
> Does anyone know how to distribute a DTS package to a server that you
cannot
> connect to? Can it be put on a CD?
>
|||Thanks
"Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
news:uanCykyKFHA.2640@.TK2MSFTNGP09.phx.gbl...
> You can save a DTS package as a structured storage file (*.dts) and then
> ship it however you like. CD, Email, copy/paste, etc.
> --
> Simon Worth
>
> "Pete Sklarow" <psklarow@.verizon.net> wrote in message
> news:O_k_d.5441$ed6.3413@.trndny06...
> cannot
>
Data Transformation Services
Does anyone know how to distribute a DTS package to a server that you cannot
connect to? Can it be put on a CD?You can save a DTS package as a structured storage file (*.dts) and then
ship it however you like. CD, Email, copy/paste, etc.
--
Simon Worth
"Pete Sklarow" <psklarow@.verizon.net> wrote in message
news:O_k_d.5441$ed6.3413@.trndny06...
> Does anyone know how to distribute a DTS package to a server that you
cannot
> connect to? Can it be put on a CD?
>|||Thanks
"Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
news:uanCykyKFHA.2640@.TK2MSFTNGP09.phx.gbl...
> You can save a DTS package as a structured storage file (*.dts) and then
> ship it however you like. CD, Email, copy/paste, etc.
> --
> Simon Worth
>
> "Pete Sklarow" <psklarow@.verizon.net> wrote in message
> news:O_k_d.5441$ed6.3413@.trndny06...
>> Does anyone know how to distribute a DTS package to a server that you
> cannot
>> connect to? Can it be put on a CD?
>>
>
connect to? Can it be put on a CD?You can save a DTS package as a structured storage file (*.dts) and then
ship it however you like. CD, Email, copy/paste, etc.
--
Simon Worth
"Pete Sklarow" <psklarow@.verizon.net> wrote in message
news:O_k_d.5441$ed6.3413@.trndny06...
> Does anyone know how to distribute a DTS package to a server that you
cannot
> connect to? Can it be put on a CD?
>|||Thanks
"Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
news:uanCykyKFHA.2640@.TK2MSFTNGP09.phx.gbl...
> You can save a DTS package as a structured storage file (*.dts) and then
> ship it however you like. CD, Email, copy/paste, etc.
> --
> Simon Worth
>
> "Pete Sklarow" <psklarow@.verizon.net> wrote in message
> news:O_k_d.5441$ed6.3413@.trndny06...
>> Does anyone know how to distribute a DTS package to a server that you
> cannot
>> connect to? Can it be put on a CD?
>>
>
Subscribe to:
Posts (Atom)