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!
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)
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?
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.
In this video I have shown how to do incremental load using sql query. You can take a look at it th-cam.com/video/-rMDmD7GNtE/w-d-xo.html And if you want to delete duplicate records then you can check this one th-cam.com/video/8ohs43g9X5Y/w-d-xo.html
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.
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.
Thank you so much for addressing my question sir. I got the concept now!! Very helpful video 👏🏻😊
You are welcome Achu vlogs. Good to know that you liked the video.
Superb. Got a good knowledge of the object data type variable from this video.😊Thanks
Thank you Asif, good to know that it helped you.
Does it make sense when there is a lot of records to update, to use this for each container calling the stored procedure?
I was looking for this recently. Thank you!
Yeah you can do that.
@@catulopsae Glad you find it here.
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!
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)
Great video as usual. Keep them coming!
Thank you Brian.
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?
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.
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
In this video I have shown how to do incremental load using sql query. You can take a look at it
th-cam.com/video/-rMDmD7GNtE/w-d-xo.html
And if you want to delete duplicate records then you can check this one
th-cam.com/video/8ohs43g9X5Y/w-d-xo.html
sir only id is duplicate but rest of the records are changed@@learnssis
Hi Aqil, thanks for u r videos
if u have time please make video on SCD type 3 and type 2
thanks in advance
Hi, I have made a video on SCD Type 2 below
th-cam.com/video/7uj463csru0/w-d-xo.html
I will check on SCD Type 3 as well.
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.
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.
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.
I need training .. can use pls help . I need paid training
Hi Victor, at the moment I am not providing any training. Sorry for that.
Great vídeo
Thank you so much.