Viewing 15 posts - 9,001 through 9,015 (of 11,676 total)
Pretty easy, since Enterprise and Datacenter always have all features 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 31, 2011 at 12:21 am
Great question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 29, 2011 at 4:27 am
You can log custom errors by using the DTS.Log command in the script task.
Make sure you enable logging on the script task, and include the specific event that captures the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 26, 2011 at 5:14 am
As far as I know, there isn't a shortcut for that.
The reason you have to open the editor first is because
* you need to configure read/write variables first
* you need...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 26, 2011 at 5:13 am
Easy question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 26, 2011 at 5:12 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
August 25, 2011 at 12:33 am
Make sure you read everything in as text.
To do that, put IMEX=1 into your connection string to the excel file (look in the properties of the connection manager).
For an example,...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 24, 2011 at 7:31 am
Are you sure it is the connection to the configuration that breaks down?
Do you get any configuration errors/warnings?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 24, 2011 at 7:29 am
You should use the script component as a source. Make sure you put the result in rows and put them into the output buffer of the script component.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 24, 2011 at 7:26 am
Are you sure the viewer isn't open, but the Windows just shows the thing somewhere in the background?
Try ALT-TAB to see if it just isn't somewhere sneeking around.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 24, 2011 at 5:23 am
I like the idea behind the question, but the question itself (and the script) could have been worked out better.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 24, 2011 at 3:12 am
Great question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 24, 2011 at 3:10 am
Do you have only one rowcount component or multiple ones? Do they write to the same variables or to different ones?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 24, 2011 at 3:06 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
August 22, 2011 at 11:34 pm
I usually have a "Run Table" for each SSIS package that needs this sort of functionality.
I would however not store only the last runtime, but all of them. This way,...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 19, 2011 at 7:21 am
Viewing 15 posts - 9,001 through 9,015 (of 11,676 total)