Viewing 15 posts - 11,131 through 11,145 (of 13,877 total)
steveb is correct. Ignore Kramaswamy's post.
September 22, 2011 at 10:01 am
palash.gorai (9/22/2011)
Hi,Try the following syntax:-
select convert(varchar(12),getdate(),101)Result:-
9/19/2007
regards
Palash Gorai
How is this relevant?
September 22, 2011 at 1:52 am
I see - that's probably down to good luck in terms of timing. Much better to order things properly and then you shouldn't have these issues at all.
September 21, 2011 at 10:04 am
Koen Verbeeck (9/14/2011)
Phil Parkin (9/14/2011)
September 21, 2011 at 7:58 am
Sudhir's idea seems the least cumbersome to me ...
Or (and I am not sure whether this is even possible, because I have not tried importing from Access for ages...) use...
September 21, 2011 at 7:51 am
... But sometimes it fails.
Does this comment apply to the situation after you have changed the package to force things to load in the 'proper' order?
September 21, 2011 at 7:34 am
mark hutchinson (9/15/2011)
There are 86400 seconds in a day, not 84400 that you stated in the article. You should probably change some numbers.
Well spotted!
September 15, 2011 at 9:11 am
You may need to 'nest' your iif's:
Level 1: iif(condition, true, false)
Level 2: iif(condition, true, iif(condition2, true2, false2))
etc etc
September 15, 2011 at 7:49 am
iposner (9/15/2011)
hxchi (9/15/2011)
To synchronize the two server clocks to 1 millisecond precision is not a trivial task.Especially because Windows internal system clock has a default resolution of 3 milliseconds!
I don't...
September 15, 2011 at 7:46 am
In the properties of your FEL, there is something like filename/filespec, which you can use to refine the files to be selected by the FEL.
? is a single-character wildcard, representing...
September 15, 2011 at 7:12 am
angelz_arch (9/14/2011)
In my SSIS, i am required to check a DB column 'Batch_ID' for the current date. If it is the current date,...
September 15, 2011 at 3:25 am
Pascal Declercq (9/15/2011)
September 15, 2011 at 3:13 am
I also read an article not too long ago, which I cannot now find (grr!), which suggested that SSIS was the wrong tool to use in the case of "drip-feed"...
September 14, 2011 at 7:13 am
Another possibility is that you could store the variable in a database somewhere. When the package runs, it picks this value up and executes accordingly. It depends on your exact...
September 14, 2011 at 5:47 am
Viewing 15 posts - 11,131 through 11,145 (of 13,877 total)