Viewing 15 posts - 1 through 15 (of 29 total)
Thanks Eirikur. Please suggest how to test the parameters or the proxy. So that I can inform the concern team (firewall team) with data.
May 25, 2015 at 11:49 pm
Hi Aaron,
We are getting the incremental load from source table. So we are maintaining the same structure as the source tables.
In this senario, insert into tbl_Department or tbl_Employee or both...
January 6, 2014 at 7:14 am
Thanks Tibor. Few questions are coming in my mind. The volume of data in source (for actual tables) is too high. So we are planning for a staging layer in...
January 5, 2014 at 11:57 pm
Hi,
In my scenario, I'm joining two tables and loading to single table in target. Will merge will help? Please suggest. If not any other work around is appreciated.
Regards
Jim
January 2, 2014 at 11:36 pm
Hi Bhaskar,
In my case, multiple sheet is not preffered. Is there any way to rename the CSV column header. It is giving text box names now. For ex, Emp_Name1 but...
December 12, 2013 at 3:57 am
Hi,
I tried the "DataElementName", but it is not allowing me to enter space. For ex, 'Employee Name' is not allowed. I changed the "DataElementStyle" to Element. But still it didnt...
December 11, 2013 at 4:37 am
Hi Lutz,
The requirement is something like this, there is a grouping on column Item. Each Item should have an Inventory value. This should be picked from the set of Items....
November 17, 2013 at 5:16 am
Hi Steve,
Where clause will not help. I don't want to delete the EMPID 1 where departid is NULL. I want it to get merged with the EMPID 1 where departid...
November 15, 2013 at 9:25 am
Thanks. But the challenge is, say TABLEB is dropped from the database and it is still used in the procedure. So if I compile the procedure, it will not throw...
October 30, 2013 at 4:34 am
Hi Luis,
I think this is not working properly when the column is ending with space ' '.
Sample data
'ABC DS.'
'AD.'
'DG@'
'DGC DS '
'fdsf fs/'
'fs fds //'
October 18, 2013 at 10:10 am
Thanks Koen!! This is perfect. But now there is a small change, there should not be any special character at the end. Could you please suggest..
October 18, 2013 at 8:36 am
Thanks! The problem is solved by increasing the space...
October 18, 2013 at 12:52 am
Thanks again Koen!! The package is a loading data from oracle to SQL server from 5 tables with each table of 200,000 size approx. Using Oledb providers. The 5 queries...
October 11, 2013 at 5:50 am
Thanks Koen. So if I increase the destination database size or the disk space, the package load performance can be improved? I'm asking this because if increasing the size will...
October 11, 2013 at 4:23 am
Viewing 15 posts - 1 through 15 (of 29 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy