It's not that I don't think it can be stored there.  It's more the power of storing them in the database.  Seems like the new way, the admin would have to...

Right, but I'm speaking more on values that need to be stored in the DB.  I get the parameters part  but I need to have parameters that get their values from the...

Because I need the keys to insert into the second table

Hi Drew,

Thanks for your response. Unfortunately no. The other process is designed that way because there are other processes (much like this stored procedure) that will be working...

Thanks everyone for your responses. This helped.

Strick

I'm using SSIS 2008

Wow really? Is your birthdate column in "2008-09-01" format? Also they are in DT_WSTR data type when they come in.

Thanks for your help,

Strick

Hi,...

Hello,

Another thing I just thought of: Where was the data prior to getting it in a recordset? Reason I ask is because you may also be able to...

Hello,

If I'm understanding your question correctly, this actually can be done. First a question,

Are you using a recordset destination and saving the data to a SSIS object variable? ...

Hello,

I believe Oracle can use OleDB. Also, I know Oracle has a .NET provider as well. I know it comes packaged with SSIS 2008 and I believe it...

I believe you are using AND qualifiers instead of OR. With AND all conditions must be true. Looks like you should be using an OR qualifier:

([Table1] == "Y"...

Hi,

Not sure what "protection level" is. Can you elaborate on what that is?

Thanks,

Strick

Ok thanks for your help.

Strick

If the "good" data doesn't start until the 3rd column, then you actually don't need a script task to correct this. You can just use an excel source, your...