Viewing 15 posts - 9,226 through 9,240 (of 13,882 total)
ronan.healy (6/27/2014)
((TRIM(INV_SECTYPE_COD) == "70")) && ((TRIM(INV_SECTYPE_COD) == "71")) && ((TRIM(INV_SECTYPE_COD) == "72")) && ((TRIM(INV_SECTYPE_COD) == "73")) && ((TRIM(INV_SECTYPE_COD) == "74")) && ((TRIM(INV_SECTYPE_COD)...
June 27, 2014 at 3:23 am
antonio.estima 4150 (6/26/2014)
June 26, 2014 at 6:59 am
Koen Verbeeck (6/26/2014)
Please do not crosspost. It wastes peoples time and fragments replies (like Phil Parkin).Original thread with replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1586306-2799-1.aspx
Grrr!:angry:
June 26, 2014 at 3:45 am
If you're using a SQL Agent job, you should have nothing to worry about. If the job is still running after two minutes, it will not be invoked again until...
June 26, 2014 at 3:20 am
antonio.estima 4150 (6/25/2014)
June 26, 2014 at 3:10 am
You can capture the current iteration's file path in a user variable.
Have a look at the Variable Mappings section here[/url] and let us know if you need more info.
June 26, 2014 at 1:51 am
antonio.estima 4150 (6/25/2014)
I have an activity that was created using SSIS 2008 R2, which consists of copying a file from a server within the network to a server...
June 25, 2014 at 8:20 am
imani_technology (6/24/2014)
I decided that using a simple backup/restore might not be the best idea for staging. Why? Because:
1) We are backing up from one server on one...
June 24, 2014 at 12:28 pm
You have some bizarre looking char dates there.
Are you looking to do INSERTS, or INSERTS and UPDATES or INSERTs, UPDATEs and DELETEs for your incremental load?
Do you have such columns...
June 19, 2014 at 10:17 am
Stuart Davies (6/18/2014)
June 18, 2014 at 5:25 am
If you script the stored proc as CREATE from SSMS, you will see something like this at the start:
set ansi_nulls on
go
set quoted_identifier on
go
If you make sure that your set options...
June 18, 2014 at 12:14 am
Beatrix Kiddo (6/17/2014)
June 17, 2014 at 4:22 am
imani_technology (6/16/2014)
Thanks for the reply. I think we will need to do the backup/restore once or twice a day. What's the best way to automate this?
Via a SQL...
June 17, 2014 at 12:47 am
Viewing 15 posts - 9,226 through 9,240 (of 13,882 total)