Bulk Upload

I need to upload multiple reports produced on another server. Is there a
script or utility that will allow me to do this?
Thanks!On Jul 3, 10:58 am, REI <R...@.discussions.microsoft.com> wrote:
> I need to upload multiple reports produced on another server. Is there a
> script or utility that will allow me to do this?
> Thanks!
There is not a quick way to do it; however, this link might give you
some insight.
http://technet.microsoft.com/en-us/library/ms159720.aspx
Regards,
Enrique Martinez
Sr. Software Consultantsql

Bulk Insert XML?

Is there a way to import a large XML file into SQL Server 2000/2005 using
T-SQL?
Looking for some utility like Bulk Insert/bcp...
- RSQLXML 3 SP3.
Comes with a great utility called SQLXML Bulk Load. Should do exactly what
you're after.
HTH. Ryan
"Rakesh" <Rakesh@.discussions.microsoft.com> wrote in message
news:53153384-7C83-40A5-9885-7DF2833DB41C@.microsoft.com...
> Is there a way to import a large XML file into SQL Server 2000/2005 using
> T-SQL?
> Looking for some utility like Bulk Insert/bcp...
> - R|||In SQL 2005 the OPENROWSET function has been improved:
http://msdn2.microsoft.com/en-us/library/ms190312(SQL.90).aspx
Look at SINGLE_BLOB, SINGLE_CLOB and SINGLE_NLOB.
ML
http://milambda.blogspot.com/|||Use OPENXML. thats the best way for insert of XML through T-SQL.
Checkout in BOL for more info. Hope this helps.
--
"Rakesh" wrote:

> Is there a way to import a large XML file into SQL Server 2000/2005 using
> T-SQL?
> Looking for some utility like Bulk Insert/bcp...
> - R|||I have a couple of examples:
http://www.sqlservercentral.com/columnists/sholliday/
http://spaces.msn.com/sholliday/ 9/22/2005
..
"Omnibuzz" <Omnibuzz@.discussions.microsoft.com> wrote in message
news:76E7E737-C5F9-435A-9CBA-298429652D4C@.microsoft.com...
> Use OPENXML. thats the best way for insert of XML through T-SQL.
> Checkout in BOL for more info. Hope this helps.
> --
>
>
> "Rakesh" wrote:
>
using

Bulk Insert Utility

I need to import data from an excel file to a SQL SERVER databse with the help of BUlk insert utility (with out running a DTS).Can anybody tell me the code?I need to place the code in a Stored Procedure.
SubhasishHi!

Bulk Insert task is a kind of task that can be included into a DTS package.
I believe you CANT import from an excel file using an stored procedure, you have to create a DTS package

see ya
Lorena

Originally posted by subhasishray
I need to import data from an excel file to a SQL SERVER databse with the help of BUlk insert utility (with out running a DTS).Can anybody tell me the code?I need to place the code in a Stored Procedure.

Subhasish|||Can I do it with the help of BCP?|||No, it needs to be a csv (or some delimited) or fixed width file...|||So either save the xls as csv or call the dts package from your stored procedure. Any reason why you do not want to use dts ?

Bulk import data to SQL Mobile

Hi!.

Is there something like BCP utility in SQL CE?

I need to import (pereodicaly) large ammount of data to my CE database. When tested import on network this take a lot of time. That's why decided to send raw data in ASCII files (because of small size) and to import files to CE database.

Certainly, it's not a problem to write those cli by myself, but it's interesting if someone already did this...

Thanks, Sandr

There isn't a bulk import utility as you might think about BCP, but you do have a couple of options.

1. if the goal is to load a "starter" SQL CE database with schema and initial data, you can setup a simple merge replication with SQL Server 2000 or 2005 and use the AddSubscription(AddOption.CreateDatabase). When you do the first replication, the database is created for you dynamically and rows are populated from the server

2. use remote data access to pull the tables you need from the server with tracking turned off.

3. use SQL Server 2005 Integration Services to perform the data load and any transformations. The only downside to this is the destination tables must exist already in your SQL CE database.

4. write a simple CSV loader in your mobile app to load the data from files you deploy to device as content along with your project. an important performance tip - use a parameterized INSERT statement, call Prepare on the INSERT command the first time you use it, and then reuse this same command on subsequent rows.

Darren

|||does SqlBulkCopy work with SQLEv?

Bulk import data to SQL Mobile

Hi!.

Is there something like BCP utility in SQL CE?

I need to import (pereodicaly) large ammount of data to my CE database. When tested import on network this take a lot of time. That's why decided to send raw data in ASCII files (because of small size) and to import files to CE database.

Certainly, it's not a problem to write those cli by myself, but it's interesting if someone already did this...

Thanks, Sandr

There isn't a bulk import utility as you might think about BCP, but you do have a couple of options.

1. if the goal is to load a "starter" SQL CE database with schema and initial data, you can setup a simple merge replication with SQL Server 2000 or 2005 and use the AddSubscription(AddOption.CreateDatabase). When you do the first replication, the database is created for you dynamically and rows are populated from the server

2. use remote data access to pull the tables you need from the server with tracking turned off.

3. use SQL Server 2005 Integration Services to perform the data load and any transformations. The only downside to this is the destination tables must exist already in your SQL CE database.

4. write a simple CSV loader in your mobile app to load the data from files you deploy to device as content along with your project. an important performance tip - use a parameterized INSERT statement, call Prepare on the INSERT command the first time you use it, and then reuse this same command on subsequent rows.

Darren

|||does SqlBulkCopy work with SQLEv?

Built in monitoring tools.

I am looking for a utility that will give the names of the tables (or the sql strings will do as well) that had data inserted, updated or deleted.
Is there anything like that built into SQL Server?Originally posted by access_dude
I am looking for a utility that will give the names of the tables (or the sql strings will do as well) that had data inserted, updated or deleted.

Is there anything like that built into SQL Server?

u can use sql profiler