Uncategorized
-
SSIS validation Errors and Resolution
Recently I received a new laptop at work with windows 7 on it. Having BIDS 2008 installed. I wanted to test an existing SSIS package (stored on our network) that others developed months ago. But I can’t execute this package on that machine as I get this error: OnError,SQL1V5,MyDomain\MyAccount,Execute Source To Common Package,{BD5416B7-B16A-4788-99C9-5A1F674E326B},{E4B9AD56-627E-4801-A262-C9EFA9F163AC },11/21/2006 4:11:31… Continue reading
-
SSIS insert and update rows in a table based on the contents of a Excel file
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
-
SSIS – Download FTP files, loop through files and insert into database
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
Vision Binary 