Thank you very much for the useful tips. Great information.

Thank you very much.

As you already possibly have figured out the error message is indicating that it cannot connect to the Server/Database. I would double check the SSIS Connection Managers

You would :

1. Add data flow

Within the Data flow

1. Add a Data Flow with the SQL statement pulling in the data from the database table

2. Add a Derived Column Task

3....

You could use a Derived Column task in the data flow and write a nested Conditional IF statement. I do not have acceess to SSIS right now so posting a...

Apologies for the different user name on the reply - I had sent it from some else computer

I have implemented the following code in the data flow task:

(DT_DBTIMESTAMPOFFSET,0)DATEADD("ss",-DATEPART("Ms",GETDATE()),GETDATE())

And appled the Error on truncation to Ignore.

----------------------------------------------------------------

(Edit)

SQL SERVER:

SELECT CAST(GETDATE() AS DATETIMEOFFSET(0));

SSIS:

(DT_DBTIMESTAMPOFFSET,0)DATEADD("ss",-DATEPART("ss",GETDATE()),GETDATE())

Both of the above seem to give...

Thank you for the suggestion. That does not work as the package fails when it tries to INSERT the record

Hi Phil,

I am building a SCD 2 package and there is date field for current records and expired records where I have traditionally used a GETDATE() funtion to populate them...

Thank you .. this is much better than the cursor option which is there at present!

Your help is much appreciated!

Jason-299789 (11/14/2014)

---

One alternative to the unpivot is to use the Cross apply method.

DECLARE @t table (Col1 char(25), col2 char(25),col3 char(25))

INSERT INTO @t (col1, col2, col3) VALUES

('AB' , 'BC' ,'DA')

SELECT

Cav.Value

,CASE...

Hi Jeff,

Thank you for your thoughts. I have been trying to make it set based but having no luck with the syntax. Do you have any suggestions please.

Thank you

HI Thank you .. I have amended the code to get it working for getting the data from a table .. many thanks for your help!

DECLARE @t table (Col1...

Thank you

Thank you for your help Phil. I will try this method out.

Your help was much appreciated!

Thank you for your reply Phil ..

From your experience can you get Project Level parameters to be used in SSIS expressions along with other variables?

So you it be the...