good video but my source is pipe delimited.CSV file, how should I capture one entire column values into a variable and loop them inside DFT. Execute SQL task does not have .csv connection type, please help me with this
You can process one row at a time using a Cursor in SQL (without using SSIS at all). But just remember - processing one row at a time can be a very slow operation for anything more than a few hundred rows. If you have many rows to process its best to rethink what you are doing and do it at a data set level (i.e. using SQL in the way it was intended to be used).
Very nice video; this is exactly what I was looking for to complete one of our projects at work.
That is a very clear explanation! I can expand this example to the solution I need. Thank you very much!
Well taught. Thank you
good video but my source is pipe delimited.CSV file, how should I capture one entire column values into a variable and loop them inside DFT. Execute SQL task does not have .csv connection type, please help me with this
Very good demonstration!
Quick question if you have chance; are there any other ways to achieve this?
You can process one row at a time using a Cursor in SQL (without using SSIS at all).
But just remember - processing one row at a time can be a very slow operation for anything more than a few hundred rows. If you have many rows to process its best to rethink what you are doing and do it at a data set level (i.e. using SQL in the way it was intended to be used).
Thumb + Subscribed good work