You need to use an SCD which can update the name record based on empno.

are you using ssis for this

if so assign the date variable using the result set mapping in execute sql task

use this variable further

if you are more specific about your requirement then probably we can help you.

The answer for your question is yes we can do it.

One more option is try to reduce the buffer size in the package.

hey can you just post a screen shot of the data flow task. I think that should help us.

and when you are running the package go to the last...

Use config files to store the connection strings and set the package protection level to Don't Save Sensitive

You cannot cache a 2 billion records table. If you are trying to do so then there will be a buffer swapping issue and the package execution will slow down.

if...

try this

(PROC_DT == "00000000") ? NULL(DT_DATE) : (DT_DATE)((SUBSTRING(PROC_DT,5,2) + "-" + SUBSTRING(PROC_DT,7,2) + "-" + SUBSTRING(PROC_DT,1,4)))

keep in ragged right mode and take the entire row as one column specifying the maximum length of row as the column column. Next add a derived column transformation and...

yes make it a stored procedure and pass the file name as parameter

since the value is available in stored proc you should be able to do whatever you want to

Check if the variable is getting assigned with proper value returned from oracle.

Where are u assigning the value to the variable

hi this link gives the information on how to link parent variables with child variables

http://www.sqlis.com/27.aspx

and secondly i think there is typo in the reply

Create all child packages with...

Use a BIGINT Data Type as destination and try it

U can use the variables of a different package in other packages

have a master package which holds the values of connections and values

Have all other packages as child packages with...

you can use script task as source and change the bad formatting

in Script task read each line through stream reader

Use the split function of string. Since the split function will...