A very helpful tutorial indeed! Just a suggestion would be that instead of adding a random value to the string variable to bypass validation errors you could have enabled Delay Validation property. Like + Comment!
This is not as wide ranging as Katie and Emil but it is one of 2 places to start because of its precise and masterly crafting of many elements in each lesson.
Great Tutorial. But converting variables in the C# Script is unnecessary. They can be accessed directly inside the MessageBox: MessageBox.Show("Files Count is: " + Dts.Variables["FileCount"].Value + "Rows Count is: " + Dts.Variables["RowCount"].Value);
Nice and clean as usual! I'm always afraid to use those loops because i don't know how to properly set things they are looping on. Now, i can use them on files ;)
Item in the collection is 'file', while the variable 'filename' is a string. How come in the variable mapping every each 'file' is assigned to a 'filename'?
in VS2019 there is no Parameter Mapping tab, but there is Parameterize which does not have variable name for picking user variable. How do I go about that?
I'll have to ask another question , Andy: At which stage we set that it is the file's name which is going into the variable? Is it does to the fact we set 0 in the parameter? Thanks.
+RIDDLE0MASTER I think what you are asking is found during the configuration of Foreach Loop Container. The values inside Collection menu gives you what to retrieve and the Variable Mappings let you choose which variable to assign the retrieved value.
If the "copy txt files only" being executed when the expression matches , why the counter, which goes after it, works every time? Does the expression constrain simply skips one action?
It's an excellent tutorial for the SSIS. The content is still useful for me even though the videos were published nearly 10 years ago.
Happy to hear that, thank you for watching and for the comment!
A very helpful tutorial indeed! Just a suggestion would be that instead of adding a random value to the string variable to bypass validation errors you could have enabled Delay Validation property.
Like + Comment!
Awesome Collection and right place to start SSIS learning!!
This is not as wide ranging as Katie and Emil but it is one of 2 places to start because of its precise and masterly crafting of many elements in each lesson.
Great Tutorial. But converting variables in the C# Script is unnecessary.
They can be accessed directly inside the MessageBox:
MessageBox.Show("Files Count is: " + Dts.Variables["FileCount"].Value + "Rows Count is: " + Dts.Variables["RowCount"].Value);
Thanks for the tip. The other method wasn't working. It didn't like declaring and converting the int variables.
Nice and clean as usual! I'm always afraid to use those loops because i don't know how to properly set things they are looping on. Now, i can use them on files ;)
It would be better if you can share these data files with us so that we can start practice.
Great tutorial, great series, really appreciate the effort you put in *****!
Item in the collection is 'file', while the variable 'filename' is a string. How come in the variable mapping every each 'file' is assigned to a 'filename'?
all are good,thanks you
but i wish i have access to these files and tables to do practice on it
Sadly I don't think that Andy saved a copy of the scripts and files he used in this video. Sorry about that!
Very nice tutorial!
in VS2019 there is no Parameter Mapping tab, but there is Parameterize which does not have variable name for picking user variable. How do I go about that?
I'll have to ask another question , Andy:
At which stage we set that it is the file's name which is going into the variable?
Is it does to the fact we set 0 in the parameter?
Thanks.
+RIDDLE0MASTER I think what you are asking is found during the configuration of Foreach Loop Container. The values inside Collection menu gives you what to retrieve and the Variable Mappings let you choose which variable to assign the retrieved value.
If the "copy txt files only" being executed when the expression matches , why the counter, which goes after it, works every time? Does the expression constrain simply skips one action?
***** Oh , silly me. I confused the two counters. . . .
Including the files would be very helpful for following along.
Just make your own files. I have a bunch of pdf files on my computer, so I used those instead.
@@TheDouceHouse Why are you telling us what to do?
Thank you very match and God bless you
Excellent exercise I like it
OverwriteDestination flag doesn't work. I tried to set it to False but it keeps on overwriting the txt file. weird. anyways.. great tutorial!
Interesting, thanks for sharing your experience!
Very helpful
Perfect :)
wow
SSIS - sucks, and the author makes the tutorial even more complicated