I have had to do this on many occasions, unfortunately the Oracle website is not particularly helpful when trying to determine what you need. You need to download a copy of “ODTwithODAC1120320_32bit.exe” which can be found at: http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html The 64-bit version is of no use, the 32 bit drivers will work just fine. Install this … Read more
Here is a sample package created using SSIS 2008 R2 that explains how to import a flat file into a database table. Create a fixed-width flat file named Fixed_Width_File.txt with data as shown in the screenshot. The screenshot uses Notepad++ to display the file contents. It has the capability to show the special characters like … Read more
Fast Parse is a much more elegant solution Add a Data Conversion Data Flow Component. Right click, Show Advanced Editor… Goto Input and Output Properties Expand Data Conversion Output and click on the date column Set FastParse to True in the Custom Properties Make sure the data type is set to database date [DT_DBDATE] Run … Read more
After more research and trial-error, found that the SSIS package ignores the breakpoints in a Script Task when debugging on a 64-bit machine. To fix it – Go to the Solution Explorer Right click your SSIS project node > Properties In Configuration Properties > Debugging > Debug Options > Set Run64BitRunTime to False. After making … Read more
Screenshot #1 shows few points to distinguish between Merge Join transformation and Lookup transformation. Regarding Lookup: If you want to find rows matching in source 2 based on source 1 input and if you know there will be only one match for every input row, then I would suggest to use Lookup operation. An example … Read more
It usually happens when Allow Nulls option is unchecked. Solution: Look at the name of the column for this error/warning. Go to SSMS and find the table Allow Null for that Column Save the table Rerun the SSIS Try these steps. It worked for me. See this link
I’ve become a fan of using biml to solve these sorts of problems. Download and install BIDS Helper Add a new biml file to an existing SSIS project Disable Visual Studio’s auto-fix for XML files. See Overcoming BimlScript Copy and Paste Issues in Visual Studio Paste this code into that Bimlscript.biml file Fix your source … Read more
By default, two tasks are constrained by the Constraint of Success. That is, the first thing must generate a success value before the second thing will get the signal to start. You have a binary set of Data Flow Tasks feeding into a single Execute SQL Task. The Execute SQL Task is waiting for both … Read more
have a look: the links have more details, but I’ve included some text from the pages (just in case the links go dead) http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/97144bb2-9bb9-4cb8-b069-45c29690dfeb Q: While we are loading the text file to SQL Server via SSIS, we have the provision to skip any number of leading rows from the source and load the data … Read more
By “Running,” I assume running from agent/command-line is failing? It should work from within BIDS/SSDT. The short answer is the DLL must be registered with the GAC or you can download the source code and add that project into the script task and then reference said project. Looking at the project, it should be a … Read more