Viewing 15 posts - 9,301 through 9,315 (of 11,676 total)
nakkeeran.kannan (6/23/2011)
http://arookiebidev.blogspot.com/2011/06/validation-in-ssis-package.htmlI wrote a blog on data validation in SSIS package using script component.Hope this will be of some use to you.
Cheers,
NK
Your blog describes data validation on data types,...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 24, 2011 at 2:37 am
Oh yeah, I forgot: SSIS does play nicely with temp tables, you just need to use the RetainSameConnection property I mentioned earlier.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 24, 2011 at 2:33 am
You can mimic a transaction in SSIS by using an Execute SQL task at the beginning of your package with the command BEGIN TRAN.
At the end of the control flow,...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 24, 2011 at 2:33 am
I don't think there's built-in capacity for that, so you'll probably have to resort to a script task for that.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 24, 2011 at 2:23 am
What happens if you change the ODBC connection to SQL Server to an OLE DB connection?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 24, 2011 at 2:18 am
Why exactly would you want to do that?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 24, 2011 at 2:17 am
ashish.mehrotra (6/16/2011)
I am not wasting any 1's time, just seeking help so as to solve my purpose.
What if I spend some of my time researching this topic and typing in...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 24, 2011 at 2:13 am
What is the datatype of the source?
What is the datatype of the destination?
Also, be aware that using the conversion component doesn't actually convert the column, it rather makes a copy...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 24, 2011 at 2:08 am
It would suprise me that right-clicking on a task and selecting "Execute Task" would also start other tasks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 24, 2011 at 2:06 am
And here's a link: http://msdn.microsoft.com/en-us/library/ms167456.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 24, 2011 at 2:04 am
You have two options:
1. You have only one time dimension, but with different attributes that describe the "various possibilities." If needed, you can use role-playing dimensions to split that singe...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 24, 2011 at 2:02 am
Thanks for the article, I learned something new.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 24, 2011 at 12:54 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 24, 2011 at 12:42 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 23, 2011 at 3:14 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 22, 2011 at 6:55 am
Viewing 15 posts - 9,301 through 9,315 (of 11,676 total)