Hi Grant,

Like I said, the problem is I didn't take backups (this was just a test server).

Within the C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA folder I do have the MDF and LDF...

Update on this seeing as nobody has a clue:

Am creating a "Primary Key Mapping" table which takes the original "varchar" key and maps to new INT key.

Any new inserts to...

I honestly thought with all the expertise out there that someone would know the answer to this fundamental question:

"How does SSIS (SQL Server 2012) handle Sequence objects in Slowly Changing...

Lowell,

Yes I know this - an error on my part and realised it as soon as I posted.

Here is the basic SQL to create sequence, create dimension and populate dimension...

... sorry I was unable to create URL link to screenshots

Basically, I need advice in how best to use SCD transform in SSIS 2012 in conjunction with a PK using...

Here is the SQL to create Sequence, destination Dimension and initial Dimension population:

Here is the screenshot (combined) showing the set up of SCD wizard:

Here is package error screen:

Hi,

I have just run the package again to extract the error.

I made a simple change on one column at source to demonstrate the problem.

Here is part of the error:

Hresult: 0x80004005...

If trace is default then this code is handy to disable:

SELECT @@ServerName, * FROM :: fn_trace_getinfo(default)

EXEC sp_configure 'show advanced options',1

RECONFIGURE

GO

EXEC sp_configure 'default trace enabled',0

RECONFIGURE

GO

EXEC sp_configure 'show advanced...

sorry it didn't encapsulate the code snippets.

Here it is again:

Report Properties.Code

Private LowVal as Decimal, HighVal as Decimal

Function SetHeatMapRange (LowValue as Decimal, HighValue as Decimal) As Object

LowVal = LowValue

HighVal = HighValue

End...

Thanks Perry - I'm personally trying to push for this approach.

Net Admin initially said that these methods can be resource-heavy and the preference is Tokenisation. However, having examined the server...

This is quite a good starting point, although BOL does have some decent guides on this subject.

Yes I thought so and I understand the decryption issue. With regards to encrypting in application do you mean that a similar methodology to that in SQL Server could be...

so how would you ensure PCI Compliance by protecting the clear text information being passed to server from application?

ok Gail works fine thanks. Noticed couple of things after the process completed:

a) The mdf data file could not be shrunk below it's new size (approx 1GB)

b) The log file...

ok thanks Gail - just one last thing however - failed to mention that I have already shrunk the mdf.

Will the action you suggest work ok in this scenario?

i.e. will...