I would say you have opened the wrong solution, either the solutions do not match the book, or someone has modified the solutions.

Do you have the book CD and reading...

for example

Page 47 - Chapter 2 SQL Server Import and Export Wizard

Point 7 - In the control flow double click the preparation sql task

If you read the rest of the...

which book are you reading from?

There is no "Prepare SQL Task" it is "Execute SQL Task"

Hi, the below should get you want you need based on your details.

If not, please follow the second link in my signature on how to post code and data so...

Duplicate post, didn't see this, this morning when looking through the topics

http://www.sqlservercentral.com/Forums/Topic1313689-145-1.aspx#bm1313709

change the FROM clause to point to your table in question

so you will need the following rules

LocalIPAddress on ANY port to RemoteIPAddress Port 1433 -- Local Firewall

RemoteIPAddress Port 1433 to LocalIPAddress ANY port -- Remote Firewall

Probably a better way to do it but heres my first quick go

declare @tab table (filepath nvarchar(100))

insert into @tab values ('H:\FOLDER\123456\document1.doc'),

('H:\FOLDER\1234\document2.doc'),

('H:\FOLDER\98765\document1.doc')

SELECT

Filepath,

LEFT(REPLACE(filepath,'H:\Folder\',''),(CHARINDEX('\',REPLACE(filepath,'H:\Folder\',''),1)-1))

FROM

@tab

Nope, SQL wont allow files to be on network drives, they have to be on local storage only.

Is that IP external facing or internal facing?

Do you know the port numbers the server is using? http://support.microsoft.com/kb/287932

Do you have a SQL authentication account ready on that server to login...

A self join will do the trick

declare @tab table (name nvarchar(100), MemberID INT, PrimaryID INT, Expiration DATE)

insert into @tab values

('John Smith',1024,null,'2013-01-01'),

('Mary Smith',1025,1024,'2013-01-15'),

('Jim Smith',2033,1024,'2013-01-18'),

('Kate Smith',2100,1024,'2013-01-17')

select * from @tab

UPDATE t

SET...

Does the remote SQL server have an external IP address? If not it needs one, or you need to put some routing in place which routes SQL packets coming...

Depends on how you want to connect to SQL.

There are two main options

1, get a machine on the remote site which you have RDP access to and have SSMS installed...

First, please may I say that you need to switch caps lock off.

Second please follow the second link in my signature on how to post code and data for the...