You can't actually roll back as such in SSIS (as far as I know), to achieve what you want you would need a "File System Task" to run if...

I figured it, I was trying to use a trigger as I thought the contraints would only work over 1 field at a time, but this is not the case......

Hi thank you for your reply, to clarify the combination of these two fields must be unique not both being unique. I will look into the instead of trigger but...

We struggled with this exact same issue and came up with a function which is used/called in the sp you are wanting to run;

Function:

USE [LIVE]

GO

/****** Object: UserDefinedFunction [dbo].[funcParseInputStringToTable] ...

This worked perfectly! Thank you all for your help!

Figured it, Brandie you were right!... code full code below;

Use [udbDATABASENAME]

Go

DECLARE @SchemaName NVARCHAR(255)

DECLARE @TableName NVARCHAR(255)

SET @TableName = 'tblmyTablename'

SET @SchemaName = 'dbo'

SELECT

myTableA.SchemaName,

myTableA.TableName,

myTableA.ColumnName,

MAX(CASE myTableA.PropertyName When 'uepBusinessName' Then [myTableA].[PropertyValue] Else NULL END)AS...

The full actual code is:

Use LIVE

Go

DECLARE @SchemaName NVARCHAR(255)

DECLARE @TableName NVARCHAR(255)

SET @TableName = 'tblmyTableExample'

SET @SchemaName = 'dbo'

SELECT

sys.schemas.NAME AS SchemaName,

sys.all_objects.NAME AS TableName,

sys.all_columns.NAME AS ColumnName,

sys.extended_properties.NAME...

I would download the 14 day of the red gate tool, specifically the documentor as it gives all that info and more in a dynamic HTML format which can be...

You might get a better response if this was in the Reporting Services 2005 forum, however the only initial way of doing this is to have then detailed in a...

I hope this might be of use, we use the following function to breakdown the delimited list and then pass in our sp using cusors;

/* THIS FUNCTION IS RELATED TO...

The second value will always go backward as all our reporting will be historical although if we can go forward as in your example that would be great, but the...

Okay I the solution and think I know why (to a degree), the issue is about how the functions handle times... In short using another function I have called funcDateOnly,...

We do actually run some server maintenance tasks weekly, such as disk clean up, defrag etc, but ironic that the benefits that I get from a defrag were probably outweighed...

Cheers for the feedback, very interesting article indeed! I have modified my plan accordingly, removing the shrinking altogether...

The tools on VS (in my opinion) are rubbish and border on useless. The best tool I use ironically is the tool advertised on the banner of this website. The...