29 How to execute stored procedure with input parameter as variable in SSIS

How to execute stored procedure with input parameter as variable in SSIS
Download the file\script used in the Video from below link
drive.google.c...
SSIS Tutorials: • SSIS Tutorials
SSIS real time scenarios examples: • SSIS real time scenari...
SSIS Interview questions and answers: • SSIS Interview questio...
How to execute stored procedure with input parameter as variable in SSIS
How do I call a stored procedure with parameters in SSIS?
Can we save stored procedure output parameter value to SSIS variable?
How pass variable as a parameter in Execute SQL Task in SSIS?
How do I assign a variable to a parameter in SSIS?
Happy Learning.
If you have any questions or suggestions please comment on the video or write to me at “[e-mail]”

[@AchuVlogs]

Thank you so much for addressing my question sir. I got the concept now!! Very helpful video 👏🏻😊

[@learnssis]

You are welcome Achu vlogs. Good to know that you liked the video.

[@brianjohnson5145]

Great video as usual. Keep them coming!

[@learnssis]

Thank you Brian.

[@ASIFALI-pn3uv]

Superb. Got a good knowledge of the object data type variable from this video.😊Thanks

[@learnssis]

Thank you Asif, good to know that it helped you.

[@prasunab4261]

Video was very helpful. Thank you! If my input parameter is date type and I’ve created an ssis variable of type datetime then what type cast could I use in Expression builder in place of (DT_WSTR,12)? Thanks in advance!

[@learnssis]

Thank you. 12 is the max length of the string that is being type casted. You can pass the value as 50 as max length thus your query will be like (DT_WSTR,50)

[@patlollanaveenreddy3170]

Hi Aqil, thanks for u r videos
if u have time please make video on SCD type 3 and type 2
thanks in advance

[@learnssis]

Hi, I have made a video on SCD Type 2 below
ruclips.net/video/7uj463csru0/видео.html
I will check on SCD Type 3 as well.

[@arunkumarn6371]

Thanks for the amazing video. I have a stored procedure that connects to multiple databases under one server. Can I use that stored procedure within SSIS? If so, how i can provide connection details? Since I have 3 dbs. Could you please clarify?

[@learnssis]

You have 2 options here
1. Either you can create 3 OLE DB connections , here one connection one point to one database on the same server, second connection will point to second database and third connection will point to third database.
2. Create only one OLE Db connection, now in the execute sql task, the first statement can be
use databaseName
and then you call the stored procedure on that connection.

[@brianjohnson5145]

Can you do a video on how to write data from a SharePoint List to SQL Server? Or Write to a CSV or Excel Document.

[@catulopsae]

Does it make sense when there is a lot of records to update, to use this for each container calling the stored procedure?

[@catulopsae]

I was looking for this recently. Thank you!

[@learnssis]

Yeah you can do that.

[@learnssis]

@@catulopsae Glad you find it here.

[@samuna8950]

Sir I want to create an incremental load by using sp. The result set has Id column which has duplicate records. The result set is a fact table

[@learnssis]

In this video I have shown how to do incremental load using sql query. You can take a look at it
ruclips.net/video/-rMDmD7GNtE/видео.html
And if you want to delete duplicate records then you can check this one
ruclips.net/video/8ohs43g9X5Y/видео.html

[@samuna8950]

sir only id is duplicate but rest of the records are changed@@learnssis

[@syedakhadijamazhar1314]

Could you plz make a video. Where the "@batchId" parameter in the SSIS package and process the query corresponding to the batchId. For example, the SSIS package will read the query "select col2 from xyz_table where col1= @batchid" then it should read the subquery (for example: "select * from tablename") which is the value of col2 and execute it.
Then the output of the subquery should be stored in a flat file.

[@learnssis]

You can create an SSIS variable of BatchId type Int32, assign the value to this variable using execute sql task, selecting return type as single row.
Now you can create an SSIS variable as SQLQuery of type string. In the expression of the SQLQuery variable write the code "select col2 from xyz_table where col1= @batchid "
Write whatever is the appropriate syntax for it, and write the sub query as well in the select query.
Now you can take a data flow task, use the OLE DB Source, under "Data access mode" select SQL Command from variable and select the SQLQuery variable, take the flat file destination to write the data to a flat file.

[@vitto_af]

Great vídeo

[@learnssis]

Thank you so much.

[@victorbhatti4326]

I need training .. can use pls help . I need paid training

[@learnssis]

Hi Victor, at the moment I am not providing any training. Sorry for that.