Anticipated recources for the premier Microsoft Business Intelligence certification (MCITP BI) for SQL Server 2005 are fading from Microsoft. I recently was made aware from Amazon that a book I pre-ordered titled "MCITP Self-Paced Training Kit (Exam 70...
I needed to figure out how to get SSIS to consume a file that had lines of data with attributes of both "apples" and "oranges". No matter where I looked online, it was as if SSIS could not take in a file that had different types of data on each line and...
Recently I posted a script that allows you to download a CSV file to SSIS through HTTP Authentication, today, I'm posting a slightly different script that uses some XML references in order to download an XML file. You can probably use the other way that...
I recently needed to perform a download of a CSV file with HTTP Authentication in SSIS to a CSV file. Its possible, but I needed a script to do it. I couldn't use an HTTP connection because nothing in SSIS would consume it. Nothing, including the File...