View Complete Post
State management in Web applications is a contentious issue. Should you store user data per session or should you persist it across sessions? You can easily store information temporarily while someone navigates your site by using session state.
MSDN Magazine April 2006
HiIm currently working on a project where i have a form that users fill out in order to submit issues.My ask is to give the user the ability to upload multiple files together with the form submission and also go back each time they have an update and upload more if they need.The way i have it right now is that i only have one FileUpload Control and once the Save button is clicked the file is save in the database together with the form info. I already has a separate table for the files with reference to the ticket but im just not sure how can i allow the user to submit as many files as they want in an easy way.Any ideas?
I will need your advice on a SSIS package which moves IBM DB2 (for z/OS V7) data to Oracle (AIX 10g). Thank you in advance.
Basically, this is a very simple SSIS package (created by SSIS import / export wizard) and just maps column by column. I used IBM OLEDB provider for DB2 to connect the source and Oracle Provider for OLEDB to connect to the destination.
The problem I ran into was that if the DB2 source value contains special (or invisible) characters then this value will be converted to a SPACE (' ') value on Oracle. To be more detailed, take the following example:
On DB2, value 000002D0000002D7 (EBCDIC HEX codes). This is actually a value of a column defined on DB2 as CHAR(8). Please note HEX '00' in EBCDIC stands for NULL and HEX 'D0' stands for character 'K';
On Oracle, this value will be stored as a SPACE (or a string of SPACEs) after data move.
On both DB2 and Oracle this column was defined as CHAR(8).
I guessed this was related to a code page issue, so I tried a few different code page to set for the source property (by setting the DefaultCodePage of the DataFlow source property), I used code page 37, 500, etc... All resulted in the same Oracle value.
The character set on DB2 is EBCDIC and the one on Oracle is ALT32UTF8. I guess it was the source provid
I have placed a script task in my SSIS project, package.
When I click Design Script button, script editor is not opening, instead its returning to Control Flow. But no error.
What is the problem?
I just created a new folder in D:\ drive with the name My SSIS.