Why storing the ssis at the File system level instead of the server? Storing packages at the file system is a security problem. A better way will be to store...

Change [Sch_AuditDdl] to proper schema most of the time (dbo).

or create a new schema with name [Sch_AuditDdl]

Please ensure than when create object didn't create a separate schema using the user login. The error means or the object doesn't exist or there is a mismatch on the...

How the data will be store, used and extract that depends on your application, the word nasty is not the word I will used when I don't understand or disagree...

Its sounds like the file generator ( The app that created the file ) is using unicode instead of ascII, verify that the file format its ascii and not unicode.

This will be a way to save relations from a table.

--Create Table to store constraint information

IF NOT EXISTS (Select [name] from sys.tables where [name] = 'T_FK_Xref' and type = 'U')

Create...

Here is a better example of how to restore the indexes :

If Exists (select distinct

SchemaOwner

,TableName

,AllColName

from tblDBAIdxMetadt

where IsClustered = 1

and UniqueType 'PRIMARY KEY'

)

begin

declare @IndexName varchar(255)

...

See scripts Truncate all Tables There you will find a script to save and restore the table relationships. Normally you want to keep that kind of data separated from it.

declare @cmd varchar (max)

Select @cmd= "Create index "+IndexName + "......From tblDBAIdxMetadt

exec (@cmd)

You got the idea 🙂 I will post a better Query tomorrow.

good stuff

Hey I post the below code but here it is :

enjoy

use master

go

SELECT

percent_complete,

start_time ,

command,

b.name...

Glad to help

One of the problems that I see a lot is that when trying to restore the relationship there are orphans on the tables. Ensure that all the foreign keys from...

What's seems to be the problem

Very good information on the link. Like the Blog stated there are many ways to aproach and problem..Thanks for the input.