ok,, I came up with this as a possible for the derived column expression..

YEAR(CholesterolResultDate) == 1901 ? NULL(DT_DATE) : CholesterolResultDate

I haven't checked it running yet, but I thought I'd...

Hi,

I am having a similar problem, except when I imported the rows, it will check to see if the value is null and if it...

Well even if I run it manually it won't get the config data from the sql configdb.

So possibly there is something wrong other than what I am thinking?

I'm...

Hi, I've been working with Randy On this. The package encryption level was only set to EncryptSensitiveWithUserKey while it was being edited and for testing. I tried a...

Ok,, for a script task I got it..

Dim myFlatFileConnection As String

myFlatFileConnection = _

...

there might be more than one way.. but I might put the code in a try catch.. the last line in the try can do something like " Msgbox("Got...

ok,, here's how I did that..

1, setup your variables in the ssis package like you suggest.. then on the properties of the variables add an expression like this.. @[User::Email]...

I am working on something similar now.. here's an additional option using sql proxies.. look down on this link.. the user Abha had some suggestions..

hmmm... I had a similar problem.. or I think it was similar..

and I went to the sql server agent service in services on my pc and change the "Log on...

Ok, I got it.. here't the change to the last code.. the thing here is that I am using an on error event handler that adds each components error message...

ok.. that was very helpful.. It is committing or Rolling back now, but I can't catch the right part of the ComponentMetaData that is changed when an error is generated...

Ok, I was trying to avoid that a little bit becuase it's probably more info than you need, but I can definatly see your point about is seeming "scattered".. so...

Ok, I backed up and made my own connection and added it to the script component. Then I used a couple of different variations trying to start a transaction...