Viewing 15 posts - 1,651 through 1,665 (of 2,612 total)
SSIS does not capture percentage information on it's own. It can log how many records have been transferred, but it does not check for totals first, so there is...
May 8, 2008 at 6:17 am
You can get away with that for some components, but if you need to use a lookup you will need to deal with the OLEDB provider.
If that ends up being...
May 7, 2008 at 12:10 pm
The machine that runs the package (in your case your application server) MUST be an SSIS Server if you have anything beyond the components used by the import/export wizard or...
May 7, 2008 at 9:38 am
I like Oracle, but the problem is the Oracle client. Even the 10g client I am currently using is a bit of a piece of garbage - it has...
May 7, 2008 at 9:31 am
Add all three images to the row (in the same cell) and dynamically set their visibility.
May 7, 2008 at 9:19 am
I would place both of these scenarios under multi-plexing and say that you need to get licenses as if client machines were connecting directly.
These are specific enough that you may...
May 7, 2008 at 9:17 am
So running the same line of code, sometimes it times out in less than a minute and sometimes it runs for longer than a minute?
May 6, 2008 at 8:34 am
A timeout issue will not be random. If everything times out after an exact amount of time (or completes an a shorter amount of time), you have a timeout...
May 6, 2008 at 8:24 am
You seem to be new to programming with SSIS, so I would suggest you first go look at the books online information regarding using the SSIS object model to run...
May 6, 2008 at 6:58 am
Sometimes connection pooling is good and sometimes it is not.
Absolutely make sure your developer is closing connections - pooling or not. If the connections are not closed, they never...
May 5, 2008 at 12:13 pm
When a SQL database is not shut down nicely, the transactions in process need to roll back when the server comes back up. It is most likely trying to...
May 5, 2008 at 12:07 pm
Look up SCOPE_IDENTITY() in books online.
May 5, 2008 at 12:06 pm
As a database guy, I like to have as much data integrity managed by the database engine. This means constraints, focused data types, triggers, stored procedures, etc. in the...
May 5, 2008 at 11:58 am
No, SQL does not kill inactive connections. You could do this manually, but it is really a sign of an application problem that you should fix.
Your application or web...
May 5, 2008 at 11:51 am
It will depend on your interpretation of SOX.
May 5, 2008 at 11:25 am
Viewing 15 posts - 1,651 through 1,665 (of 2,612 total)