Viewing 15 posts - 9,001 through 9,015 (of 11,678 total)
Pretty easy, since Enterprise and Datacenter always have all features 😀
August 31, 2011 at 12:21 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...
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...
August 26, 2011 at 5:13 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,...
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?
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.
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.
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.
August 24, 2011 at 3:12 am
Do you have only one rowcount component or multiple ones? Do they write to the same variables or to different ones?
August 24, 2011 at 3:06 am
Nice question, thanks.
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,...
August 19, 2011 at 7:21 am
Viewing 15 posts - 9,001 through 9,015 (of 11,678 total)