Being a dumb ‘merican, I think the lower case thorn character is 0xFE while upper case is 0xDE. This will become important soon. I created an SSIS package with a Flat File Connection Manager. I pointed it at a comma delimited file that looked like col 1,col 2,col 3 This allowed me to get the … Read more
Here is one possible way of loading this file into SQL Server. Below shown example reads the contents of EDI 823 Lockbox file and loads into multiple tables along with the relationship. I am sure that there are other better ways of doing this. This is just one example of loading an EDI file into … Read more
Summarized: INSTALL 32 bit version of Microsoft Access Database Engine 2010 Redistributable. Uninstall 64 bit version if previously installed. http://www.microsoft.com/en-us/download/details.aspx?id=13255 The Excel connection manager is trying to use the ACE OLE DB provider in order to access the Excel file when the version is above 2007 (xlsx). Although your box is 64-bit, you’re using SQL … Read more
Looks like you have the right idea in general and the link @Speedbirt186 provided has some good details but it sounds like there are a couple of nuances that I thought I might point out in regards to flow and variables. The foreach loop can assign the entire path or the file name or file … Read more
Solution: Set the property RetainSameConnection on the Connection Manager to True so that temporary table created in one Control Flow task can be retained in another task. Here is a sample SSIS package written in SSIS 2008 R2 that illustrates using temporary tables. Walkthrough: Create a stored procedure that will create a temporary table named … Read more
The code from @garry Vass, or one like it, is going to be needed even if you’re using SSIS as your import tool. Within SSIS, you will need to update the connection string to your flat file connection manager to point to the new file. Ergo, you need to determine what is the most recent … Read more