Viewing 15 posts - 11,641 through 11,655 (of 13,870 total)
Koen (da-zero) (1/28/2011)
Phil Parkin (1/28/2011)
The power of Google is there for you as well as me, but since you're new I've done it for you, just this once. Check here.
The...
January 28, 2011 at 7:31 am
The power of Google is there for you as well as me, but since you're new I've done it for you, just this once. Check here.
January 28, 2011 at 7:14 am
Try removing the double quotes from your expression:
@[User::LopVariable]==@[User::IterlopVariable]
January 28, 2011 at 12:42 am
Are you running the package as yourself, or another user? It is good practice to use a UNC path to your file, rather than drive letters, as these are not...
January 27, 2011 at 9:15 am
I'm with Koen. There was no need for an SP - running the count query and assigning the result to an SSIS variable can all be done in a single...
January 26, 2011 at 8:54 am
Please post the text of the error message from the job history.
January 26, 2011 at 6:36 am
Or it might be possible via a conditional split (just redirect all the unwanted rows to an unused output and keep the good stuff) - don't use SQL Server at...
January 26, 2011 at 4:34 am
Derrick Smith (1/25/2011)
That would also fix...
January 25, 2011 at 12:23 pm
I'm guessing that there can be a lot of files in this share that you do not wish to process?
An alternative solution may be to nominate a folder on the...
January 25, 2011 at 10:46 am
It's an ungainly expression, but as you've nearly got it completed, I guess there's no good reason to try something else.
Have you tried using
DATEPART("hh",GETDATE())
?
January 25, 2011 at 10:37 am
What happens once you've verified that the file exists (or not)?
January 25, 2011 at 12:24 am
I think the first sentence of the original post
in my local drive, i have a directory, d:\data\ with unlimited subdirectories liked the following:
points to your alternative as being the way...
January 24, 2011 at 9:52 am
Viewing 15 posts - 11,641 through 11,655 (of 13,870 total)