There is absolutely no doubt that a set based stored procedure would perform this task better than a procedural DTS package......as it sounds like you have.

DTS has never been...

If this is really required, and a set based operation is not an option, then another way to do this would be:

Create an Int variable and set it to 0

Creat...

You have a couple different options for this......you can create a linked server to the file, through script, and then query the lines of text for the line like DN,...

You would need to use two statements I would think, and the tableb one you use above as an example, would surely be an inner join, not a left join...

I apologize. I was out sick yesterday, but I have your scripts for ya. Where do you want them sent?

You should figure out which of your joins is causing the duplication (as that's most likely the issue), and modify your query to remove it....

For example, if one of your...

there ya go.....and thanks, you saved me searching....

Let me get home tonight, and I'll post you a full set of scripts to do this, step by step, and with the correct params....

the subscription has to be deleted....

You cannot do the 

 @pre_creation_cmd = N'drop', 

Or the

@force_invalidate_snapshot = 1

as these will force a rebuild....

The structures have to already be built on both db's....

then you...

Kory's method will get you what your trying to do, and is the way I would go about what you want.

Just for informational purposes, though, I will post the bitflag,...

Sounds like your typical end of line character.......which would be CHAR(10) and/Or CHAR(13)

The trick to this is in doing it by script.....If your using the wizard, it can't be done.......

look up sp_addarticle in books online.......and of course, if you still need help,...

I'm a 26 year veteran who pretty much wrote the book on "can't be done"......My question is are they willing to pay for it? I have a very high bill...

As simple as it seems, the name is, in fact, all there is to it.....other than a bit flag you would have to decode to use.....trust the name, it won't let...

A few years ago, I had a requirement to drop indexes while a full refresh of data went on for importing purposes. I had to write some scripts to store...