Hi,

What is the error message you are getting after changing the values in configuration files and running , because that is how it should be...May be a permission problem..

-VG

Hi,

Did you copy the configuration files from test to development. Make sure you change all the values here...connection string values etc....At run time the values are taken from this configuration...

Hi,

The configuration files are not copied, when you copy or deploy packages. You need to copy Config files seperately and set up however it was set up in production....

My Suggestion would be to select only OnError event. So, only if error happens, it get logged..

VG

Try to declare a local variable, inside the script and assign global variables value to it and use this variable to update or whatever you want to do..

You have to...

Hi,

If you are looking for solution for this in SSIS, then try exploting File System task in SSIS.

VG

Greg, Thanks for sending the link for upgrade advisor for sql server 2008. I am going to try that...

VG

It is happening after upgrading to compatibility 90.

I found it to be a UNION issue...Each brach of union cast to result type of union and then cast to the target...

Sorry, I don't know much about this...Ask a seperate question in this forum....

VG

I never noticed it..Good to know..Thanks Alan ...

VG

I don't know this is possible in SSIS.

What we did similar is scrubbing the data based on some date range, we use this for demo and local installation rather...

FOR GLobal variables:

in script component, "readonly variables" type your 2 variable names...gvVar1, gvVar2

Decalre local variable inside script component,

Dim sCol1 as string = Me.variables.gvVar1

Row.col1 = sCol1 (Col1 is your source column)

2nd...

What is corresponding IsStatusID source column ? .....Map this column ( output from script component) to destination column in destination . Script component is transformation between source and destination...

First option.

Source - script - destination.

'crdt_hd_indcr' is this a variable or column in a source ? IF it is a source column, the moment you type Row, all the...

You have to use script component transformation for this. Connect o/p source to script component,

then inside script component,

IF trim(Row.crdt_hd_indcr) = "Y") then

Row. iStatusId = value

else

Row. iStatusId ...