Something like...

If you have some very important tables  ie Sales, that have frequent inserts/updates then your backup strategy should change, if your database is a bunch of slowly changing...

Try OPENDATASOURCE .'

From Books Online

Provides ad hoc connection information as part of a four-part object name without using a linked server name.

Remarks

The OPENDATASOURCE function can be used in the same...

In Enterprise manager.

Right click on the job, select all tasks Generate SQL script

Select Convert(char(12),getdate(),107)

Dec 07, 2005

What extra space do you speak of?

From books online

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp

The table in the page indicates the format and what # you should use to get that format,...

Sounds like homework, U should do it yourself.

Junciton tables should be created with foreign key constraints to "Referencing tables" as Drivers and Cars

Drivers_Cars

ID,

DriverID References DriverID in Driver

CarID References CarID in...

What was the error?

go to the data tab, and Select the dataset this field is in. and Click the Refresh Fields Icon.

Then click the elipses (...) to edit the dataset.

Does...

Read this from books online

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_08_0lo3.asp

When an after trigger exists, then sql server uses virtual tables called inserted and Deleted,

Inserted are the values you want to update to, deleted are...

Yes you should be able to do it no problem.

Are you trying to bind both datasets to the same Table? Because if you say yes, then you cannot do...

First off, is the Origination server have the data of record? meaning, there will NEVER be inserts into the destination server table from any other source than this dts package?

If...

Question,

From your dataset Filed!Phone.Value what does this look like?

What do you mean you need to parse it out.

This is corrected if your doing it in t-sql (substr) is...

or

Select Case when charindex(',',Artist) = 0 then Artist else left(artist,charindex(',',artist)) end

Or run 2 queries

select left(artist,charindex(',',artist))

From Mytable

where left(artist,charindex(',',artist)) > 0

union

select artist

From Mytable

where left(artist,charindex(',',artist)) = 0

Best option is something like this

Declare @StringDate varchar(10)

set @StringDate = '12/15/2005'

select replace(convert(varchar(12), convert(datetime,@Stringdate), 6),' ','')

You cannot perform your query using servername as a parameter,

Link to dynamic sql, but you still cannot use a variable servername, Look towards the bottom of article, and look...

It will help in the fact that the indexes you build on each table will be smaller.

But will mainly help if you query by the item you separate the tables...

A little difficult to discuss in a forum

Check out this Tut

http://www.sqldts.com/default.aspx?278