Viewing 15 posts - 211 through 225 (of 341 total)
Here is the quote from the article:
As you can clearly see, DatabaseName is set to NULL in a couple of instances. This setting identifies ad hoc and prepared SQL statements....
June 10, 2008 at 8:14 am
Tamilselvam.M (6/9/2008)
its control flow task know...i want to store the result in destination table..that can be done in dataflow only know..
You could make a slight modification to the SP and...
June 10, 2008 at 7:56 am
It sounds like the values you are trying to pass to the SP in the package are not making it there. When you have the package open in BIDS, does...
June 10, 2008 at 6:58 am
Is it giving you an error or just not running at all? Does it work in BIDS and only failing in SSIS?
June 9, 2008 at 10:39 am
In the web sites I have developed in the past, I create a dedicated SQL Server user and assign only the necessary rights that the page (or site) will need....
June 9, 2008 at 10:13 am
bullcrap420 (6/5/2008)
SELECT a.EmployeeID
FROM HumanResources.EmployeePayHistory AS a
WHERE RateChangeDate <>
(SELECT...
June 5, 2008 at 2:15 pm
Since it seems to have recently started, how about looking at index fragmentation?
June 5, 2008 at 1:55 pm
I felt like the question was a good question and was worded mostly well. Based on the feedback already posted, the only word I would have changed or removed was...
June 5, 2008 at 8:06 am
Do you have to have the data live and real-time or can you work from a daily snapshot? I had a similar situation with a previous employer. Fortunately, my environment...
June 5, 2008 at 7:06 am
At the time I had to do this, Microsoft didn't offer any tools outside of some specialized server that they wanted $10K for and we didn't have the money to...
June 4, 2008 at 7:38 am
Forgot to mention, your version of SQL Server is just fine for this. It does not require Enterprise edition to work.
June 4, 2008 at 7:26 am
You'll probably need to contact your IBM account rep to get the iSeries software if you do not already have it. As far as I understood, it was part of...
June 4, 2008 at 7:25 am
Part of your decision will come from where your DB2 database is hosted (AS/400 or Linux). Each has its own method of connection. I have worked in both environments and...
June 3, 2008 at 2:55 pm
Is this a project you built from scratch or have you copied parts of this project from other projects?
June 3, 2008 at 2:48 pm
I don't know about Oracle but in SQL Server, any INSERT/UPDATE/DELETE statements are automatically committed upon completion unless you have any logic that would direct it otherwise.
June 3, 2008 at 2:46 pm
Viewing 15 posts - 211 through 225 (of 341 total)