Michael is right!

You have to SCD(Slowly Changing Dimension) to get your thing work. You wanted SSIS to detect the changes...........This is the only transformation that will help you. This...

It is the source data. There were some datas with dd/mm/yy and some datas were dd/mm/yyyy format. the one with yyyy comes okay after conversion but the one with only...

You can first write a SQL command to execute whatever updates you want in {Execute SQL task}. Drag and drop this in the design section and connect to its database....

Yes, i can. But how do i put it together in the package wizerd though?

No. we use citrix to get in there. Thats totally a different network.

Marek, This is great. I never knew this can lead in a package migration wizard. Well, my problem is, the other server is not at all connected to my developer...

Is protection level of your package set to EncryptAllWithPassword? YES

Is package supplied with PackagePassword? YES

Is package deployed and you have all files (.dtsx, .SSISDeploymentManifest and others) i deployment directory?

I...

Hi Smith,

I added a derived column transformation and added the expression as per your advise as below:-

"ISNULL(Date) ? NULL(DT_DATE) : (DT_DATE)(SUBSTRING(Date,4,2) + "/" + SUBSTRING(Date,1,2) + "/" + SUBSTRING(Date,7,2))"

I get...

Tried using the Query that you have given,It return me Date as

2007-10-29 00:00:00.000 .Which is in YYYY-MM-DD HH:MM:SS format.I need the Date in MM/DD/YY.

Hope someone could help me out...

Hi,

I would be really grateful, if you could guide me through the steps that I need to take.What do I use CONVERT @ CAST ?

SQL Server service account. Well, How do I bring the total package over in to the QA server though? It is still failing. I tried package config. But when this...

Anyone? Help is needed here..........

Actually mine is very complicated than that. But thanks though. I have tried your way, it worked. But I am doing a FTP download to Flatfile. There is a UID...

Basically what you have done here is getting the job running from the old ssis package path.

Here is what you need to do:

1. File>save copy of.......as(give a new path...

Thank you,

I used an Update statment and replace to remove "".

Managed to solve it !