applied dts files to sql server

I have a file named "posting.dts" in my c:\test\ directory,
how do I write a script to apply this dts package to SQL server "server1"?
thanksWhy do you need to write a script?
Can't you just right-click the Data Transformation Services folder in
EM and Select Open Package.
You could then browse to the .dts file and do a save as and save on the
Server?
Barry|||but i have many dts files, I want to apply them automatically with scripts.
I know how to apply dts script manually.
"Barry" wrote:

> Why do you need to write a script?
> Can't you just right-click the Data Transformation Services folder in
> EM and Select Open Package.
> You could then browse to the .dts file and do a save as and save on the
> Server?
> Barry
>

Applications without install SQL Server

Hello all
I write a program that use sqlclient to connect to SQL Server 2005 Database
so how can i run this program on a computer that SQL Server 2005 is not
installed on it
cause it's too much for the customers to install SQL Server 2005 express
edition it takes too much time and space
i think if i can take the library files and make a virtual registery on the
client PC it must works
but i don't know how to make it
please help me as soon as possible
and thanks
Use the native client redistributable and redistribute it with your
software. Download it here:
http://www.microsoft.com/downloads/d...displaylang=en
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Abood_aa" <u16990@.uwe> wrote in message news:5970150f4c114@.uwe...
> Hello all
> I write a program that use sqlclient to connect to SQL Server 2005
> Database
> so how can i run this program on a computer that SQL Server 2005 is not
> installed on it
> cause it's too much for the customers to install SQL Server 2005 express
> edition it takes too much time and space
> i think if i can take the library files and make a virtual registery on
> the
> client PC it must works
> but i don't know how to make it
> please help me as soon as possible
> and thanks

Append Data

Hi, i need some help as i'm not good with SQL. I have 2 databases n SQL and i'm trying to write a rountine were it inserts all the new data from a live table to another table in another database.

Is there any way how to do this?

Once i have figurered that bit out i need to run the rountine every night automaically.

I would really appreciate if you have the answers for my questions

Thankyou in advanceinsert
into anotherdb.anothertable
select *
from livetable
where data = 'new'|||insert
into anotherdb.anothertable
select *
from livetable
where data = 'new'

You funny

What the DDL look like?|||We've had a topic name change - ANSI SQL - Yay! :D|||You funnyi are oney tryna be hepful :angel:

i used all the available information in the oiriginal post!!|||R937: Is the "anotherdb" from your example code a user (as in Microsoft/Sybase), a schema (as in Oracle/DB2), a database (as in MySQL/Pervasive), or something different? I guess that my point is that your code as presented will do slightly different things, depending on which database implementation is used to execute it.

-PatP|||PatP: yes :)|||Rudy's query works in DB2 even if both tables reside in different databases (not only different schemas) - DB2 for z/OS, that is. ;-)

The interesting thing is that ISO/IEC 9075:2003-2 is very, very vague about what a "database" actually is. This results from the fact that different DBMS vendors apply this term to different concepts (and DBMS vendors drive the standard).

@.Hemish: you should be a bit more specific what you mean. Do you refer to schemas/schemata or federation?|||Instead of writing a query you might be better using the backup tools available for your particular database system. For MSSQL you can set up nightly backup jobs using the scheduling tool that is available. In MySQL you can use the Mysqldump utility (from cmd line) to run a backup, which you could schedule using a cronjob (if unix) or windows scheduler (if win).|||Backup tools are not standard SQL, of course...|||Backup tools are not standard SQL, of course...Yeah, Standard SQL doesn't support backups (literally true, since backups are only supported through vendor extensions, the standard definitions don't provide any references to backups).

-PatP