Forum Replies Created
Viewing 15 posts - 8,266 through 8,280 (of 13,882 total)
-
RE: SSIS package getting failed
Can you get a more comprehensive set of errors from the 'All Executions' report in SSISDB?
-
RE: Are the posted questions getting worse?
.... up to and including the "F" word
Foxbase?
-
RE: Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.
allarmi (7/16/2015)
Hello,is there any way to have sqlserver to terminate the current batch when that situation is detected ?
Thank you
Terminate = roll back? Or what, exactly?
may be...
-
RE: Delete records older than 90 days in SQL Server
And if that means deleting millions of rows in any of the tables, you should consider implementing a batch delete process to avoid excessive locking and TLog growth.
-
RE: Blank CSV File import
Some ideas:
1) Add a script task to conditionally delete the file before trying to import it.
2) Call a batch file to delete all files of 0 bytes before trying to...
-
RE: Are the posted questions getting worse?
Brandie Tarvin (7/16/2015)
BrainDonor (7/16/2015)
Brandie Tarvin (7/16/2015)
BrainDonor (7/16/2015)
Lynn Pettis (7/15/2015)
And to widen this subject slightly - does anybody have suggestions as to how my wife could occupy herself in Seattle during... -
RE: Resolution for SSIS Package Catastrophic Failure
Interesting, thanks for posting this: I'm sure that it will help others.
-
RE: Search Issues?
Steve Jones - SSC Editor (7/14/2015)
Seems to be working now, but sometimes the Search does unload all the results and flakes for some reason.Send a note to the webmaster@ if...
-
RE: Localization of a sql table to Japanese language
If that's the case do we need to manually translate the text in the country table for each and every country?
Only if you need it.
Are you thinking that SQL Server...
-
RE: SMTP Standard Task does not dispose/quit connection after email has been send
Phil Parkin (7/14/2015)
Sounds good. I did it in a proc to avoid having to cut and paste C# code all over the place. I suppose you could have a child... -
RE: Any Way to Automate Creation of Flat File Connection Managers in Integration Services
mberman (7/14/2015)
We are importing data from CSV files into SQL tables, where every column matches.To do this we are using flat file connection managers. This requires manually inputting each field...
-
RE: SMTP Standard Task does not dispose/quit connection after email has been send
Sounds good. I did it in a proc to avoid having to cut and paste C# code all over the place. I suppose you could have a child package which...
-
RE: SMTP Standard Task does not dispose/quit connection after email has been send
Martin Schoombee (7/14/2015)
I also typically use a script task to send email. Have found the built in SMTP task to be buggy and unreliable.Is this sync or async?
-
RE: SMTP Standard Task does not dispose/quit connection after email has been send
How do you send SMTP-Messages in an SSIS Package?
I call a 'helper' proc, which uses DBMail, via an ExecuteSQL task.
-
RE: Search Issues?
Could this issue have recurred? I clicked on the 'Search Forum' link, typed SQL and submitted. The response:
Viewing 15 posts - 8,266 through 8,280 (of 13,882 total)