Recently My project is create monthly ETL package. I checked former packages in the same project, they have the same component-control flow, data flow, and package variables. I also checked the parameter’s GUID, found that they are the same. So things turns to much easier by just copy and paste packages in the project.(And I… Continue reading

Originally posted on SQL Erudition: The default connection string for a OLEDB connection looks something like this – Data Source=(local);Initial Catalog=ReportServer;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;Application Name=SSIS-DemoOLEDBPackage-{9758C970-4AAC-449E-8390-FA7EAC5CD52A}(local).ReportServer;   Notice the Application Name parameter in bold font. It has the name of the package, a unique Id for the connection, the SQL server name and the database name. This… Continue reading

Originally posted on It's Smee Blog: Lets imagine you have an Excel file of First name, Surname, and Age. Also contained in this file is a unique identifier (UID), here is an example: ID First Surname Age 1 Bob Smith 12 2 Tom Stoner 34 3 Brenda Jones 45 Now, lets continue to imagine that… Continue reading

Originally posted on BI and Data Analytics: Recently, one of my clients asked me to create an SSIS package that will accomplish these tasks. 1. Connect to FTP site and download multiple zip files using wild card string 2. Unzip the files into a folder 3. Read through each file and import the data into a… Continue reading

Fantastic day in Sears center~ Continue reading