Viewing 15 posts - 4,261 through 4,275 (of 11,676 total)
SSIS can do this pretty easy with the export column transformation.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 12, 2013 at 2:06 pm
1. It depends on the connection manager used. This blog post explains it quite nicely:
Exploring the System.Object Package Variable[/url]
2. You can either iterate it using a for each loop (storing...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 12, 2013 at 1:33 pm
SSIS 2012 has two deployment models: package deployment model and project deployment model.
Package deployment model is exactly the same as SSIS 2008, so if you choose this model your migration...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 12, 2013 at 1:28 pm
Let's first state that I find this a terrible idea, but maybe you have a valid use case.
You can start an SSIS package either by calling dtexec.exe directly from the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 12, 2013 at 1:25 pm
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 12, 2013 at 12:47 pm
Great. Glad you got it solved and thanks for posting back.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 11, 2013 at 12:35 pm
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 11, 2013 at 12:33 pm
Thanks for the question.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 11, 2013 at 12:27 pm
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 11, 2013 at 12:22 pm
That's why the CONVERT function exists.
You might want to format the datetime a little bit differently.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 6, 2013 at 5:44 am
Satu (11/6/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 6, 2013 at 4:38 am
Please do not crosspost. It wastes peoples time and fragments replies.
Original thread with replies:
http://www.sqlservercentral.com/Forums/Topic1511755-3077-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 6, 2013 at 4:01 am
You already have queries, so what's the question?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 6, 2013 at 3:59 am
Odd. One would think a space and an empty string are not the same.
Thanks for sharing.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 6, 2013 at 2:48 am
The data type of the variable should be integer.
Make sure you select single row result set in the Execute SQL Task.
If you want it as a date, I would cast...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 6, 2013 at 2:19 am
Viewing 15 posts - 4,261 through 4,275 (of 11,676 total)