Displaying posts tagged with

“Data Flow Task”

SSIS Package to generate MailProfile script

SSIS Package to generate MailProfile script. There is no provision to generate script for mail profile in sql server. but i have one script that can be used to create mail profile, mail account and map them together. I am using this script whenever i needed it, letter i have an idea to start scripting [...]

SSIS Package with Dynamic ADO Connection

SSIS Package with Dynamic ADO Connection. I have created a package that collects database information from different instances all over the network and stored in one central database table. For this, I have collected Server Name, Database Name, Logical File Name, Physical File Name and File Size in MB. I have stored all instance info [...]