In this method you can't use a where clause. All records from the table will be exported. if you want to export only specific records, then first create a view using the table and use where condition in that to filter out unwanted records and keep only the required records in the view. Now using this method you can export the data from the view.
If i need specific records from a table, what could be done?
In this method you can't use a where clause. All records from the table will be exported. if you want to export only specific records, then first create a view using the table and use where condition in that to filter out unwanted records and keep only the required records in the view. Now using this method you can export the data from the view.
Hi Aqil ahmed, is that very difficult to learn stored procedure??
Feeling very difficult to learn stored procedure than ssis
@@jagadishm8264 ha ha, yeah sql is a bit difficult as compare to ssis.
@@learnssis I have seen all ur SQL 92 vedios so far. Ssis 47 vedios
I have one new task.
As I need to convert excel small table to pdf using ssis.
Can you please reply on how can we achieve
Hi, there is no inbuilt component in SSIS to perform this task. Maybe you need to see if there is something in C# for this.
@learnssis this is something unique. Can you try to make a video on it. Using C++
@@TKJ Sorry I don't know C++ and at the moment I am a bit occupied on some projects, so won't be able to make a video on it soon.
@@learnssis okk