Viewing 15 posts - 1,081 through 1,095 (of 7,429 total)
1) Overall because you are doing the ExecuteNonQuery() it isn't trying to return a recordset and it would be similar as to writing multiple insert statements. There is no significant...
February 23, 2006 at 11:04 am
Try using err.raise.
Ex
err.Raise 16, "DTS Step 1", "Path '{Path Name}' could not be found!"
February 21, 2006 at 7:23 am
Not from the files, no. They have to be on an active Oracle instance then you could transfer them.
February 21, 2006 at 7:18 am
What Krishnan is saying is this instead of
Package 2
Package to do work, 1 string global variable
Step 1 ActiveX Script take global variabl value and set Excel Connection object value to...
February 21, 2006 at 6:57 am
However you will have to add delete permissions to the underlying table and potentially open yourself to an injection attack.
2 suggestions.
1) Which I prefer these days
Write a standard Stored Procedure...
February 21, 2006 at 6:49 am
I concur, doing a fresh OS install is much better than upgrade as you may have a lot of legacy stuff left behind you don't need. Starting fresh allows you...
February 21, 2006 at 6:28 am
I assume they are all the same structure. However do you have to make the data available immediately? Or can it be periodicall? Also, which version of SQL 7/2000/2005?
Just dicussed...
February 20, 2006 at 5:56 am
Just to throw in the misconcept possibly is a hold over from a flaw early in ADO where blob fields needed to be at the end of the recordset sturucture...
February 17, 2006 at 6:55 am
The memory utilization is not all that big of a concern unless you have a lot of swapping out of memory (this means a lot of activity on the Hard...
February 17, 2006 at 6:51 am
Size doesn't really cause that many issues. You might need to reconsider you current indexing structure and you might need to do general maintenance of the system such as sp_updatestats...
February 17, 2006 at 6:45 am
I am losing you here. When you say master level exactly where in EM are you looking at?
February 17, 2006 at 6:41 am
Haven't had a chance to see what I can do with it but will look at over the weekend while I have some time and try to give you a...
February 17, 2006 at 6:38 am
Speaking more to having worked with Oracle, DB2, Informix (I believe now owned by IBM and name changed), Sybase, MS SQL Server and a host of other types I prefer...
February 15, 2006 at 7:08 am
OK folks I will chime in becuase I think a common theme is seen here however cursors are simply a tool to handle conditional logic where a set based solution...
February 15, 2006 at 6:59 am
Th question I have thou is why create the temp table at all? Based on the snippet of logic you should just simply left join tbl1 to tbl 2 instead and get...
February 15, 2006 at 6:41 am
Viewing 15 posts - 1,081 through 1,095 (of 7,429 total)