I am getting the following:

Operation stopped...

- Initializing Data Flow Task (Success)

- Initializing Connections (Success)

- Setting SQL Command (Success)

- Setting Source Connection (Success)

- Setting Destination Connection (Success)

- Validating (Success)

Messages

* Warning 0x80047076:...

I am getting the followingOperation stopped...

- Initializing Data Flow Task (Success)

- Initializing Connections (Success)

- Setting SQL Command (Success)

- Setting Source Connection (Success)

- Setting Destination Connection (Success)

- Validating (Success)

Messages

* Warning 0x80047076:...

I used the DTS and put a check in the identy box and got the following, should I savee the package:

Operation stopped...

- Initializing Data Flow Task (Success)

- Initializing Connections (Success)

-...

I received the following from doing this, I used the DTS, from the data I want to copy to the table I want to copy it to, put a check...

I was trying to write the code rather then use DTS, when trying to use DTS, I do not see how you can do an edit unless you write the...

I was trying to use the following script and got an error after adding what you suggested:

SET IDENTITY_INSERT [Etilize].dbo.[Master Table] ON

insert into [Etilize].dbo.[Master Table] select * from [Darlene].dbo.[Abco]

SET IDENTITY_INSERT [Etilize].dbo.[Master...

Can this be done within the DTS? If not can you point me in the direction to see how this is done.

LadyDee

I have a table on our server, I have over 300 tables from our manufacturer's. I am using DTS to copy date from my server to the web server....

The SyncItemMaster.xml is too large to even open in BI, there is also a SyncItemMaster.xsd

Thank you for your assistance

Ladydee

The main xsd file when I try to read it in it states that it is too large.

Here is a little information on the files:

All files in the folders below...

I do not see where it can do XSD or XML files. I know how to do T-SQL's etc using SSIS.

Thank you

LadyDee