I put everything on 1 line:

CD C:\RefreshTestFromProduction\SSIS\Drop_Constraints_629 Foreign_Key_ConstraintsDrop.dtsx /COPY SQL;Drop_Constraints_629 Foreign_Key_ConstraintsDrop /DESTSERVER "PRODDATA6"

I get the error 'system does not recognize the path specified'

Any ideas?

I tried executing the following from the command line:

CD C:\RefreshTestFromProduction\SSIS\Drop_Constraints_629 Foreign_Key_ConstraintsDrop.dtsx

/COPY

SQL;Drop_Constraints_629 Foreign_Key_ConstraintsDrop /DESTSERVER "ServerName"

I get the following error:

'SQL' is not recognized as an internal or external command

What is the correct...

Post moved to SSIS.

http://www.sqlservercentral.com/Forums/Topic1779379-364-1.aspx?Update=1

I specified SQL Server and the path within MSDB.

I click next and it displays a Windows path.

I added a package just prior to this and it worked fine.

I probably need...

I had changed the protectionlevel property to Don't save sensitive but I did not save the package\project.

When I use .ispac I get an error that it failed to encrypt and XML node.

When I click build it does...

I'm using the manifest file.

Thanks.

TheSQLGuru (4/7/2016)

---

SSMS Options-Scripting. Scroll down and triggers is one of the options that is OFF by default. I ALWAYS turn this on, along with indexes and a few others.

After...

P Jones (4/6/2016)

---

For those who don't know, the database diagrams in Management Studio are a good way of visualising the relationships set up between tables - just add a table...

I have everything taken care of.

Thanks.

I discovered that if I perform a Truncate I do not get a table name but if I do a Delete from SSMS I do get the table name.

I would...

ok, I dropped the constraint but sometimes the error message does not include the table name.

ok, I'm missing something?

DELETE

FROM Postal_CountyRegion

Msg 547, Level 16, State 0, Line 2

The DELETE statement conflicted with the REFERENCE constraint "FK_ContractorCoverage_Postal_CountyRegion". The conflict occurred in database "PrData", table "dbo.ContractorCoverage", column 'CountyRegionID'.

The...

My bad. I thought that I delete would work.

The delete works sometimes

I execute the following and I get a FK error:

DECLARE @ServerName VARCHAR (25)

SET @ServerName = @@ServerName

IF @ServerName = 'TESTDATA2V'

BEGIN

---...

Phil,

Thanks for your input.

I had already tried deleting before making this post but I got the same error.

Do I DROP the constraint from the referenced table or the table I'm...