Viewing 15 posts - 1,681 through 1,695 (of 3,738 total)
HowardW (3/22/2012)
Having said that, it's not rocket science to restart services, just use the Net Stop and Net Start commands:http://technet.microsoft.com/en-us/library/cc736564%28v=ws.10%29.aspx#BKMK_cmd
I need to do this Programmatically as a job step and...
March 22, 2012 at 7:32 am
HowardW (3/22/2012)
March 22, 2012 at 7:29 am
sam.dahl (3/20/2012)
SSMS shouldn't be any different.
P.S. In my experience, whilst template packages work well...
March 21, 2012 at 5:32 am
Ok, Thanks.:-)
March 20, 2012 at 5:29 pm
How can I ignore truncation?
[CTL_Accounts_Payable [1]] Error: The "output column "ADD0LINE03" (199)" failed because truncation occurred, and the truncation row disposition on "output column "ADD0LINE03" (199)" specifies failure on truncation....
March 20, 2012 at 2:58 pm
Jack Corbett (3/19/2012)
Welsh Corgi (3/19/2012)
Jack,I'm getting the same error when importing the data from DB2 AS400.
Do you have link to a simple exampl on redirecting output on error?
Thanks.
Here's...
March 20, 2012 at 12:09 pm
I switched from Fast Load to Table or View and executed the task and it succeeded but when I ran the package it failed..
March 20, 2012 at 9:41 am
feersum_endjinn (11/15/2011)
[Data Flow Task]
DefaultBufferMaxRows
DefaultBufferSize
[SQLServerDestination]
MaxInsertCommitSize
You need to play around with those three parameters and get the correct values for your hardware/software/database...
March 20, 2012 at 9:36 am
Yes, I restarted it, thanks.
March 20, 2012 at 7:49 am
stevefromOZ (3/19/2012)
Little known usage of SSMS, but it'll open XML quite happily. Eithe ruse File|Open or simply have SSMS open, go to Windows Explorer and click|drag the file into SSMS.
The...
March 20, 2012 at 6:51 am
GRussell31 (3/20/2012)
What data is in the file, is it in a foreign language?What collation is the database?
Graham
It is English.
There are comments, payment, financial information, etc
The tables load using OPEN QUERY.
The...
March 20, 2012 at 5:21 am
This error is getting worse, more frequent. Help!
March 19, 2012 at 6:30 pm
THis error is intermittent.
It is getting worse.
Has anyone experienced this issue?
March 19, 2012 at 5:20 pm
sam.dahl (3/19/2012)
From what I can tell, being a vague sort of error you can get it for various reasons.
From memory, points of interest are:
- Is...
March 19, 2012 at 5:08 pm
I get this error but it does not specify what occured.
Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (3) reached the maximum...
March 19, 2012 at 2:57 pm
Viewing 15 posts - 1,681 through 1,695 (of 3,738 total)