Viewing 15 posts - 8,491 through 8,505 (of 8,753 total)
Koen Verbeeck (4/25/2014)
It's still all or nothing (and I'm OK with that). I see no reason why one would want to switch off logging during an execution.
I agree, cannot see...
April 25, 2014 at 1:13 am
For SSIS 2008, the simplest way I have found to manipulate the logging is to use a Scrip Task in a "Master" package.
As the logging is initialized before any...
April 25, 2014 at 12:44 am
exec sp_help 'procedure name'
and check the output
😎
April 24, 2014 at 11:18 pm
Some more information is needed as the file attached is not in any (obvious) standard format.
Which software produces the file? Are there any ODBC drivers available?....
😎
April 24, 2014 at 10:50 pm
allamsanjeev (4/24/2014)
Haven't done any such step? If you can be more elobrative would be of much needed help.Thanks
Open up command prompt (cmd.exe)
type: net start
and hit enter
the output should be:
These Windows...
April 24, 2014 at 10:14 pm
Will you share the work when it is finished?
😎
April 24, 2014 at 5:06 pm
Could you post the xsd and some sample xml, hard to tell what is happening without more info.
😎
April 24, 2014 at 4:50 pm
The code you posted has so many syntax errors that I am amazed it managed to run into the error you posted, did a little cleanup and it runs without...
April 24, 2014 at 4:01 pm
Sean Lange (4/24/2014)
Eirikur Eiriksson (4/24/2014)
How about using the TABLOCK hint?😎
That seems to be dealing with the symptom rather than the cause. 😉
Hints should be used as a last resort. The...
April 24, 2014 at 3:43 pm
Nikku (4/24/2014)
I have created SSIS package which keeps the track of SysSsisLog table into another table. However I want an option to keep loggin ON or OFF through task/package...
April 24, 2014 at 3:13 pm
Run Nat start in cmd and check if the instance you are connecting to is there.
😎
April 24, 2014 at 9:31 am
Luis Cazares (4/24/2014)
You should use a PK (or unique) constraint as well to...
April 24, 2014 at 9:04 am
AllenMWhite (4/24/2014)
Wouldn't you have the same problem in Transact-SQL, though?
Yes of course, that is why I am interested in seeing how PS would handle this. Often had to implement...
April 24, 2014 at 7:12 am
It would be interesting to see the performance of PS when working with sets larger than the 2Gb limits of the XML data type. 😎
April 24, 2014 at 6:57 am
Viewing 15 posts - 8,491 through 8,505 (of 8,753 total)