Today I was using the SQL Task and I needed to use a where clause in my SQL statement. It was easier then I thought. Here are the steps for the test. Of course the db that we use is AdventureWorks Step 1: Create a new OledbConnection Create a new Oledb Connection that points to the AdventureWorks Database Step2: Create a SQL Task...
posted by
on
to
()
This week I had some problems with the ExcuteSqlTask. I had a SQL task that executes a stored procedure that returned a resultset. I always received the error '[Execute SQL Task] Error: The result binding name must be set to zero for full result set and XML results.' This means that you need to set the Result Set Name to "0" on the...
Today I was using the NodeList ForeachContainer and I wanted to extract 2 values of a node and store it in Variables. This was more difficult than I expected. I will show how we can do this by an example. So we will create directories based on a XML Remark: We will hardcode everything in our package. Here is the XML: <?xml version...
posted by
on
to
()
Today I was doing some performance optimalizations of a SQL statement. The problem was that the SQL was generated in the application and that there where no new lines in the SQL statement that make it hard to read it. So I searched a tool that did this for me. I found cool tool that can do this called SQL Formatter . The online version...
posted by
on
to
()
If you want to learn more about how the sql optimizer works you should check out the blog of the SQL Query optimizer team. The last post is about an undocumented features of the UPDATE STATISTICS statement. This undocumented feature can help you to learn more about the SQL optimizer. DON'T USE THIS FEATURE ON PRODUCTION SYSTEMS IT...
posted by
on
to
()