Viewing 15 posts - 91 through 105 (of 129 total)
Kenneth Fisher (4/2/2008)
I'm using the fast load as it happens. The slow part is the lookup.Thanks though
Kenneth
Load the whole lot and then do the insert/overwrite trick.
This will...
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
April 2, 2008 at 4:16 pm
MattF (3/31/2008)
We get an error running a SSIS package which calls another package. Both packages execute Ok independently. Error: "The LoadFromSQLServer method has encountered OLE DB error code 0x80040E09 (The...
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
April 1, 2008 at 10:12 pm
Sanata Kumar Nayak (4/1/2008)
Can someone guide me how to achive this?
Requirement is : To backup a table to a file named as filename_currentdate.txt .This is to be done...
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
April 1, 2008 at 9:55 pm
Kenneth Fisher (4/1/2008)
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
April 1, 2008 at 8:01 pm
You are right. It is confusing and they assume that you spend weeks and weeks on digging forums, asking questions, trying before you understand how to _effectively_ and correctly use...
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
April 1, 2008 at 7:46 pm
Thank you. You are right. desc 'viewname' against the view which has calculations and aggregations in oracle gives a bald NUMBER agains the SUM and AVE and NVL and...
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
March 25, 2008 at 3:41 pm
Hey. Thank you for help.
I just figured out. If using OLEDB source you could source the SQL statement from a user variable.
When using a Datareader you could create an...
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
March 19, 2008 at 4:42 pm
Jay (2/29/2008)
I can't find any option to make sql dynamic in data reader. The option I can think of is to use OLE DB Source pass sql command from variable.
I...
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
March 18, 2008 at 7:35 pm
If you really need to use SSIS you are stuffed as you can see.
You need to do something else here. I am thinking about BCP into a dummy table and...
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
February 24, 2008 at 10:30 pm
what da... itd be interesting to hear what microsoft say about it...
I run on 32bit. keep us posted.
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
February 24, 2008 at 6:11 pm
Jeff Moden (2/22/2008)
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
February 24, 2008 at 3:41 pm
J.D. Gonzalez (2/22/2008)
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
February 24, 2008 at 3:36 pm
I am thinking about it, but the management would argue that I am distorting/abusing the concept of ETL, SSIS and all the rest of it.
It would be great if it...
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
February 21, 2008 at 9:12 pm
Valid comment, but it is not my decision to get rid of 2000.
Having legacy atavisms sitting in there and stuff is also not good for me who will be looking...
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
February 21, 2008 at 5:26 pm
Thankx
This IS and is NOT what I wanted to see.
This is a solution but the solution "through the ar$e".
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
February 20, 2008 at 8:09 pm
Viewing 15 posts - 91 through 105 (of 129 total)