Viewing 15 posts - 1,561 through 1,575 (of 7,164 total)
Sometimes the SQL statement is not captured, or it may be a UI bug. Can you save the file and attach the file to this thread? It's possible the data...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 18, 2013 at 4:07 pm
Lynn Pettis (3/18/2013)
opc.three (3/18/2013)
ChrisM@Work (3/18/2013)
opc.three (3/15/2013)
PS Forgot to mention the function is undocumented so take that into consideration.It's a cough scalar function too.
Meh. We're talking about SQL Agent data so...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 18, 2013 at 3:58 pm
sqldba_newbie (3/18/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 18, 2013 at 3:42 pm
brettstahlman (3/18/2013)
opc.three (3/16/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 18, 2013 at 2:56 pm
Sqlism (3/18/2013)
Thanks for the reply!Can you please explain this in more details, i use Execution utility for running this packages. so how can i differentiate 2012 and 2008R2 SSIS.
The path....
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 18, 2013 at 2:47 pm
Not that I am aware of, in general. Maybe something in your particular environment? Define "access"? Windows? Database?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 18, 2013 at 2:43 pm
Adding the -u switch will give you a Windows Unicode (i.e. UCS-2) file. To get to UTF-8 you'll have to enlist the help of some other tool. Why do you...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 18, 2013 at 2:41 pm
ChrisM@Work (3/18/2013)
opc.three (3/15/2013)
PS Forgot to mention the function is undocumented so take that into consideration.It's a cough scalar function too.
Meh. We're talking about SQL Agent data so IMHO it's not...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 18, 2013 at 2:38 pm
Calling bcp might be a better option for you than using a Data Flow since bcp does not need to be armed with the table structure if using the bcp...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 18, 2013 at 1:02 pm
32 or 64 bit SQL Server?
Server 2003 will do this to SQL 2005 quite a bit on some systems, and on others it's not an issue. It depends on what...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 18, 2013 at 12:54 pm
Given the comment about space, I think you mean to restore the database so the data and log files are stored on a remote file share. If I guessed right...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 18, 2013 at 10:09 am
You're welcome. Thanks for the feedback.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 18, 2013 at 9:37 am
Those components of @@VERSION speak to the OS, not SQL Server. Here is what I use to check what you're trying to check which ensures I only see the SQL...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 18, 2013 at 6:56 am
Eugene Elutin (3/18/2013)
If you enable READ COMMITTED SNAPSHOT in the database, it becomes the default isolation level.
For clarity READ_COMMITTED_SNAPSHOT is just a mode of the READ_COMMITTED isolation level with versioning,...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 18, 2013 at 5:47 am
Sqlism (3/14/2013)
I had 2012 integration services installed on a server. i am trying to connect to Oracle but it is failing. I worked with Same SSIS Pkg in 2008...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 17, 2013 at 5:01 pm
Viewing 15 posts - 1,561 through 1,575 (of 7,164 total)