Yes possible Ssrs report manager-select published reports - Manage-vSubscription tab - new data driven subscription Delivery method as email. You can also schedule when you want to deliver the email
I am using c# script to convert excel to . Txt file in ssis due to the quality of data and the format of the source file i am unable use excel source directly in my Ssis. The package is working fine in my local but in the server for the bigger file size i am getting unexpected termination as soon as excel sheet reader starts. I have even installed an access engine on my server but no luck. I tried to deploy as file system then I am getting error in my Dynamic variable. I have created a ExcelFilePath variable to dynamically read the excel files during run time but during validation itself it's failing with the error reason the ExcelFilePath has no data file but had been used as source or target something like this. Can you help me to resolve this issue?
Did you set the DelayValidation property of SSIS package to True ? If not then do that and try again. Also try to use try and catch blocks in script task.
@@maham4062 Can you check the version of SQL Server. Run select @@version on the target sql server on which you are deploying your ssis into to. And the go to visual studio, go to project properties, inside solution explorer, right click on project name, go to properties, Click on Configuration properties, Check the TargetServerVersion there. It should be same whatever is the version of sql server on which you are deploying your SSIS package to.
Hi, can we send mass email using paginated report of SSRS?
Sorry, I have not worked much with SSRS. Thus not sure on that.
Yes possible
Ssrs report manager-select published reports - Manage-vSubscription tab - new data driven subscription
Delivery method as email. You can also schedule when you want to deliver the email
Good video.. but it would be better if you have imported csv file which has more commas in it, by that we would know is it handling or not.
Yeah you are right. I should have converted that csv file with extra commas.
hi Aqil, what about excel to csv?
If you have an excel file, just save it as comma delimited (from file type) file. It will be saved as csv.
I am using c# script to convert excel to . Txt file in ssis due to the quality of data and the format of the source file i am unable use excel source directly in my Ssis.
The package is working fine in my local but in the server for the bigger file size i am getting unexpected termination as soon as excel sheet reader starts.
I have even installed an access engine on my server but no luck.
I tried to deploy as file system then I am getting error in my Dynamic variable.
I have created a ExcelFilePath variable to dynamically read the excel files during run time but during validation itself it's failing with the error reason the ExcelFilePath has no data file but had been used as source or target something like this.
Can you help me to resolve this issue?
Did you set the DelayValidation property of SSIS package to True ? If not then do that and try again. Also try to use try and catch blocks in script task.
@@learnssis
Yes I did all these.
@@maham4062 Can you check the version of SQL Server. Run select @@version
on the target sql server on which you are deploying your ssis into to. And the go to visual studio, go to project properties, inside solution explorer, right click on project name, go to properties, Click on Configuration properties, Check the TargetServerVersion there. It should be same whatever is the version of sql server on which you are deploying your SSIS package to.
@@learnssis yes both are SQL server 2019.