Viewing 15 posts - 9,301 through 9,315 (of 11,678 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,...
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.
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,...
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.
June 24, 2011 at 2:23 am
What happens if you change the ODBC connection to SQL Server to an OLE DB connection?
June 24, 2011 at 2:18 am
Why exactly would you want to do that?
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...
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...
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.
June 24, 2011 at 2:06 am
And here's a link: http://msdn.microsoft.com/en-us/library/ms167456.aspx
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...
June 24, 2011 at 2:02 am
Thanks for the article, I learned something new.
June 24, 2011 at 12:54 am
Viewing 15 posts - 9,301 through 9,315 (of 11,678 total)