Viewing 15 posts - 2,116 through 2,130 (of 13,871 total)
Considering you said earlier:
The file names are always in this format: "ConvoEVQ2021-04-05"
Assuming that there is no extension, what's wrong left LEFT(User::FileNameVariable,10)? For the above that'll be 2021-04-05. You...
April 20, 2021 at 9:36 am
Please take a read through here for a detailed walkthrough.
April 19, 2021 at 4:17 pm
Thanks... within my Loop container I placed an "Execute SQL Task Editor" but I'm having trouble with its needed syntax in the SQL Statement and the Parameter Mapping......
April 19, 2021 at 3:04 pm
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
Viewing 15 posts - 2,116 through 2,130 (of 13,871 total)