SQL Server Integration Services (SSIS) Development Tips

Here are some SSIS devlopment tips and tricks.

-Before debugging your solution re-save it or Visual Studio is more likely to crash.
-Editing package configuration documents in Visual Studio (Click Here)
-Making SSIS packages portable. (Click Here)
-more to come...

Comments

Post a Comment

Popular posts from this blog

Add User As Local Administrator On Domain Controller

I recently was settting up a new Microsoft SharePoint 2010 machine and had promoted the machine to a domain controller before creating my SharePoint admin accounts.  I needed to add several of my accounts to the local Administrators group.  Unfortunately after you promote a server to a domain controller you can no longer access the GUI for Local Users and Groups.  Instead I had to use the command line to add the users. Open a command promt using the "Run as administrator" function and then run the following command. net localgroup Administrators /add {domain}\{user} Note: do not include the {} brackets.
Read more

An error occurred while applying security information to

While attempting to move files from a hard drive I recovered I kept getting the following error on a specific set of files. An error occurred while applying security information to {G:\Folder} Failed to enumerate objects in the container. Access is denied. In order to fix it did the following. -Open a Command Prompt "As Administrator" -Run the following commands: takeown /f "G:\folder" /r /d y icacls "G:\folder" /grant administrators:F /T
Read more

Horizontally Scroll A Large Power Apps Gallery

Image
So you have a lot of data to display but the screen in Power Apps isn’t large enough. My friend Ronald Sease recently showed me how to create a gallery in Power Apps that you can scroll horizontally. It’s a simple but powerful solution utilizing a horizontal container and a vertical gallery. Demo Instructions First add a Horizontal container to your screen. Set the LayoutOverflowX property on the Horizontal container. LayoutOverflowX = LayoutOverflow.Scroll Add a Vertical gallery within the horizonal container you created. Set the following properties on the Vertical gallery. ShowNavigation = true (this isn’t required but the navigation buttons make it much easier to move up and down the list when the up/down scrollbar is off the screen.) Height = Parent.Height (if you are using the Show Navigation option then set this to Parent.Heigh - 20 so that the navigation buttons are not covered up by the scroll bar.) LayoutMinWidth = 1000 (This value needs to be larger th
Read more