Displaying posts categorized under

Script Task

Create tables schema to another database using SMO

Create tables schema to another database using SMO. I have created a package which will create table script to your physical path and also executes same thing on another database to create table schema.

SSIS Package to Backup Jobs, Operators and Alerts Script using SMO

SSIS Package to Backup Jobs Script using SMO. This package willl use some SMO reference and generates SQL Server Jobs, Operators and Alerts script backup. I had written the code for SQL Server Jobs only and commented code for Operators backup and Alerts Backup. You just need to replcace Operators or Alerts instead of Jobs. [...]

SSIS Package to Backup Replication Script using SMO

SSIS Package to Backup Replication Script. Hi, This package willl use some SMO reference and generates SQL Server replication backup script same as you do it manually like, Right click on Publication –> Generate Scripts…. I have created SSIS package that automatically creates backup folder for current date and save your all replication publication script [...]

SSIS Package to get Table Schema Discrepancy using XML

SSIS Package to get Table Schema Discrepancy using XML. I have created package which uses XML in Execute SQL Task and compares two table’s schema discrepancy. You can use this script to compare table in different instances with different database or in same instance with difference database or in same instance with same database. You [...]

SSIS Package to Call Web Service

SSIS Package to Call Web Service. You can Call WebService from SSIS package and transfers your data. First of all you have to create web service with function as  you needed to call. Step1 : Go To Microsoft Visual Studio –> New –> WebSite –> ASP.Net WebService and provide you web service name. Step2 : [...]

SSIS Package Foreach Loop with File Connection

SSIS Package Foreach Loop with File Connection. This package gives you an idea to get file details and variable mapping between Foreach Loop Container and any inner task contains in loop (here inner task is Script Task). Step1 : Drag Foreach Loop and script task from SSIS Toolbox. Step2 : Create one variable with name [...]

SSIS Package to get Disk Space Info with WMI and Script Task

SSIS Package to get Disk Space Info with WMI and Script Task. In Previous blog i have created SSIS Package to get Disk Space Info with WMI.(Link: http://nirav.extreme-advice.com/2013/02/20/ssis-package-to-get-disk-space-info-with-wmi/) That was a simple way to gather disk space information with importing data in CSV file and exporting data in database. I have used same table in [...]