Viewing 15 posts - 2,086 through 2,100 (of 13,838 total)
In your Foreach container, you will configure a variable to be assigned the name (optionally the entire path) of the file being processed on the 'current' loop iteration. That is...
April 15, 2021 at 9:24 pm
This should give you an idea.
In the Variables pane, I created a variable called FileName and assigned its value.
Then I created the variable FileNameDate and assigned its value as an...
April 15, 2021 at 6:35 pm
Found the Derived Column Transformation but do I type in my SQL to get the Date from the file name into the "Expression"?
No, you need to use SSIS's...
April 15, 2021 at 4:47 pm
It's simply not there
Do you have all the other Data Flow tools? Conditional Split, Merge, Multicast etc?
April 15, 2021 at 4:16 pm
Sorry Thom, you are right. My brain transformed this
you can use a Derived Column Transformation, and just have the expression for said column be the variable the path is in
into...
April 15, 2021 at 4:15 pm
I can't find the Derived Column Transformation in my Toolbox
It is available only in the Data Flow.
April 15, 2021 at 4:08 pm
That means that the derived column needs to be recalculated for every row in the file ... potentially not very efficient, given the unchanging file name....
April 15, 2021 at 4:08 pm
Just a guess as to my strategy - I'm using variables to hold the values of each field as the process iterates through each row of...
April 15, 2021 at 4:01 pm
You'll need to do script foo on that to get the date out of it.
A script is probably not necessary. A calculated variable, using the variable holding...
April 15, 2021 at 3:46 pm
Don't worry.
I realised the problem was that I didn't have a schema called called Config in the first place - doh!
I'm going to assume that wine or beer...
April 15, 2021 at 12:25 pm
It should update.
SSRS does cache data between report executions, but (as far as I know) this caching is only at the session level.
Activation Date is a runtime parameter, is that...
April 15, 2021 at 8:52 am
Sorry, I'm being an idiot.
I'm getting the following error
Msg 15151, Level 16, State 1, Line 1 Cannot alter the schema 'Config', because it does not exist or you do...
April 14, 2021 at 5:11 pm
Your code is merely returning results. If you want to run the code, you need to paste those results into SSMS and hit F5 ... very carefully and having backed...
April 14, 2021 at 4:59 pm
This is a good start, but there's more that I suggest you do.
April 12, 2021 at 10:19 am
How about providing some data in the form of CREATE TABLE / INSERT statements, so that people here have something to work with?
April 11, 2021 at 8:57 am
Viewing 15 posts - 2,086 through 2,100 (of 13,838 total)