John

Thanks

Well I have tried the following and the package will insert the data but it will not assign the Practice ID column according to what the global variable is. I...

Explain how "MSDE is Creaking along"???

With Merge replication you will still have to manage your Identity columns by setting up Identity ranges.  You could however set up a composite key based on for example :...

Was wondering if ThomaH's response actually worked?

I believe what happened is that you can view the various publications within the your Distributor machine locate underneath Replication Monitor. What occurred was that the actual publications could be...

Hate to be a pain, but would I convert it to VB.

The sql Bombs. Its looking for two arguments in the left function. Here's what I have so far:

INSERT INTO dbo.Amisys_MMembInfo

...

The sql Bombs. Its looking for two arguments in the left function. Here's what I have so far:

INSERT INTO dbo.Amisys_MMembInfo

...

Do I know need to remove the text connection and create a Workflow - on completion from the Active X scrip directly to the 2nd connection which happened to...

Here is a way to run through a web app:

<%@LANGUAGE="VBSCRIPT"%>

<% ' Create Variable for update

Dim dtsID, DTS_SP

dtsID = Request.QueryString("dtsID")

DTS_SP = Request.QueryString("DTS_SP")

%>

<%

set conn = server.createobject("adodb.connection")

conn.open = "dsn=wow;uid=uid;pwd=pas;"

SQL...

Try this I just got through doing the same thing:

EXEC master..xp_cmdshell 'Replace with job script under'

Example:

One way to get the dtsrun command line is to use Enterprise Manager. Right...

Sorry I am a newbie to DTS, I am using SQL 2000 Where is the DataPump Task located? I can't find the Icon for it!

quote:

---

The reason why I want to create a text file from the query is so that I can Define the transformation between...

The reason why I want to create a text file from the query is so that I can Define the transformation between the source (results from query) to the destination...