Another BI & Programming Blog - Jason Yousef

Today's issue that we've a source database Sybase ASE, and old version is being used as a replica, I'm trying to extract some records, it's almost 750K to 1 Mil records and it needs to be exported to flat files and sent somewhere for further processing. The files has to be no more than 10K records a file and it needs to get a specific naming convention... I've done it differently than what I'm showing in the demo here... and I'll explain why... the main component in the package is the "For Loop Container", then inside the container I'll have a "Data Flow Task". I'll create 4 variables as shown below..       Add a "For Loop Container", configure as attached.. to use the variables and set the limit to 100K here        Basically the first task, is a "Script Task", I'm only using it to debug my variables in a message box, enable or disable to debug, you could use "BreakPoints...

Just a quick note to save time over appearance and save on memory when you start BIDS or SSMS. By adding ( -NoSplash ) switch at the end. The same trick can be applied to all versions of Visual Studio and SSMS (SQL Server Management Studio) by the way.

Hello, VS 2008 is acting up lately on me! nothing happens when you click on "server explorer" from the VIEW menu, or press "Ctrl + Alt + S". The fix is to open a Visual Studio Command Prompt   and run   devenv /resetsettings or devenv /setup

Today while I was updating a SSIS package and was ready to upload it to the MSDB, I noticed that "Save a copy as" is not an option under the FILE menu, Referring to my earlier post: Server Explorer not showing up on Visual Studio 2008 , looks like the settings reset must have erased it. the fix is to add it back on the menu!