Viewing 15 posts - 316 through 330 (of 5,111 total)
I've gone back to the "Component Properties" in my "Advanced Editor for Flat File Source" to make this change and I seem to have forgotten how to put...
April 20, 2021 at 2:15 pm
Did you mean RIGHT(User::FileNameVariable,10) there? Notwithstanding that, your comment stands.
I did, however, considering the time of the morning I can use the excuse the coffee hadn't kicked in....
April 20, 2021 at 9:39 am
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 can wrap...
April 20, 2021 at 8:20 am
When I use the data flow task and the Source Assistant / Flat File Connection Manager Editor it will not allow me to choose multiple flat files with...
April 19, 2021 at 4:00 pm
I want to insert the date part of the file name into a date field in my SQL table called "PyRlByPeriod" within connection "10.1.201.29.a2hr" which is my database....
April 19, 2021 at 3:16 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:14 pm
How do you get part or all the file name into the variable?
You do that in your ForEach Loop Container. When you create this, you have to define...
April 19, 2021 at 8:15 am
Sorry Thom, you are right.
Can't blame a lack of coffee this time, need to think of another excuse.
No worries, we all do it. 🙂 At least it's Friday...
April 15, 2021 at 4:21 pm
It's simply not there
This sounds like you're looking in the wrong place. This is an image from VS 2017, but you can see it on the left hand...
April 15, 2021 at 4:17 pm
That means that the derived column needs to be recalculated for every row in the file ... potentially not very efficient, given the unchanging...
April 15, 2021 at 4:10 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. I prefer...
April 15, 2021 at 4:03 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 the .csv...
April 15, 2021 at 3:50 pm
Why do you need an Execute T-SQL Task here? A (simple) Data Flow Task with just a Flat File Source and OLEDB/SQL Server Destination should be more than enough here....
April 15, 2021 at 3:33 pm
Are you running this report within Visual Studio, or within the SSRS Web Portal? If within Visual Studio, you might want to delete the report's cached data file and then...
April 15, 2021 at 10:59 am
Side note, syntax like '[' + {Object Name} + ']' isn't safe from injection. If you had an object with the ] character in it's name (yes, there are people...
April 15, 2021 at 10:48 am
Viewing 15 posts - 316 through 330 (of 5,111 total)