Viewing 15 posts - 11,161 through 11,175 (of 11,676 total)
Kit G (8/24/2010)
The title of the article says it covers the handling of NULLs in SQL 2008. Is there any difference between SQL 2005 and SQL 2008?
As far as...
August 24, 2010 at 7:30 am
Also, you can check out the website of CozyRoc. They have a lot of commercial SSIS components.
August 24, 2010 at 5:14 am
You can store the customerIDs in a table and loop over this table with a for each loop container.
In the for each loop, you can configure in Variable Mappings that...
August 24, 2010 at 5:04 am
You can store the file path in a variable. Use an Excel source with an Excel Connection Manager to read out the Excel file. Then use this variable in an...
August 24, 2010 at 5:01 am
Aarathy (8/24/2010)
Hi,I just want the rowcount to be captured in log file(.txt file) for reference. So in this case,my execute SQL will not fit in. Right?
Thanks.
Ah OK. I thought the...
August 24, 2010 at 4:14 am
Hugo Kornelis (8/24/2010)
da-zero (8/24/2010)
I would've liked a paragraph on the behaviour of NULL in COUNT(*) and COUNT(DISTINCT *).
There's not much to say about that, as COUNT(*) does not care if...
August 24, 2010 at 3:36 am
The event handler will only be fired on specific events, and even if you go with the event handler, you still have to choose between SQL or VB.NET scripting 🙂
I...
August 24, 2010 at 3:30 am
Luckily I have SSIS open 🙂
Use the ResultSet property --> Single row
With this you can set the result of a query to a variable. Configure this in the Result Set...
August 24, 2010 at 3:26 am
You can just insert the variable in the log with a simple SQL INSERT statement.
Or, you can write OnInformation events to the log and extract the numbers there.
August 24, 2010 at 3:22 am
Carlo Romagnano (8/24/2010)
One way to avoid worrying about NULLs is never to use them, always declaring columns as not allowing NULLs and designating default values for "empty" or "unknown". This...
August 24, 2010 at 2:35 am
Nice article. It summarizes a lot of pitfalls, but I would've liked a paragraph on the behaviour of NULL in COUNT(*) and COUNT(DISTINCT *).
August 24, 2010 at 12:00 am
kevin.l.williams (8/23/2010)
Interesting that this does not work the same way.select datalength(convert(varchar, getdate(), 101))
See http://msdn.microsoft.com/en-us/library/aa258242(v=SQL.80).aspx.
When n is not specified with the CAST function, the default length is 30.
August 23, 2010 at 10:48 am
It seems that there is a problem with your logging in SSIS.
How did you configure your log provider?
August 23, 2010 at 3:24 am
At first sight, I can't spot any errors either in your expression.
Are all the quotes still there, or are some of them replaced with empty strings?
August 23, 2010 at 2:58 am
Viewing 15 posts - 11,161 through 11,175 (of 11,676 total)