Hi,
Could you please point me to some deep SMO resources : articles, books,
e-books ...
I've google a little bit and just find some basic stuff.
Thank youHeve you seen this?
http://download.microsoft.com/downl...%20services.doc
ML
Showing posts with label basic. Show all posts
Showing posts with label basic. Show all posts
Monday, March 19, 2012
Monday, March 12, 2012
need programmer to build a DTS...
I need to get a dts package built in sql 2000. Basic tasks are:
* Users login to site and upload excel files to their own directory
* Need to validate the data within the excel files
* Then import that data into an existing database
* If a record already exists in db, then update it with new data
* original files to be zipped and moved to another folder after import
* exceptions logged or emailed
I haven't built a dts before and am looking to hire someone to build it
out. Usually go to elance but thought I could get some direction here...Hi
Read some info
www.sqldts.com
<dan@.globenettravel.com.au> wrote in message
news:1152108021.520182.221220@.a14g2000cwb.googlegroups.com...
>I need to get a dts package built in sql 2000. Basic tasks are:
> * Users login to site and upload excel files to their own directory
> * Need to validate the data within the excel files
> * Then import that data into an existing database
> * If a record already exists in db, then update it with new data
> * original files to be zipped and moved to another folder after import
> * exceptions logged or emailed
> I haven't built a dts before and am looking to hire someone to build it
> out. Usually go to elance but thought I could get some direction here...
>
* Users login to site and upload excel files to their own directory
* Need to validate the data within the excel files
* Then import that data into an existing database
* If a record already exists in db, then update it with new data
* original files to be zipped and moved to another folder after import
* exceptions logged or emailed
I haven't built a dts before and am looking to hire someone to build it
out. Usually go to elance but thought I could get some direction here...Hi
Read some info
www.sqldts.com
<dan@.globenettravel.com.au> wrote in message
news:1152108021.520182.221220@.a14g2000cwb.googlegroups.com...
>I need to get a dts package built in sql 2000. Basic tasks are:
> * Users login to site and upload excel files to their own directory
> * Need to validate the data within the excel files
> * Then import that data into an existing database
> * If a record already exists in db, then update it with new data
> * original files to be zipped and moved to another folder after import
> * exceptions logged or emailed
> I haven't built a dts before and am looking to hire someone to build it
> out. Usually go to elance but thought I could get some direction here...
>
Need permission to use bulk load statement in SQL 2005?
Hello,
I've developed a tool in Visual Basic.NET and have a local instance of SQL
Server 2005 running. This tool loads a lot of data into my database. It runs
locally just fine, but when I set it to load the data into the remote
(webhosting) database, I get an error: "You do not have permission to use th
e
bulk load statement."
Can anyone tell me what kind of permission that I need to use this
statement? Using a simple Insert state would take weeks and weeks to perform
the operation. The remote database at the hosting company has a bunch of SQL
Server 2005 databases on it. I'm sure that they won't want to give me admin
rights. Is there anyway that they can give us specifically rights to use a
bulk load statement without giving us access to all the other databases on
the server?
ThanksAdd the login to the bulkadmin fixed server role.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"John Riddle" <JohnRiddle@.discussions.microsoft.com> wrote in message
news:256E7437-06C4-4392-A5DA-C9DF50F70A58@.microsoft.com...
Hello,
I've developed a tool in Visual Basic.NET and have a local instance of SQL
Server 2005 running. This tool loads a lot of data into my database. It runs
locally just fine, but when I set it to load the data into the remote
(webhosting) database, I get an error: "You do not have permission to use
the
bulk load statement."
Can anyone tell me what kind of permission that I need to use this
statement? Using a simple Insert state would take weeks and weeks to perform
the operation. The remote database at the hosting company has a bunch of SQL
Server 2005 databases on it. I'm sure that they won't want to give me admin
rights. Is there anyway that they can give us specifically rights to use a
bulk load statement without giving us access to all the other databases on
the server?
Thanks
I've developed a tool in Visual Basic.NET and have a local instance of SQL
Server 2005 running. This tool loads a lot of data into my database. It runs
locally just fine, but when I set it to load the data into the remote
(webhosting) database, I get an error: "You do not have permission to use th
e
bulk load statement."
Can anyone tell me what kind of permission that I need to use this
statement? Using a simple Insert state would take weeks and weeks to perform
the operation. The remote database at the hosting company has a bunch of SQL
Server 2005 databases on it. I'm sure that they won't want to give me admin
rights. Is there anyway that they can give us specifically rights to use a
bulk load statement without giving us access to all the other databases on
the server?
ThanksAdd the login to the bulkadmin fixed server role.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"John Riddle" <JohnRiddle@.discussions.microsoft.com> wrote in message
news:256E7437-06C4-4392-A5DA-C9DF50F70A58@.microsoft.com...
Hello,
I've developed a tool in Visual Basic.NET and have a local instance of SQL
Server 2005 running. This tool loads a lot of data into my database. It runs
locally just fine, but when I set it to load the data into the remote
(webhosting) database, I get an error: "You do not have permission to use
the
bulk load statement."
Can anyone tell me what kind of permission that I need to use this
statement? Using a simple Insert state would take weeks and weeks to perform
the operation. The remote database at the hosting company has a bunch of SQL
Server 2005 databases on it. I'm sure that they won't want to give me admin
rights. Is there anyway that they can give us specifically rights to use a
bulk load statement without giving us access to all the other databases on
the server?
Thanks
Wednesday, March 7, 2012
Need knowledge about patch
Hello, everyone:
Are ther any basic information about patch on SQL Server? How to develop patch, and run it? Thanks a lot
ZYTI don't understand exactly what you are asking. Do you want to know about the application of SQL Service Packs?
It sounds to me like you are trying to figure out how to create a patch for SQL Server, which is something that Microsoft frowns on because it makes the patched server practically impossible for them to support.
-PatP|||Pat:
Thanks for reply. I don't need MS SQL Server Pack. What I need is a .exe file that can modify database and tables. As you said, I want to know how to create a patch.
ZYT|||Can you describe in a little more detail what you want to do? I'm still confused trying to figure out what you want, so I'm no help explaining how you could do it!
-PatP|||Pat:
Tell you truth, I don't have experience on SQL Server patch. I was asked to develop a .exe file that can insert, delete and trunc tables. This file will be put in network disk. Someone copy it to local machine and run it to modify database. Thanks.
ZYT|||Sounds like he's looking for a mini Enterprise Manager. Also sounds dangerous.|||Dangerous would be a HUGE understatement! There are ways that this could be done that weren't as bad as others, but this just sounds like a disaster in the making to me.
The fundamental process of creating a list of tables, and allowing the user to truncate or drop them isn't complex. I'd guess that a rather smallish VB program could do that. The problem is that it is very dangerous!
Creating tables would be a very slightly more complex process. Nothing earth-shattering, just a bit more complex than manipulating the existing tables. This is also a relatively safe operation compared to the other two.
I'd have a long, heart-to-heart talk with whoever wants you to build this little beastie. I'd treat this project kind of like building a gallows, since it is pretty sure to hang the dba once it gets put to use!
-PatP|||Agreed! I have little VB apps I wrote to do this kind of thing when I don't want to wait for EM to load but since it's MY neck on the line I am VERY careful who has access to these things. Me. Only Me. Nothing but ME. So help Me Me.
Are ther any basic information about patch on SQL Server? How to develop patch, and run it? Thanks a lot
ZYTI don't understand exactly what you are asking. Do you want to know about the application of SQL Service Packs?
It sounds to me like you are trying to figure out how to create a patch for SQL Server, which is something that Microsoft frowns on because it makes the patched server practically impossible for them to support.
-PatP|||Pat:
Thanks for reply. I don't need MS SQL Server Pack. What I need is a .exe file that can modify database and tables. As you said, I want to know how to create a patch.
ZYT|||Can you describe in a little more detail what you want to do? I'm still confused trying to figure out what you want, so I'm no help explaining how you could do it!
-PatP|||Pat:
Tell you truth, I don't have experience on SQL Server patch. I was asked to develop a .exe file that can insert, delete and trunc tables. This file will be put in network disk. Someone copy it to local machine and run it to modify database. Thanks.
ZYT|||Sounds like he's looking for a mini Enterprise Manager. Also sounds dangerous.|||Dangerous would be a HUGE understatement! There are ways that this could be done that weren't as bad as others, but this just sounds like a disaster in the making to me.
The fundamental process of creating a list of tables, and allowing the user to truncate or drop them isn't complex. I'd guess that a rather smallish VB program could do that. The problem is that it is very dangerous!
Creating tables would be a very slightly more complex process. Nothing earth-shattering, just a bit more complex than manipulating the existing tables. This is also a relatively safe operation compared to the other two.
I'd have a long, heart-to-heart talk with whoever wants you to build this little beastie. I'd treat this project kind of like building a gallows, since it is pretty sure to hang the dba once it gets put to use!
-PatP|||Agreed! I have little VB apps I wrote to do this kind of thing when I don't want to wait for EM to load but since it's MY neck on the line I am VERY careful who has access to these things. Me. Only Me. Nothing but ME. So help Me Me.
Subscribe to:
Posts (Atom)