Viewing 15 posts - 11,131 through 11,145 (of 13,872 total)
... 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
One way of doing this is to add new columns to your underlying selection query, corresponding to your conditions.
The value of the column will be zero unless the condition is...
September 14, 2011 at 4:26 am
Not so strange, really.
Your original code was doing SET NOCOUNT ON if the condition was true and then reverting to normal execution.
Unless your if-statement code is of the form
if [condition]
begin
multiple...
September 13, 2011 at 5:34 am
starspejd (9/13/2011)
I think I got it now. Granted, what I've made is only a small test on my own laptop, I still need to make the package on the...
September 13, 2011 at 5:11 am
No problem. Let us know how you get on and post back with any additional questions.
September 13, 2011 at 3:31 am
Those files with no extensions are a pain.
I'd be tempted to do this processing with a Windows batch file - here is one way:
1) Rename files with no extension (this...
September 13, 2011 at 3:00 am
Viewing 15 posts - 11,131 through 11,145 (of 13,872 total)