This Saturday is Code Camp in Jacksonville, FL. There are a lot of great speakers lined up, some of which you may have seen at other events such as SQL Saturday. If your free on Saturday come on out and have fun! The event is free, just make sure to sign up. All the details are on http://jaxcodecamp.com/ and the most important information will be below. I will be presenting a session with Devin Knight on Intro to SSIS. There will be several other Pragmatic Works fellows there as well. Be there o...
Read More
SSIS packages need to have the ability to be dynamic. To an extent we are able to accomplish this through the use of Configuration Files, Execute SQL tasks with results written to variables and even the use of the script task. One great way to make an SSIS connection manager dynamic is through the use of Expressions. Kyle Walker recently posted a blog here on BIDN about setting the location of an Excel file in the connection manager using an expression. This expression basically uses a location ...
By default the functions MAX and MIN do not count NULL in their evaluation of your data. If we have a column containing only dates for instance and there is a NULL date, MAX and MIN will both ignore that value. For instance, take the following data set as an example. WorkID StoreID EndDate ----------- ----------- ----------------------- 1 50 NULL 2 10 1900-01-01 00:00:00.000 3 20 1925-01-01 00:00:00.000 4 30 1950-01-01 00:00:00.000 5 40 1975-01-01 00:00:00.000 6 19 2010-01-01 00:00:00.000 7 34 2...
Executing an SSIS package from within a stored procedure is not an uncommon request. People sometimes scratch their head when it comes to figuring out if that package ran successfully or not though. There may be a process that runs a stored procedure and kicks off a certain SSIS package depending on the situation. Maybe there are parameters that were used in the stored procedure that need to be passed to the SSIS package. Either way you’ll want to know if the package executed successfully or not...