I am doing snapshot replication and transaction replication but I have tried dropping with the SQL Syntax and that did not work. And the other fix is only for...

Yes. So you can only import one table at a time with Identity insert on? So If I need to import 50 tables I have to do each...

After working with Microsoft on this problem for the last month or so it has been determined there is a bug and currently no fix in the works since this...

Thanks for your suggestions. I was trying to get transactional replication to work with Merge replication but found out that is not possible. You can only use...

Thanks for your help. I figured out why it wasn't working.

So I can create the destination but when I run the package it tells me the destination does not exist? Normally I don't have to have the file created...

Never Mind. I figured it out and that worked.

Thank You so Much

Where do I create the variable?

When you say user destination to you mean in the Flat File Connection Manager? Or isthere somewhere else? I tried typing it in there and it doesn't work.

Thanks All

Here is the link

ms-help://MS.SQLCC.v9/MS.SQLMobile.v3.en/SSMProg3/html/5719d3e4-14db-4073-bed7-d08f39416a39.htm.

One more question, What if I want to change a column to allow nulls that currently does not? There are no foreign keys against the...

I appreciate the reply but unfortunately I tried that and it still does not work.

Already tried all of that.  Still isn't working

This doesn't tell you what you are actually using just what your file size is.   I found what I was looking for SP_Spaceused.

Thanks for your reply.

Thanks for the reply.  I actually figured out what it was.  The server needed to be set to cross database chaining.