Viewing 15 posts - 2,881 through 2,895 (of 7,164 total)
This is just a pared-down example of a method used by one of the largest open-source development platforms in existence.
And that platform would be...care to share?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 22, 2012 at 8:31 pm
Which OS and SSIS version are you using? Did you try the demo as-is to ensure your systems can handle the technique before you made modifications for your environment?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 22, 2012 at 3:49 pm
http://www.scalesql.com/cleartrace/%5B/url%5D
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 21, 2012 at 8:27 pm
matak (10/21/2012)
Thanks for the advice about sparse tables and columns - ive never used them before so i will do some reading.
You're welcome.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 21, 2012 at 8:23 pm
What I think you are after is some guidance creating a data model that supports the industry-data you're trying to support, mining. I tried searching the internet for "standard mining...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 21, 2012 at 7:52 pm
On second thought...response removed
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 21, 2012 at 6:52 pm
You need the 32-bit driver installed when:
- you use BIDS for development and debugging
- you want to run a package by calling the 32-bit version of dtexec.exe directly
You need the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 21, 2012 at 5:56 pm
Using a Web Service Task that writes the results of the call to a file may enable you to get started using SSIS 2012 instead of staying in SSIS 2008....
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 21, 2012 at 5:31 pm
v.sandeep06 (10/9/2012)
I had two servers
server 1 -------SSIS Package is present
server 2----- EXe location
I had SSIS Package in server 1 ,...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 21, 2012 at 4:14 pm
There are some things included in SSIS that it would be foolish to re-implement in T-SQL. However, if you consider the Windows Batch commands that can be issued via xp_cmdshell...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 21, 2012 at 2:14 pm
It is a little unclear what you want because your post is a bit fragmented in terms of its sentence structures, but you may be able to achieve what you...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 21, 2012 at 1:56 pm
The specified DSN contains an architecture mismatch between the Driver and Application.
BIDS/VisualStudio is a 32-bit app. You'll also want to install the 32-bit OPENEDGE driver and create a DSN using...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 21, 2012 at 1:49 pm
LogParser.exe works for me.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 21, 2012 at 12:32 pm
I agree with Andy. What you have now is what I call the 'spreadsheet approach' to data modeling where everything is in one wide table. You said one column can...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 21, 2012 at 11:21 am
You should see an entry in the SQL Server Error Log when an integrated connection fails (as long as you're still logging failed login attempts). The error number, severity and...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 21, 2012 at 10:58 am
Viewing 15 posts - 2,881 through 2,895 (of 7,164 total)