Viewing 15 posts - 76 through 90 (of 156 total)
If you are lucky you will never have to craft an Oracle Update statement that updates based on another table. Hideous.
There is no way they will ever change ''...
September 20, 2012 at 9:24 pm
In Oracle, client tools are painful. You need to buy TOAD for a GUI, and has some good features (CTRL-Clkick to get table info) but it's basically a dogs breakfast.
Back...
September 20, 2012 at 1:25 am
so we can do reporting from our numerous sources
Consider whether you just want a more convenient place to perform system specific operational reporting, or whether you want to match and...
September 18, 2012 at 3:15 am
I do not have anything constructive to add . I would just like to say I am at the edge of my set waiting for the solution.
September 14, 2012 at 4:09 am
Is it because of this:
No explanation is given for why certain rows get sent to certain outputs in order to debug data. Items shown as “new” or “changed” may be...
September 12, 2012 at 3:11 am
In this case, in my data, I have
Full Name Total Activities
A 1
A 1
B 4
The ideal output would be:
Full Name Total Activities
A 2
B 4
of course you can, you just...
August 24, 2012 at 11:46 pm
File based packages certainly don't preserve versions. From some brief research it doesn't appear that there is any native versioning in the database either.
August 24, 2012 at 11:41 pm
Here is a link on column level permissions
This assumes that your users log dierctly into SQL Server to run their queries. If you have some kind presentation layer...
August 7, 2012 at 5:15 am
If these are two databases on the same instance you can just run this to transfer data accross.
INSERT INTO DatabaseTarget..TableTarget (COL1, COL2)
SELECT COL1, COL2 FROM DatabaseSource..TableSource
That is the concept. There...
August 7, 2012 at 5:09 am
I suggest you run a trace and verify the user name being used, and also verify that you are logging into the database you expect.
Then you can be 100% certain...
July 19, 2012 at 3:07 am
Its not a very helpful message but it tells you that the error occured in
DTSStep_DTSExecuteSQLTask_1
So start your search there.
Also can you confirm that this is actually SSIS
July 10, 2012 at 3:37 am
I have seen some Openrowset , Opendatasource commands in net for reading data from a file directly from a query. Similar way i was trying to find whether we have...
May 8, 2012 at 7:29 pm
.. and of course you run your SSIS package with DTEXEC.EXE.
So thats a total of three command line solutions (SQLCMD, BCP, DTEXEC), all of which can be run from SQL...
May 8, 2012 at 5:31 am
"Doing a bcp will not be possible as i will not get permission for xp_cmdshell"
What about simply creating a SQL Server Job with a step of type CmdExec to run...
May 8, 2012 at 4:53 am
Viewing 15 posts - 76 through 90 (of 156 total)